on 10-30-2015 3:24 PM
Hi there,
We have a crystal report which contains only main report and it has Group1 and Group 2. The report currently has a page break each Group 1 but our end users requested to generate separated Excel file per Group1 instead of printing all the records in one single Excel file.
We are using Crystal Report 2011 and checked Export Report Option and Group Expert. However, we do not see the option for this change.. Could anyone provide us some advice? Thank you in advance!
Chrissa
Hi Chrissa
There is no way to do this. There may be a 3rd party application that will do this (hint: google ken hamady), or you can possibly write an app using one of the CR SDKs to do it. But CR does not have anything like is "out of the box".
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow me on Twitter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dell,
We found this thread and wonder if we could do similar using VB.Net. However, even if we can write similar scripts we are not sure where we could write..
How to Export Each page of report to seperate pdf files in Crystal Reports XI-VBForums
Dim rdoc As New ReportDocument
'------------------------------------
'Add your code to set rdoc object
'--------------------------------------
Dim exportOpts As ExportOptions = New ExportOptions()
Dim pdfRtfWordOpts As PdfRtfWordFormatOptions = ExportOptions.CreatePdfRtfWordFormatOptions()
Dim destinationOpts As DiskFileDestinationOptions = ExportOptions.CreateDiskFileDestinationOptions()
For li_count As Integer = 1 To pagecount
pdfRtfWordOpts.FirstPageNumber = li_count
pdfRtfWordOpts.LastPageNumber = li_count
pdfRtfWordOpts.UsePageRange = True
exportOpts.ExportFormatOptions = pdfRtfWordOpts
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat
destinationOpts.DiskFileName = "D:\report File" & li_count & ".pdf"
exportOpts.ExportDestinationOptions = destinationOpts
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile
rdoc.Export(exportOpts)
You can get the .NET SDK here: . You'll install the most recent version (currently SP15) of the "Install Executable" on the developer workstation to get integration into Visual Studio. The other installs on the same line are the various forms of runtime installs required for deploying your application.
You can find sample code and further assistance with the SDK here: The sample code links are on the left of the page if you scroll down.
-Dell
Ken Hamady's site is at www.kenhamady.com/bookmarks.html.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.