Exporting Reports

I need some urgent advice. I used Crystal Reports 4.6 (distributed with Visual Studio 6) and designed a report containing saved data. By default the report prints to a window (Crystal Report Preview Window) from where the users can select to print the report to their printers. I need to remove the export and mail options from the Preview Window.
I understand that the later, more recent versions, of Crystal Reports allows for the export and mail buttons to be hidden, what about the version I have? Due to the fact that Crystal Reports 4.6 apparently does not facilitate for this function I considered moving the report to MS Data Report, but it contains export abilities as well. I am more than prepared to use either of the 2 as long as I know that the information contained within the report cannot be tampered with by way of file exports.
Can anybody please help me with this problem?I don't know anything about version 4.6, but maybe there's a way that you can trap the Export button being pushed and warn the user, then exit the function before the report is exported?|||I tried trapping it from within VB, but to no avail.

Exporting report with OLE object to Excel.

Hi all,
I have a crystal report which has an embeded OLE object in it. I want to export this report to Excel. However I'm not able to do the same because of the OLE object since Excel doesn't support that format. I can export normal reports using the export button provided on the toolbar but not this one. Can anyone please suggest me a solution to this problem?

Thanks,
Ekta Singh.where (PH,DETAIL,PF,etc) and what ole object u r placing...|||The OLE object is being used in the detail section and its an Excel sheet which is embeded in the report.

Exporting Problem in crystal reports

Hi all

I am dispalying the data in crystal reports using selection formula from table.I am using Asp.net 1.1 version.Data is coming properly according to the selection criteria. But while exporting to any format like (pdf,excel,word) irrespective of the selection formulae all the data from the table is exporting.
Can any one help me.

Regrds
Syamreply

Exporting crystal reports in excel

Hi all

When i export crystal report file in excel it gives unknown error and the application get closed.
But the same report is getting exported in word and other applications

What is the reason?Can anybody help for this?
Plz also tell if their is any dll used for exporting rpt files.

Regards

AanchalI'm not sure about what exactly is the problem, may be while installing you skiped to select Excel related options. Try to install again in Complete mode and select whichever is related excel.

Good Luck,
Gragi|||Which version of Excel are you using?sql

exporting crystal report to text format

Hi there! Can anyone help me with this: what dll's do i need in order to export a crystal report to text format during runtime.

When i run my program in visual basic 6, the exporting is done successfully. but when im using it in .exe, errors are generated.

i already used U2FTXT.DLL

what could be the problem?

pls help me... thanks a lot!Look at this thread, you might need one more dll:

http://www.dev-archive.com/forum/showthread.php?t=287692&highlight=export+text

JeffB

Exporting Crystal Report To Excel

Hi,
I am having a problem while exporting Crystal Report to Excel Format. It is giving an error saying 'Missing Parameter Current Value' even after passing the parameters. Can any one help.
Thanks
MohithHi,

I try to export crystal report to excel format and its works fine.
but i don't know which version u used for crystal reports and excel

-Yags|||Try looking up the error message in Google or some other search engine.

Crystal Reports Online Tech Support:
http://support.businessobjects.com/search/advsearch.asp

Crystal Reports Forum:
http://support.businessobjects.com/forums/default.asp

Exporting Crystal Report 8 to PDF

Is this possible?, I'm using Crystal Report Control and not the CRViewer? Is it? please help! Thank You Very Much!You can always try printing with a tool such as CutePDF.
This will create a PDF file for you at the location specified

Hope it helps!|||Thanx for the help but I should be doin this throug VB, VB will call Crystal Report then report should or can be exported to PDF|||Dodie,

You could try something like this:

CRrpt.ExportOptions.DestinationType = crEDTDiskFile
CRrpt.ExportOptions.FormatType = crEFTPortableDocFormat
CRrpt.ExportOptions.DiskFileName = mstrDirName "\File_Name.pdf"
CRrpt.Export False

I have a routine which exports about 30 reports a day to pdf and excel formats for an automated vb program and this is the code format we developed in CR8.5 and still use in CR10.

Sky|||Sky,

got a problem, I'm usin Crystal Report 8 and I can't see that property on my Crystal Report Control (.ExportOptions), ur usin 8.5 thats maybe the reason, Thanks anyway for the help!

I wish I get more people to help me, please people!|||I did it! Thank You All Very Much!

download this and just read the instruction

http://s4.yousendit.com/d.aspx?id=2BGY1861VRGH41HPY7L2PXYN99|||I am also trying out the same problem. Can you please help me out in getting the sample files ?

I tried your link but it got expired.

Regards,

Peri

Exporting CR without grouping or formatting

Hi, I'm currently evaluating Crystal Reports XI, testing it's exporting capabilities.

All I want to do is export from a report, just the data (rows of underlying records) with just the field headers (names) in the first row. Just as you would when exporting a query/table from applications such as MS Access into a Tab delimited text file, or comma delimited file.

What I do not want to export is any additional information on the report I.e. Report headers, page headers, group headers and information, totals.

I have tried in CR, csv, ttx, txt, xls (data only), but all of these include grouping information of some sort if the report itself is grouped on the report side.

Has anyone managed to export just the data from a report that has grouping on the report?

