Showing posts with label exporting. Show all posts
Showing posts with label exporting. Show all posts

Thursday, March 8, 2012

2147190908 Failed to export the report

Hi All,
Facing an issue while exporting a report(invoice) to PDF in Crystal 8.5 after exporting 1000's of files(invoices) to PDF.

Error msg "2147190908 Failed to export the report". after generating this error, OKB PDF file is generated and we are nt getting any invoices from then.

We have a Licensed Copy of Crystal Reports 8.5 Developer Version
We are facing a Problem while exporting our Invoices in PDF Format

After Printing Some Invoices It Starts giving the following error
Error message" -2147190908 Failed to export the report".

The Number at which the process starts giving this error is not Consistent .
Some time the problem starts after printing 60, 000 Invoice and some times
it starts coming after 40 to 50 thousand.
But once the problem comes , then it keeps coming whatever we do.

We did the following to rectify the problem but of no use
1. Restarted the machine
2. Un installed the Application and re-installed it .
3. Replace the Crystal DLLs , some of them I am listing here (Crxddrt.dll ,
crxdrt.dll, crxDesignerctrl.DLL, CRXDUI.DLL)
4. Applied the HOT fix patch CR85devwin_en.zip on our existing Development
env

It is a very Critical Problem as Implementation is starting from 31st
January , and Client is just waiting for this patch

Any help will be highly appreciated , In case somebody assure me to
solve this problem we can also go for the annual Support Contract.

Please help !!!!

Regards,
RajWe are experiencing the exact same issue. Reports have been exporting fine for over a year and then suddenly we are getting the same export error.

We have also tried reinstalling Crystal and before we re-image the machine, has anyone found a solution to this issue or at least what we can look into.

You said that there is not a set number of reports where you start to see this error. How were you able to get it to start temporarily working again??

Thanks for any help!|||Incase anyone comes looking, our solution was to empty out the temp folder where Crystal was creating the files before converting to PDF. We had over 75000 temp files sitting in the folder. Why Crystal doesn't clean up after itself I don't know, but we ended up creating a service that empties this folder everyday.

Hope this solves your issue as well.

walther|||Bumping this thread for resolution.

Our system just recently experienced the same issue.

Win2k3 Server
Citrix Metaframe XP
Crystal Reports 8.5
Adobe Acrobat 5

I've already uninstall acrobat, crystals, java, and a plethora of other software in hopes of fixing this bug. I've regsvr32 practically all the dlls and deleted the temp files/folders as well.

I've done practically everything short of reinstalling the entire server.

Any suggestions would be greatly appreciated.|||Hello,

I know this is an ancient subject, but I am running into the same issue. I see that Walther, you mentioned that you solved the problem by deleting the files out of the temp folder. Can you tell me where Crystal Reports keeps it's temp files. I want to view that folder on our box to see what it looks like.

Thanks, Neil

Tuesday, March 6, 2012

2005: Publishing (not exporting) Report in Excel format

My end users want me to post 2 versions of my 2005 Reporting Services
reports. One that when they click on it automatically opens in Excel w/o
grouping...sort of a data dump. Then a second that is grouped, formatted and
pretty.
I know that I can have them export the report once run into Excel, but they
don't want that. (of course...;) So, does anyone know how to publish in
straight Excel in Reporting Services?
thanks in advance for any help!
MachelleYou didn't say if you are using Report Manager or not. The best way is to
use jump to URL and render in CSV ASCII format. The default for CSV is
unicode which Excel opens up with all the data in its own column.
Depending on your report you may or may not want to have a duplicate report
that you have cleaned up and call that one rather than the pretty one.
Regardless, if you have any data size at all URL is much faster.
If you are using Report Manager you could have a report that has no data,
just the parameters and then textboxes, one for pretty, one for Data Export
(I call it that in my link to differentiate that it is a data export, not
the pretty Excel export).
Note, the fields texboxes of the report have a name property that is set
during design to the name of the field. You can give it friendlier names if
you want.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Very nice and very fast.
Bruce Loehle-Conger
"Machelle" <Machelle@.discussions.microsoft.com> wrote in message
news:A5360BDE-440C-4AAF-8D07-46A9D3472567@.microsoft.com...
> My end users want me to post 2 versions of my 2005 Reporting Services
> reports. One that when they click on it automatically opens in Excel w/o
> grouping...sort of a data dump. Then a second that is grouped, formatted
> and
> pretty.
> I know that I can have them export the report once run into Excel, but
> they
> don't want that. (of course...;) So, does anyone know how to publish in
> straight Excel in Reporting Services?
> thanks in advance for any help!
> Machelle