Difference between 'Preview' and 'History' within Enterprise

[gillonia]

CE V9.0.0.287
Database: Oracle
Viewer: DHTML

What is the difference between the 'Preview' and 'History' options within Crystal Enterprise. A couple of my reports I can view ok when using the Preview option but when I try to look at them through the History Option I get the following message:

"There was an error retrieving data from the server: Unable to connect: incorrect log on parameters. File ~ceb6c3c2e629a92c8.rpt."

However if I hit the Refresh button through the History window, then select the report I can see it ok! Has anyone seen this before and does anyone know of any way around this?

Any suggestions/comments most appreciated.
Rgds, Ian

 

[ShortyA]

Hi Ian,
the Preview button runs the report on demand (I believe using the Pager Server component). Using the History tab and clicking on instances there will retrieve them from the Output File Repository Server (basically a service that runs and retrieves reports that have already run). Is this for all reports that you are having this problem or just the two ? Are all of the reports from the Oracle database having the same problem ?
ShortyA

 

[gillonia]

Thnx for the reply ShortyA.

No, this isn't all my reports, just a couple. I have a few reports that use the same datasource which don't have this issue and work fine.

The only difference I can see are ones that don't work are more complex.

Any thoughts?
Cheers again, IanG

 

[ShortyA]

Check that the Page Server, Job Server and Output File Repository server are all running under the same account (this can be done via the Crystal Configuration Manager on the CE server).

When you say these reports are more complex how is that ? Is it that they use subreports, more formulas, database views etc ?

ShortyA

 

[gillonia]

Yeah, I had checked this out already and they're all running under the same account.

These reports all use sub-reports.

Thnx, IanG

 

[ShortyA]

In one of the problem reports are you able to suppress the subreports and then try to replicate the problem ? If they run OK then un-suppress one of the subreports and try again until you can pinpoint which report is causing the prob. Then Make the subreport into a report by itself and run it to see if it still has probs. If it doesn't then re-import the report again and save/test.

Also, have you tried using one of the other report viewers eg ActiveX as DHTML is a little unstable at times ?

ShortyA

 

[gillonia]

Hi ShortyA,

thnx again for your suggestions.

All I'm doing with the sub-reports is passing values to them in order to chart on them (As per the Charting on Print-Time Formulas technical paper -cr9_charting_print_time_formulas.pdf). If I suppress the sub-report it works fine so it definitely relates to sub-report.

I've tried re-creating the sub-report as well as saving it then re-importing it as you suggested but still getting the same issue.

Yeah, unfortunately we get the same issue using other report viewers.

Any more thoughts?
Thnx again, IanG