Crystal Reports

Debbie Weitz

We are starting our new campaign and my Custom Reports, built on Crystal Reports are no longer working. We've had them since 2004. As Blackbaud no longer supports Crystal Reports, can anyone recommend someone who does? The canned reports don't give the information our director wants/needs. I've worked with Blackbaud support and they feel the issue is within Crystal. Thank you for any help.

Marie Stark

What is the issue you are having?

Debbie Weitz

I've updated the export (and had it checked, double-checked, triple-checked, etc. for errors), but the custom report shows the previous year results in the current year column and nothing for the current year in any column.

The report is supposed to show current year to previous year gifts in/pledges. It also should show percentage of increased/decreased/new gifts and team results for current year.

Right now, all I'm getting are the results from last year in this year's column. I've attached a copy of what it should look like.

Any help would be appreciated. Thank you.

Marie Stark

I wonder if the report is linked to the correct mdb file. Is it possible you moved or renamed the mdb files?

Debbie Weitz

Blackbaud associate and I redid the MDB file 5 times to be sure I had it linked properly. I linked it and so did the associate. They think it is a corruption of the Crystal Report.

Marie Stark

I would check the settings in all of these locations:

Mark Zarbailov

If the report is pointed to a correct mdb file, perhaps the issue is with report formula or group name that has a static name "Current Year" with last year Gift Date Range.

Debbie Weitz

Thank you. I'll give it a try. ; )

Debbie Weitz

I'll look at that, too. Thank you.

Karen Diener

Start at the very beginning with the query and export. Make sure they are grouping and exporting the correct sets of data. Especially check date settings in the export. I often export my Crystal data to Excel and take a look. That way I know if the export is wrong or the Crystal formulas / selects / etc. are wrong.


Karen

Angela Tuttle

We ended up hiring REPORT GURU's to update our Crystal Reports. They are great and pricing is reasonable!