We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Supressing row totals in cross tab report

allenalvares
allenalvares asked
on
Medium Priority
1,108 Views
Last Modified: 2008-03-03
Hi,
I am using crystal reports 8.

I have a table named Invoice

Invoice_Category
Invocie_Date
Invoice_Amount

I am desiging a cross-tab report to compare the sales amount of different years based on each month, for each category.So i have a formula field Inv_year which is Year(invoice_date) & Inv_Month which is Month(invoice_date)

I have managed to build the report and it looks like this

                                        1          2        3           4          5          6            7        8  
                                     -----------------------------------------------------------------------
Catagory A      2004        500       750     350   ............
                      2005        850      900      460  ..............
                     ------------------------------------------------------------------------------------
                     Total      1350       1650     810  ................
 -------------------------------------------------------------------------------------------------------
Catagory B      2004        500       750     350   ............
                      2005        850      900      460  ..............
                     ------------------------------------------------------------------------------------
                     Total      1350       1650     810  ................
 -------------------------------------------------------------------------------------------------------

I have managed to suppress the grand totals, what i need is to suppress also the totals which are actually irrelavant to this report. Is there any option so that i can either remove or suppress the row totals.

Thanks,
Allen.
Comment
Watch Question

Commented:
- rightclick on the crosstab -> 'format crosstab'
- goto tab 'customize style'
- select your_table.category_field in the listbox 'rows'
- tick 'suppress subtotal'

--
Outin

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks a lot

Commented:
Glad I could help...

--
Outin
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.