Strange report behavior... multiple rows without for each or group statements??

John Bruso1

Summary

Strange report behavior... multiple rows without for each or group statements??

Content

Hi All,

I have 1 report where I have a table with 1 field and NO GROUPS. When I load the sample data and run the report I get just 1 row of results.

I get 1 row of results:

I have a second report file with similar data, 1 field and no groups. However, when I load this sample data and run the report I get all of the results as expected.

here are multiple rows:

I don't understand why my second report is able to generate a full list of results without any groups or for each statements? Now, on the second report, I do get this prompt about xslt 2.0 when I first open the report. Would this make a difference? How can I compare the underlying code between these BIP reports??

Also, both of these reports are pre-existing that I am just editing -  well, trying to edit. I need to understand why the first one is behaving differently from the second. I'm still very new to BIP so the answer here may be obvious to you.

Thanks for your help!

John

John Bruso1

Thanks. I do understand that we need to use for each statements... My confusion is that the 1 report seems to be displaying many rows of data without these for each statements.

I've attached an rtf example with a pdf of the output to the original post. The sample data has 5 rows.  I expect to see only 1 row because there are no for each statements... but instead all of the data returns. why?

Venkat Thota - BIP

You have to use  <?for-each:root element?> in order to display each record one by one ,and <?for-each-group:root element?> is different and you are giving condition to group data based on specific element (like group by in sql).

if possible upload xml and rtf files. Thanks

Follow this doc Oracle BI Publisher Consulting: XML Basic You Need to Know

Brajesh Shukla-95078

It can be corrupted rtf. It happens sometime. Request you to export your rtf to xsl-fo then search for for-each if its not present it means we are not looping it  through rtf and we can conclude that rtf it corrupted. In this can you can copy the content to new rtf and check. or if its not very big report then can create from scratch

John Bruso1

Thanks Guys, This is what we expected but wanted to confirm with you all.  Thanks for all of your help.

Venkat Thota - BIP

something went wrong with your file(might be corrupted), please recreate it and test. Thanks

In order to test this just remove whatever in template and create same without for-each , it will display only one record.