Wrap the report row-wise

Friends,

For instance, I am selecting 20 objects(columns) and run the query. It gives a lengthy report and it is very difficult for the user to analyze the report by scrolling. I realize that if it is within 80 columns it will be useful.
Now, I need to break the report. i.e first 10 columns should be in first row (horizontal) and the other 10 columns should be in the next row. Herewith i give sample report.

The Sample Report: (first record)
… col1: value1 col2: value2 col3: value3 … .col10: value10 col11: value11 …
.col20: value20

(second
record)
… col1: value1 col2: value2 col3: value3 … .col10: value10
col11: value11 …
.col20: value20

If u give any suggesstions, I would be glad and appreciate. Thank Q.

Ravi.

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com


Listserv Archives (BOB member since 2002-06-25)

In a message dated 98-09-21 17:25:43 EDT, you write:

For instance, I am selecting 20 objects(columns) and run the query.
It gives a lengthy report and it is very difficult for the user to analyze the report by scrolling. I realize that if it is within 80 columns it will be useful.
Now, I need to break the report. i.e first 10 columns should be in first row (horizontal) and the other 10 columns should be in the next row.

Ravi:

You can “wrap” a row into two rows quite easily. Most of these steps will be faster if you display the report in “Structure” mode rather than “Full Results” mode.

  1. Click on the first column value (data, not the header) 2. Click on Insert, and select Row (below). This will give you a new row with 20 columns in it.
  2. Drag column # 11 into the new spot under column #1, repeat for 12 - 20. 4. Delete the now empty columns 11 - 20.

When you review your data, you should have the layout that you require. FYI, there is a downloadable sample report on our web site that shows the same trick to create mailing labels with BusinessObjects… although that it still easier in MS Word!

Regards,
Dave Rathbun
Integra Solutions
www.islink.com


Listserv Archives (BOB member since 2002-06-25)