Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, November 25, 2024 
 
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 ThreadView:  Search:  
 Author  Thread: Export Report
Rodrigo Ginyaume
Posts: 20
 
Export ReportYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Nov 06 3:13 PM
fiogf49gjkf0d
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 ReportYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Nov 06 7:52 AM
fiogf49gjkf0d
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 ReportYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Nov 06 9:40 AM
fiogf49gjkf0d
Thanks for your reply! Unfortunatelly, our client didn´t buy knowledgeSync product.
[Reply][Quote]
Bob (RJ)Ledger
Posts: 1103
Top 10 forum poster: 1103 posts
 
Re: Export ReportYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Nov 06 6:56 AM
fiogf49gjkf0d
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 ReportYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 Dec 06 1:33 PM
fiogf49gjkf0d
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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/25/2024 9:28:32 AM