Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 20th, 2004, 10:08 AM
Registered User
Join Date: Oct 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Inserting a new row in Cross Tab....

PPl -

I have a technical question regarding the limitation of CR 10.0. I will get the following dataset from Stored procedure. (Grant_Name, Class, Value). Possible values for Grant_Name are Paid,Star,Fed,General. Values for Class are New and Renewed. Value cab be any value.

My requirement is to show the data in a cross type kind of report. This will have Grant_Name on row level. Class and Value on Column level. And the summarized field will be Value. the lay out is some thing close to below...

(Please note that Sub-Total is the new row i'm looking to insert...which is a sum of Paid,Star and Fed....Can we tweak Cross Tab to insert a new row? Or do i need to use Sub Reports for the new row?
Report Section
                  New Renewed
                  Value Value
Paid 1 2
Star 5 3
Fed 7 32
 SubTotal 13 37
General 10 12
TOTAL 23 49

If i use a cross tab with Grant_Name on Row, Order_Class & Value on Column with Value as summarized field , i'm not able to achieve the "SubTotal" row which is essentially a sum of (Paid,Star and Fed) values.... how can i achieve this using Cross Tab? Can we do this cross tab or DO i need to work with some other method? I'm out of ideas..is there any suggestion?

As an FYI... I just gave u a short part of report...the original report will also have Level_Indicator on row wise..It means that the above report model will be repeated for Level1, Level2 etc which is given by another field...I did not give those details as i thought it is not really needed....

Please give me any suggestion..


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Header For Cross Tab Report In Crystal Reports padma_eedara ASP.NET 1.0 and 1.1 Basics 1 October 18th, 2006 04:35 AM
how to sort cross tab.sort based on row total joxa83 Crystal Reports 7 March 2nd, 2006 09:12 AM
cross tab help drachx SQL Server 2000 3 October 24th, 2005 03:26 PM
help with cross tab kondapally Crystal Reports 0 August 25th, 2005 09:11 AM
cross tab s_a_ravi BOOK: Professional Crystal Reports for VS.NET 0 February 17th, 2005 06:49 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.