Exporting reports locally - saved data

[waldopepper]

If you have a drill through report with LOTs of data, is there any way to export the report locally so that all the data is available to use with the off-line viewer?

I have 1 report 1000's of records that can be drilled down right to the individual level to show name/address - obviously it runs a bit slow on through Enterprise and it would be good if it could just me emailed to the client so they could browse it quickly off-line.

Is this possible?

thanks
w

 

[ShortyA]

You could set Enterprise to email the report to you or if the client machine is on your network you could FTP it across or save it directly.

ShortyA

 

[waldopepper]

Thanks - but I tried this already and when I open up the report, it asks me for a data source password when I try to drill down. The file is only 95k so it doesn't contain drill-down data.

 

[ShortyA]

Are there any subreports on the drilldown ? If yes, then they should not be set for on-demand. This will make them run when you run the main report rather than running when you drilldown in theory!

 

[waldopepper]

There are no subreports - it's just 5 levels of grouping within 1 main report - which I assumed would be saved with the report if I clicked 'save data with report'. Or am I missing something here?

 

[ShortyA]

Not sure which version of Crystal Reports you are using but in version 8 if you go File/Options and then select the Reporting tab there is an option "Discard Saved Data when loading reports". Check that it is not ticked. Also, what happens when you are prompted for the database logon info and hit Escape or CANCEL ?

 

[waldopepper]

It's Crystal Reports & Enterprise v10.

I have Crystal Reports installed on the machine in question so the ODBC connection box pops up when I export the reports locally and try to drill into the data.
On other PC's with just the off-line viewer installed, when I try to drill down I get the error "Error in creating new data source".

I've tried running it with and without saving the data - same both ways because it can't find the datasource.


I always assumed that it would be possible to save all the data from all levels/paths of drill-down locally and be able to browse it off-line - has anyone managed to do this?

thanks
w

 

[Turkbear]

Hi,
Be sure you are exporting in Crystal Report format and that you have checked Save Data with Report before exporting ( I actually think you have done that, just checking)..

( I suspect that the Drill-Downs in the exported reports are not being populated and are being handled like they were on-demand sub-reports- Try exporting after drilling down to the lowest level)



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[waldopepper]

Yeh that's ticked. When you drill down to the lowest level, it does save that particular 'path' you have drilled down, but when you drill down a different 'path', it prompts for the data connection again.

:/