Birt Viewer report is different from preview report

coolit242

Hi,

I'm a newbie to BIRT reporting and I'm trying to convert SQL Server reports into BIRT reports because of some limitations in SQL Server reporting services. I have created a report which looks fine in BIRT Designer preview but when i run the report in Web Viewer the report is messed. instead of 2 pages (Preview) it created 12 pages in Viewer and it added page breaks and also repeated the text thrice. I tried running the report in Word, Excel, PDF, etc and it showed up differently (data repeated multiple times and also number of pages differed) in different applications but the Word looks fine. My ultimate goal is to deploy the BIRT reports in Tomcat server and so I have to stick with Web Viewer. I would appreciate if someone can please respond to this ASAP as i'm on a deadline to get this up and running pretty quickly.

CBR

Hi,

you have two different servlets in the BIRT Web-Viewer. One is called frameset the other one is run. frameset adds some control elements and splits the report to multiple pages. run is only one page pretty much comparable with the preview in the designer.

There is another one called preview which is exactly what you see in BIRT Designer when layouting the report. Preview has one limitation: It only fetches 500 rows from each dataset in your report. If a dataset has more then 500 rows the output the report is missing data. For run and frameset all data is fetched for all datasets which is what we want.

For more informations see the official documentation: http://www.eclipse.org/birt/phoenix/deploy/viewerUsageMain.php#servlets