470,594 Members | 1,131 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

Crystal reports does not apply group level selection to group summary fields - how ca

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
Feb 17 '09 #1
1 4594
I am also facing the same problem. Not able to pass selection fomula from my winform. but the same formula is working in crystal reports

Anybody knows
Mar 31 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Robert Schuldenfrei | last post: by
2 posts views Thread by Alx Sharp | last post: by
2 posts views Thread by Andrew | last post: by
4 posts views Thread by Brian Henry | last post: by
1 post views Thread by Tim_Mac | last post: by
3 posts views Thread by Tmuld | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.