I'd like to find a replacement for Crystal Reports. Oh how I dislike CR.
Ideally I'd like to find a PDF generation tool that has the following:
The WYSIWYG editor is especially important. I'd prefer to be able to hand a tool to my designer-ish person, have them build the document and place the database fields where they are supposed to be, then hand it back to me so I can link it up to the database.
Similar to this question, but I felt that question was too vague
DevExpress XtraReports do fantastic report generation, savable in pdf obviously. I use it to generate Medical reports in one of the programs that I work on. You can build the reports programmatically or via their design time GUI (They also have an end user GUI that lets reports be created/edited).