Vertical columns

[ScottOrich]

I have a simple report with many columns such as:
ID# First Name Last Name Address

What I want to do is format the report like:
ID# xxxxxxxx
First Name xxxxxxxx
Last Name xxxxxxxx
Address xxxxxxxx

This would give me one page per ID#. How can I do this?

 

[griffindm]

Scott,

Group your report on ID, right-click on the properties for the Primary List Frame, then click to show the ID footer. Then drag a copy of each of the items into this footer, size the footer to your specs, then change the property of this footer to a width of Parent. Finally, hide the displayed detail row. This should give you what you need.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[ScottOrich]

griffindm

Thanks for your help. I'm able to list my data vertically using your solution but I've lost my column headings (or should I say row headings). With 40+ rows it's difficult to quickly pick out pertenant data. Can I get use a text frame to add row headings?

 

[griffindm]

Scott,

Exactly. Just add a text frame in the page header to identify the items that appear in the footer below.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[nagrajm]

You can also do it by creating a report from a blank template and then inserting a form frame of a desired size. In the Form Property -> layout tab select Scope of data as Single row of data. Thereafter, customize the layout of the fields by inserting text frames as suggested by Dave for column titles.