I am using Crystal reports version 11.2 to create reports. The data source is SQL Server, and I am using views rather than reporting directly from tables.
I apply selection criteria to the incoming records at record level and at group level. For example, I may select all bill lines with a receipt date within a certain date range. This results in a list of bill lines within that date range.
The records are grouped and values on the records summarised at group level, on the group footer, using the Crystal reports summary facility. You would expect the amount shown to be the total of the date-restricted records, but instead it is the total of all records.
In other words, the selection criteria are not applied to group summary fields.
The above problem only occurs when I run the report from within a C#.Net application. When I run the report within Crystal, it is ok.
I could create a formula for each summary and include the selection criteria within the formula, but I have a lot of reports that need changing, some of them complex with lots of formulae, so it would take ages and make the reports more complex than they have to be. And I can't believe that you are supposed to do that.
Does anyone know if there is there something I should be setting, or something???
Thanks