Question:
I have a report which takes ages to run
I therefore can’t open it via the application.basicfunctions.doinvoke … routine as this always refreshes the data, even if the “save data with report” option is ticked
I have the report running overnight via Knowledgesync and saving to a path on the server
I want to click a button in slx and open this file – with the data saved
I have the following code:
dim objrdc, crxreport, crxview, rptwindow
Set objRDC = CreateObject(“Crystalruntime.Application”)
Set CRXReport = objRDC.OpenReport(“filename.rpt”)
What is the next command to open the report in Crystal Report Viewer?
If I put
crxreport.printout
it tries to print to a printer – I don’t want this but at least I know the text above is ok
I’ve tried
crxreport.preview
and this errors
Answer:
Since you are already using KnowledgeSync to run the report, why don’t you output it to PDF and then just have the users open it as a PDF file rather than Crystal?
You may lose some of the Interactive features from Crystal, but since the report takes such a long time to run, it is very likely that your users can’t use those features either.
So, have the Report be exported to PDF and then pasted it on a Folder all users can have access to. (e.g. SLX Library).
