Exporting in csv format of data view different

[Former Member]

I have created a report when I view the report data it is the correct view.

Example view: 18584 MS12 1 3.0

18584 CS12 2 4.0

18584 TS13 2 5.5

Each row is created by a Group footer. Like 5b, 5c, 5d, 5e

When I export it to a csv format the data view has changed.

Example View: "18584","MS12","1","3.0","18584","CS12","2","4.0","18584","TS13","2","5.5"

One long string of information for each group footer of 5..

The data is correct but not correct format/view..

I hope this makes some sense...

Thanks for your help..

[Former Member]

Please try following things:

1)what is the result after exporting to text.

2)if the crystal reports application is not on the highest level of service pack then do so by downloading the service pack from here(service pack 4 being the highest for Release 1 and Release 2):

http://resources.businessobjects.com/support/additional_downloads/service_packs/crystal_reports_en.a...

3)check if there are any sectional supress conditions on these group footers.If yes then what is the result after removing these conditions.

Thanks

[Former Member]

I have version 11.0.0.1282.

So what update do I need. It does say Release 1 or 2.

So what release do I have?

[Former Member]

Currently you are on the base version of Crystal Reports XI Release 1.You can download the service pack accordingly for this version and then test for the results.

FYI:

CR XI Release 1 : version number starts from 11.0

CR XI Release 2 : version number starts from 11.5

Thanks

[Former Member]

So do I need to download SP3 and SP4 or do I just download SP4.

[Former Member]

You may go in series, like, first SP3 then check for results.If nothing changed then SP4.

[Former Member]

Well No change on SP3 or SP4..

It would be nice if the version Identification in CR would actually show what your are currently running.. Or CR identifies by build number...

Thanks

[Former Member]

Try this!

Go to Windows Explorer then to....

C:\Program Files\Business Objects\Crystal Reports 11\Patches

IF you have any patches or service packs installed they'll be there.

[Former Member]

The service packs are installed...

I'm at 11.0.0.2495.

[Former Member]

And, did you get time to check for points 1 and 3 above !

Also, we could check if the printer setting makes any difference.In File>>Page Set Up user is able to see the page setup (which is characterized by the printer installed).

The printer button navigates to the printer installed,where user can change the printer.

Since the exported version shows the GF values to be clubbed on on one line so may be we could extend the page size in crystal and then check for the results.

Thanks

[Former Member]

Thanks for your help basicly it comes down to redoing the reports. Originally I had the reports so when it printed it was correct but when exported information it was incorrect.

No Problem Thanks

[Former Member]

In the "Separated Vlaues Export Options" dialogue box try removing the double quotes from the "Delimiter"

The comma (in the Separator value) is there by default as it is CSV (comma separated values).

[Former Member]

This normally what I see when I open it in Excel.

Example View:

"18584","MS12","1","3.0"

"18584","CS12","2","4.0"

"18584","TS13","2","5.5"

But In seeing this:

Example View:

"18584","MS12","1","3.0","18584","CS12","2","4.0","18584","TS13","2","5.5"

It like it shows the rows in CR but when exporting it doesn't..

Does this explain ut better...

Thanks

[Former Member]

Comma Separated Values is meant to export detail rows of data separated by commas.

Your report is displaying ONLY Group Footer sections (GFb, GFc, GFd, GFe) - four separate sections.

The export dll is obviously reading this as ONE group and exporting one group as one record.

This is why your exported CSV file displays four records. The actual report has four groups of four subsections for each group (GFb, GFc, GFd, & GFe).

The design of your report SHOULD have only one row of fields to export; preferably in the detail section or ONLY one row in a group footer.

To test this.....export to excel then do a Save As in Excel and save the report to CSV format. Check out the result. That also results in the wrong formatting.

Simplify your report to one row of data in the report (rather than four) and you should be fine.

[Former Member]

So basiclly I need to create four reports one for each part.

When exporting data you can only export one line per cycle through report.

No problem Thanks..