Hi,
I'm new to this forum, but sadly a CrystalReports user for a number of years who thought he was doing quite well, but...
I'm putting together a standard (and simple) report which has just one grouping based on a "PLType" field I've created, and each transaction will have it's own PLType value.
The PLType field will contain either a:
001, 101, 201, 301 or 401
And the report will group the records based on this text value, and produce a sub-total for each group.
But not every instance will be reported as some records will be excluded based on other criteria. For example, my report might only contain groups 101, 201 & 401 or maybe just 001, 101 & 201 etc
The problem is I need to display a running total of all records from 001 to 301 inclusive, to display the total, called "Contribution" after the last of these groups shown on the report, and before the 401 group (if it exists in the report.
If it makes a difference, the data is SQL.
Help ??
I'm new to this forum, but sadly a CrystalReports user for a number of years who thought he was doing quite well, but...
I'm putting together a standard (and simple) report which has just one grouping based on a "PLType" field I've created, and each transaction will have it's own PLType value.
The PLType field will contain either a:
001, 101, 201, 301 or 401
And the report will group the records based on this text value, and produce a sub-total for each group.
But not every instance will be reported as some records will be excluded based on other criteria. For example, my report might only contain groups 101, 201 & 401 or maybe just 001, 101 & 201 etc
The problem is I need to display a running total of all records from 001 to 301 inclusive, to display the total, called "Contribution" after the last of these groups shown on the report, and before the 401 group (if it exists in the report.
If it makes a difference, the data is SQL.
Help ??