Last post Feb 11, 2011 11:27 AM by golddog
Feb 07, 2011 11:25 AM|golddog|LINK
This is really frustrating. Upgraded report to Crystal 2008, and the filters on month/year are being ignored.
This report is a simple cross-tab. We have a worker data table, with each row containing a date, a worker id, and various counts to be listed by worker, and then a summary for each row. The columns are the worker's name.
Parameters are report month and year, so I have a group filter that month(report_date) = param month and same for year.
The report does ask for the parameter input, but then ignores it and summarizes every record in the worker data across all time.
So, for example, my user Frank has data in the worker table for each month from Janaury 2008 to December 2010, and he shows up when I run the report for January 2011.
Prior to upgrading, the report worked great; it would filter out the records by input month and year and then summarize. I neither understand why this changed, nor the new right way to apply filters for cross-tabs. Anyone have any advice?
Thanks in advance.
Feb 07, 2011 12:05 PM|golddog|LINK
I forgot to mention the most frustrating part...works great in CR Developer. My record filter is honored, only the data for the selected month/year is displayed.
However, when it's displayed in a CRViewer in my WinForms app, the report then ignores the parameters. It
is smart enough to remember to ask for the parameters, it just ignores them.
Feb 11, 2011 11:27 AM|golddog|LINK
So, I figured I'd try the stored procedure approach. Wrote a proc to take the report inputs and do the filtering myself.
When I try to add the proc as my datasource, I get a message box that says
Details: ADO Error Code: 0x800a0cb3
Description: Object or provider is not capable of performing requested operation
I've used sprocs as datasources in Crystal 2008 before, but on a different SQL 2005 db instance. Both reports' providers are SQLOLEDB, so that makes me think that there's some setting in the instance I'm trying to hit with this report which disallows sprocs,
but I haven't been able to find anything.
Anyone have ideas I could try?