8/29/2025 2:33:48 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Open a saved Crystal Report file
Posted: 18 Sep 09 3:29 PM
|
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
Please help.... |
|
|
|
Re: Open a saved Crystal Report file
Posted: 21 Sep 09 11:46 AM
|
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). |
|
|
|
Re: Open a saved Crystal Report file
Posted: 21 Sep 09 11:51 AM
|
Hi, you are right - it's because of the interactive features. If I can get it to open in Crystal viewer, they can filter the report themselves (or I can filter based on their selections from a form)
With an export to pdf I am probably going to have to export to over 20 different files so that they view just the data they want (and are allowed to see) |
|
|
|
Re: Open a saved Crystal Report file
Posted: 22 Sep 09 8:49 AM
|
Hi Paul,
I also have somewhat similar goal- Being able to see the report at one click from SalesLogix. I have a job that runs in KnowledgeSync every 15 minutes and sends out emails(reports) to the particiapnts.
If the participant calls for some reason- the call center reps have to run the report from SalesLogix and answer the call. I want to give other departments the ability to see the report file of the particular participant that has been emailed out.
I have copied the pdf files to a network drive- and able to open the file by putting this code on the click event of the button-which works fine.
sub main
Dim sFileName
sFileName = "V:\Test_SLX\PDA_Withdrawal_20090922050007_594430.pdf"
Invoke "Open", sFileName
End Sub
I was wondering is it possible for KnowledgeSync to output the customized name of the pdf file? Like-
PDA_Withdrawal _Loanid or
PDA_Withdrawal_ LASTNAME OR
PDA_Withdrawal_ SSN
Here LoanID,LASTNAME,ssn are database fields. Please let me know.
Thanks for all your help !
Sundari
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|