Any ideas?

Any help would be greatly appreciated.If you want to export only some part of report then that should be in subreport and export the subreport

exporting a crystal report to pdf format using vb application

hai
how to export a crystal report to pdf format using vb application
please help me
thank u
rachamalluUnless you provide more information, it will be rather difficult to help you. What version of Crystal Reports are you using? What method are you using to display your reports? etc...

Try to do a search on Crystal's Website:

http://support.businessobjects.com/search/advsearch.asp|||i am using crystal report 6.0 and vb 6.0

i am using crystalreport1.printreport to display the report|||I had read somewhere that exporting to pdf through code isn't available in versions previous to 8.5, but I'm not positive. If you can upgrade to 8.5, I can tell you how to do it using RDC (Report Designer Component) as that's what I use for Exporting.

Unless you're referring to exporting based on pressing the export button on the report itself. If thats the case, then you just need to have the correct dlls installed on the machine you're using.|||hai

how to export a crystal report to pdf format using vb application

please help me

thank u

Shahla|||The following code uses RDC to export to PDF

Dim mCrApp As New CRAXDRT.Application
Dim mCrrep As CRAXDRT.Report

mCrrep.ExportOptions.DiskFileName = OutputFileName
mCrrep.ExportOptions.DestinationType = crEDTDiskFile
mCrrep.ExportOptions.FormatType = OutputFileType

'In case u want to export the complete report, use the following code

mCrrep.ExportOptions.PDFExportAllPages = True

In case u want to export a page range from the report, use the following code

mCrrep.ExportOptions.PDFExportAllPages = False
mCrrep.ExportOptions.PDFFirstPageNumber = StartPage
mCrrep.ExportOptions.PDFLastPageNumber = EndPage

mCrrep.Export False

Export to Excel

We are converting Crystal V10 reports to SSRS and have ran into an
issue when exporting a large dataset 104,000 rows. In Crystal when the
users export this same data it spreads it over multiple worksheets does
any have a solution in SSRS that gives me this same ability.Yes it is possible in SSRS, when you have pagination and export to excel,
then it will in multiple sheets
Amarnath
"smiksuek" wrote:
> We are converting Crystal V10 reports to SSRS and have ran into an
> issue when exporting a large dataset 104,000 rows. In Crystal when the
> users export this same data it spreads it over multiple worksheets does
> any have a solution in SSRS that gives me this same ability.
>

Export reports to Excel (data only)

Hi,
Crystal Enterprise have an export option called "Export 97-2000 (data
only)" which exports a report to Excel format but just the data and
not the formatting. I'd like to get similar functionality with
reporting services.
I've tried using the "CSV" format which kinds of does a similar job
but it spreads everything out wide and both the header and table
groups gets mangled together.
What's the best way of accomplishing this in Reporting Services?
Are there any plans to have a different Excel export option that only
exports the data like Crystal?
TIA,
Magnus LassiWe don't have any plans for an Excel-specific data-only renderer at this
point (but that may change if enough people ask for it).
The CSV renderer should be able to give you what you're looking for after
you set the DataElementOutput property to suppress columns you don't want to
see.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Magnus" <mlassi@.yahoo.com> wrote in message
news:f85791fa.0407090735.11ce8969@.posting.google.com...
> Hi,
> Crystal Enterprise have an export option called "Export 97-2000 (data
> only)" which exports a report to Excel format but just the data and
> not the formatting. I'd like to get similar functionality with
> reporting services.
> I've tried using the "CSV" format which kinds of does a similar job
> but it spreads everything out wide and both the header and table
> groups gets mangled together.
> What's the best way of accomplishing this in Reporting Services?
> Are there any plans to have a different Excel export option that only
> exports the data like Crystal?
> TIA,
> Magnus Lassi

Export Report to File

Iâ'm a Crystal developer who has been unsuspectingly thrust into SQL Server
Reporting Services.
I am at a loss as to how I can access report services object to export it to
a file (.PDF, .XLS, etc.) from a Windows application. (With Crystal,
ActriveReports, etc. this would be 4 or 5 lines of code.)
Anybody kow is this done for Reporting Services?
Thanks in advance for your assistance.I just finished doing something very similar. I needed to run the report
and export directly to PDF from my class lib.
Basically you must call the Reporting Services web service and use the
render method. Here is an example in C# to do something similar:
http://www.csharphelp.com/archives3/archive545.html
But your best bet is to get a copy of SQL Server Reporting Services (WROX
publishing). They have a great section that discusses this.
Be sure you deploy your Shared DataSource (if necessary) and Reports (or add
manually using the Report Manager web page) before attempting to access your
reports with the web service.
Richard
"Tom N" <TomN@.discussions.microsoft.com> wrote in message
news:4751CB4C-9620-4B75-A4E1-CFFA7B296FE9@.microsoft.com...
> I'm a Crystal developer who has been unsuspectingly thrust into SQL Server
> Reporting Services.
> I am at a loss as to how I can access report services object to export it
> to
> a file (.PDF, .XLS, etc.) from a Windows application. (With Crystal,
> ActriveReports, etc. this would be 4 or 5 lines of code.)
> Anybody kow is this done for Reporting Services?
> Thanks in advance for your assistance.