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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress column in Crosstab

Status
Not open for further replies.

CRilliterate

Technical User
Dec 7, 2005
467
US
Hi,
is there way to supress column in Crosstab? Thanks


________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server
 
The Crosstab is designed that Total is Running Total of the field.
So when Column's values are displayed - Total is correct, when Column is gone - total incorrrect.

101 102 103 104 105 Total
row1 1 0 1 0 1 3
raw2 0 0 0 1 1 2

I want to see

Total
raw1 3
raw2 2


Thanks

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server
 
I solved it.
I took Raws as Rawfield (where raw1 and raw2)
and Total as Distinct Count of fields 101 102 103 104.
It only took me 1 day of a play with crosstab fields...lol

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top