Need help on PDF and Excel download using BO SDK (Version BOXIR3)

[Former Member]

Need help on PDF and Excel download using BO SDK (Version BOXIR3). When we run the report in Rich Client it refreshes in only 12 Sec. But when we execute the SDK code written for downloading Excel/PDf output of same report, it takes around 45 sec. i.e. 3 times more time. Can some one help in improving the performance of the SDK code. The SDK code that we use is very basic code. Report has few prompts and these prompts have been included in the SDK code. We call and execute the SDK code from another application and pass the values of prompts in it.

[DellSC · Accepted solution]

There may not be anything that can be done for this.  Here's how things work:

When you view a report in Rich Client, everything is processed inside Rich Client which does a couple of things:

1.  Renders the pages as HTML instead of converting to Excel or PDF.

2.  Shows the first page as soon as it's ready, even though it may be processing the rest of the pages.  This is part of why you see the report so quickly.

When you export a report through code, not only does the code have to take the time to convert the report to a different format, it has to render ALL of the pages in the report prior to the export.  This is the part that is probably taking longer.

-Dell