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

Group by Column not row

Status
Not open for further replies.

Thant

Technical User
Dec 31, 2007
103
US
Is there a way to create a group that displays in a column not a row? I need to layout my data in something almost like a cross tab but i've never had any luck getting a cross tab to look tha way I want.

Thanks in advance


Anything worth doing is worth messing up at least 5 times before you get it right!
 
Crosstabs should be easy and their appearance can be adjusted. If you explain the problem you had, maybe someone could help.

Otherwise you'll be stuck with creating a 'Mock Crosstab'. This is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.


[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top