Displaying columns as rows and rows as columns
I would like to display all the data in a table on one sheet of paper in a report. I know it will all fit if I have each row of data go down the page like a column and set the paper to landscape.
Unfortunately I cannot get it all to fit by having each row go across the page with the paper set to portrait. Otherwise this task would be simple, I could set the column names in the page header field and be done with it. It is almost like I need a cross tab report but with the value of each field in the summary area instead of some calculations.
Does anyone have any suggestions how I might accomplish this?
Thanks
[622 byte] By [
dekej] at [2008-2-15]
I'm not sure that I fully understand, but vave you looked at formatting the report with multiple columns? This is one of the few ideas that I could think of that may work.
In the report designer, right click on the report to bring up the context menu. Choose Format Section and then highlight the Details section. Here there is a check box that allows you to format the report with Multiple Columns. Once you check that you need to then go to the Layout tab and define the layout for the columns.
Might take some experimenting.
You can also check out the samples available from our web site to see if any of those give you some ideas:
http://support.businessobjects.com/communityCS/TechnicalPapers/cr_sample_rpts_desc.pdf.asp
Keith - Business Objects
