Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Cross Tabs and Summary Vs Running Total

Status
Not open for further replies.

heppme

Technical User
Jun 14, 2002
18
US
I am developing a cross-tab report for the dynamic column capability. There are only three rows, but a mix of summary and running totals are required. Thought the fix was to have two identical cross-tabs placed one over the other and suppress the totals as needed to display only the required numbers. However, there seems to be some issue with cross-tabs and suppression.
Has anyone tried this before and had it work? Thnks.
 
I haven't tried your approach but if you are running into
problems with it, try to instead place the two crosstabs in two sections (e.g, GF1a and GF1b) and conditionally suppress the sections instead of the crosstab.

Just a thought.

- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:
 
I must misunderstand what you are trying to do, because you can't do running totals in cross-tabs. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Thanks, both of you, for the response. I am faking a running total by changing signs in some of the detail to get the totals needed. Unfortunately, separate sections won't work as the 'running totals' are in the midst of the report. Could try many (5-6) sections and separate cross tabs for each time the report changes total type, though. I'll see if that works. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top