Incorrect Data showing in Report Preview and Web Viewer

On the dataset Preview - I am getting correct # of records but on the report Preview as well as Web Viewer / XLS ? I am getting 10 times more records.

Can anyone please help resolve this issue.

Thanks

Find more posts tagged with

Comments

mwilliams

Hi Pujan,

Can you recreate this issue with the sample database? If you're unable to do so, can you attach your report design? Recreating the issue with the sample db will be the better of the two so I can run the report, but I may be able to see something by looking at your report design.

averma

Hi Pujan,
Dataset preview and report preview only displays a sub set of data from the query (I believe by default it is 500). Try running your query outside of BIRT in a query browser and see how many records you get. You should expect the same number of records when you run your report in the web viewer.

Ashwini

Pujan

I ran the query outside BIRT and its returning only 58 records. I am getting correct # of records in Dataset Preview but then on Report Preview and Web Viewer, data is distributed over 60 pages... From 3rd page onwards its the same data being repeated over and over again till page 60.

I have 78 columns - not sure if the page break setting is repeating the data across 60 pages.

Please find attached the report. I have just 2 params ( Start and End date). In the attached report, I have hard coded the date to identify if the params is an issue.

mwilliams

Pujan,

It looks like if you moved your inner table out of the other table, that you wouldn't have that issue. Your data is probably getting repeated for every detail row that is expected for the dataSet that is bound to the outer table. Let me know.