Crosstab - Displaying more than one column in row group 1

[ChubbyArse]

Hi All,

I'll do my best here to describe the task I'm trying to acheive.
I would like to produce a cross tab report which shows sites down the left hand side and across the top it shows 52 weeks and a figure for each site/week in the grid.
This is fairly simple to acheive by having the sitename in the row, the week number in the column and the Summary figure is the count of weekno.

However, for each site, I want to display extra information, like the Postcode, AreaNumber etc and then the summary figures begin.
Can a cross-tab report group on more than one field but keep it to one level????

SiteName Postcode Area Week1 Week2 Week3 Week4 Total
Site 1 GL4 3JK 14B 12 13 141 123
Site 2 GL2 1JK 15B 12 13 141 123
Site 3 GL3 5JK 17B 12 13 141 123
Site 4 GL6 7JK 11A 12 13 141 123

Can this be done in crystal????

Thanks

Alex

 

[GJParker]

No you can't group on more than 1 field and keep to one level.

The way around this is to change the group label to show the extra information you require.

Go into th eCrosstab Expert
select the row group and click on Group options
go to the Options tab
check Customise Group Name Field
check use a formula as group name
Click on the formula (x-2) button and enter the requierd formula i.e.

{Table.SiteName} & " - " & {Table.Postcode} & " - " & {Table.Area}

This should give you what you require

HTH

Gary Parker
MIS Data Analyst
Manchester, England