Orientation Change (90 degree pivot)

[tobypsl]

Hi

is it possible to put field headings down the first column (so the rows are labelled) rather than across the first row (so the columns are labelled) ?

I have a report with about 30 fields - it would be great if the field names could run down the rows of the first column as it just wont work the way the report is naturally oriented.

I am guessing (and hoping) this must surely be possible ???

I use CR 8.5

cheers ....

 

[synapsevampire]

Yuo better show an example as this leaves too much to the imagination.

You can expand the details section and manually place the fields under each other, and then palce a text object as a row label for each if that's what you want.

Using Crystal technical terms will be better too, Crystal has sections, such as the Detail section, it does not have rows.

Try to supply:

Database/connectivity
Example data
Expected output

-k

 

[tobypsl]

thanks fro input, just had a quick go but it displays 1 record at a time, then the next underneath. The report outputs as a table what I would like is something as follows

Record 1 Record 2 Record 3 Record 4

Date 21.03.06 23.03.06 17.03.06 25.03.06
No. 8 3 9 21
Percentage 62 73 94 18
etc / / / /
etc / / / /
etc / / / /
etc / / / /

what seems to happen with the solution you suggested synapsevampire is that record 1 is displayed, then record 2 underneath that rather than across the page.

is there really no way of changing the orientation ?

The only other way I can think of is to export the data to excel and switch it there....

 

[lbass]

Is this an inserted crosstab where you want to show labels for the summary fields?

-LB

 

[tobypsl]

no it's not a crosstab I created it as a standard report using the report expert there are no summary fields at the moment .... I'm literally just pulling info from a DB and trying to present it in the most sensible fashion ...

 

[lbass]

You could create a display like your example by inserting a crosstab and adding a field that is unique to each row as the column field, with no row field, and by then adding each field as a summary, using maximum for strings. However, you would not have the same flexibility for creating various summaries across the rows.

If the issue is the width of the page and you only want to display the report without printing, you could set the report to use a different printer that allows wide pages.

Or, you could set up the report to show the first 15 fields for records, and then the next 15, by using a subreport in the report footer.

-LB

 

[tobypsl]

thanks lbass - that makes sense. I don't have much CR experience but I think I understand how that would work. However i like to be able to manipulate the look of a report as it's something we will use every day - I'll have to review the content and see how best to split it up.