CE-10/Dot-Net App - Page Change reruns entire report

[MJRBIM]

CE-10 (PRO), Dot-Net application, ORACLE 9i stored procedure as Datasource.

We are pretty current with Service Packs and Hot Fixes on the Dot-Net and CE servers.

Dot-Net application calls a report to view-on-demand from CE-10 (PRO) Page/Cache not RAS service. The report is based on an ORACLE 9i stored procedure.

First page of a multi-page report generates in the viewer after a few seconds. That's OK.

PROBLEM - When changing pages in the viewer, the reports regenerate completely before opening the next page, rather than just serving it from the cache.

When you look in Oracle, the call to the stored procedure is done on every page changes....so it appears to be re-executing the entire RPT process for each page, rather than serving it from the cache.

Anyone seen this before, and if so any ideas...?

TIA for the help.

 

[synapsevampire]

I believe that Crystal uses a ref cursor to pull data from Oracle SPs, and will perform the appropriate fetch.

I used to use a cheat to force Crystal to determine the total number of pages for the report on the first page by using the totalpagecount on the first page, such as a page footer with:

pagenumber&" of "&totalpagecount

See if that helps.

-k

 

[MJRBIM]

synapsevampire -

We are already using the "Page X of Y" special field on the footer of each page of the RPT file...

We are now going to try removing it from the footer to see if it resolves our problem.

This issue doesn't happen when you view the same RPT file on-demand from ePortfolio. Therefore, I think that the issue may be related to the using Page/Cache services rather than the RAS for report generation from Dot-Net.

Any other ideas would be appreciated.

 

[vidru]

Try the CE/.NET samples:

http://support.businessobjects.com/fix/samplescr.asp#02

-dave

 

[MJRBIM]

This issue was fixed by applying CE-10 Service Pack 2.

 

[pelajhia]

mjrbim or synapsevampire -
Can you point me towards a basic doc on running ce managed reports via .net?