EXPORT REPORT

[pgtek]

Hi
I have a problem.
I have a report that must be export to something like an excel fromat
but it must be in a single row for each line of my report with the description of each record, group name, page header information.
Is this possible with crystal 8.05
I tried excel 5.0 extend and its looses group name and all the header information title

can you help

thanks
pg

 

[synapsevampire]

Exporting is always tricky to get it perfect, make sure that you apply the latest monthly hotfixes as they often address exporting.

Creation of a single line per row of the report will be based on the layout of the report, you might consider a prompt to the user asking if they are going to export, and have different sections (2 sections for every section of the report, one for Excel exporting, one for online viewing, with suppression being used based on the parameter).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[chelseatech]

The best way to export to excel is to put all the fields you want into the Details section, and suppress all the other sections.

Also turn OFF "Free Form Placement" as that can spread things over several rows.

Also select a wide printer page size. A3 landscape gives the international people plenty of room. I don't know what the euqivalent is in the US. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[scottostanek]

Another option is to use Microsoft Query (optional part of
Excel itself): In your crystal report which pulls the data
you want, goto Database|View Sql. Select and copy that.
Drop it into Excel's Data|Get External Data|Creat New Query
and run. The result gives you an excel sheet with all the
columns you have selected with their titles as they are in
the select.

This is not a nice way to do it, but it does have an
advantage of working even if the machine you want the data
on does not have Crystal installed.

I have yet to try importing SQL into Crystal this way...

Scotto the Unwise