How to create vertical reports in Cognos Impromptu?

February 9, 2006 8:55 AM

I'm working on some reports in Cognos' Impromptu and I'm trying to figure out how to create a vertical report. Is this possible?

Rather than have the column headers run across the top of the page with the data listed underneath, is there a way to align a report so that the summary names run vertical along the left side of the page with the retrieved data to the right of that?

So rather than:

FIRST NAME LAST NAME TOWN AGE
Jimbob Smith New York 45

I'd like:

FIRST NAME Jimbob
LAST NAME Smith
TOWN New York
AGE 45

posted by parttimesaint to computers & internet (2 comments total)

Not that I know of. Maybe run your query, export to Excel and then Transpose?
posted by moxyberry at 11:40 AM on February 9, 2006

Use a form frame rather than a list frame. You'll need to add your own labels, but you can make the layout whatever you want.
posted by SPrintF at 6:37 PM on February 9, 2006