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!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: Export Report

Rodrigo Ginyaume
Posts: 20

Export Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Nov 06 3:13 PM

Good Evening everyone!

I have the following doubt:
I want to insert in the whenOpen event (Manage - Reports - Execution ) some code that can allow me to export automatically the report in a pdf format. Does anybody know how to do this ?

Thank you.

[Reply][Quote]

LaNae Christenson
Posts: 23

Re: Export Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Nov 06 7:52 AM

While not a direct solution, if you have KnowledgeSync, it can automatically run the reports, export them to PDF, and either email or copy the files to a location of your choice. Good luck...

[Reply][Quote]

Rodrigo Ginyaume
Posts: 20

Re: Export Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Nov 06 9:40 AM

Thanks for your reply! Unfortunatelly, our client didn´t buy knowledgeSync product.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Export Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Nov 06 6:56 AM

Quote:

Originally posted by Rodrigo Ginyaume

Good Evening everyone!

I have the following doubt:
I want to insert in the whenOpen event (Manage - Reports - Execution ) some code that can allow me to export automatically the report in a pdf format. Does anybody know how to do this ?

Thank you.

Something close to this (request) came up on the Slx Partner's NG yesterday....
My response was:
Take a look at the Lan Dev Ref (chm) file (Downloadable off the SalesLogix Support site). Do a search for RDC and you will find:
Application.BasicFunctions.GetCrystalReport
and an example of how to use it to create pdf's
.--
rjl

[Reply][Quote]

Rodrigo Ginyaume
Posts: 20

Re: Export Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Dec 06 1:33 PM

With some help I´ve found a solution. I give you some code and if someone has some trouble please contact me...

Dim objRDC
Dim filesys, strpath, strReportFile, randomName
Dim AccountID
Dim objAC

Set objAC = Application.MainViews.ActiveView.DetailsView
AccountID = objAC.txtAccountId.Text
set filesys = CreateObject("Scripting.FileSystemObject")
strpath = "C:\Program Files\SalesLogix\Reports\"
If Not filesys.FolderExists(strpath) Then
filesys.CreateFolder(strpath)
End If

strReportFile = strpath & randomName & ".pdf"
If (filesys.FileExists(strReportFile)) Then
filesys.DeleteFile(strReportFile)
End If

Set filesys = Nothing

Set objRDC = CreateObject("CrystalRuntime.Application")

Set CRXReport = objRDC.OpenReport("C:\Program Files\SalesLogix\Reports\p6UJ9A00054L.rpt")

CRXReport.RecordSelectionFormula = "{Account.AccountID} = '" & ACCOUNTID & "'"
CRXReport.ExportOptions.DestinationType = 1
CRXReport.ExportOptions.DiskFileName = strReportFile
CRXReport.ExportOptions.FormatType = 31
CRXReport.Export False

Set CRXReport = Nothing
Set objRDC = Nothing
Set objAC = Nothing

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 9:49:41 AM