Any way to do this?

[Knight]

Hi!

I have to convert a report that was initially coded in Java in Cognos 8.

I have done many reports recently and most of what I did were lists and the report I must try to replicate is a lot more complex than a simple list.

The first page must look something like this:

Name: Doe
First name: John
DOB: 01/01/1980
Sex: Male

etc..

It looks like I could do this with singletons but is there a better way to do that?

The next pages look something like this:

Date: 05/05/2012                                     Location: Home                                                   Time: 10:11 AM
Type: Unknown
Category: Unknown                                  Description: This description is over many
                                                                                      lines, as looks as needed to
                                                                                      fit the text that was typed in.



Each record I retried must be displayed like that and I must fit as many as possible per page.

Is there a way to do something like that in Report Studio?

Thank you!

Nick

[wyconian]

Hi

You could try using a repeater table rather than a simple list.  That would repeat data on the page so you would get all the data you're looking for.

The other thing to try is adding a table to the page (so you have a table rather than a list) you can then add data items to the tabel cells in any layout you want.  It can be a bit tricky and you have to asociate the page with your query.

Try looking at the help file under repeater tables or addinging data items to a table.

Good luck

[Knight]

Hi!

Thanks, it worked quite nicely (I put a table inside a repeater).

My only problem now is that I end up having something like this at the end of the page:


Date: 05/05/2012                                     Location: Home                                                   Time: 10:11 AM
Type: Unknown
------------------------------------------------------ PAGE BREAK ----------------------------------------------------------------
Category: Unknown                                  Description: This description is over many
                                                                                      lines, as looks as needed to
                                                                                      fit the text that was typed in.



I would like to only print a new entry when it fits. Each entry can have a different number of lines so I don't know if it possible to do that or not...

Thank you and have a nice day!

Nick