Duplicate Data

[Former Member]

I'm having an issue with vb.net 2005 and Crystal Reports XI.

I created a report with Crystal XI using an OLEDB connection to my database, joined two tables and got 33 records displayed on the report which was correct. I then cut that exact sql out of Crystal Reports and using vb.net passed it to a dataset. During debugging I verified the dataset had 33 rows. I even dumped the dataset to an XML file and verified it had 33 rows. However when I passed the dataset to the crystal report and opened in the viewer I have 18 Pages with about 1000 rows.

Any thoughts as to why it works fine in Crystal and not from vb.net?

Thank You

[Former Member · Accepted solution]

OK, I did not do exactly what the link stated but in my code I create an XML file based on the 33 record dataset already so I could physically verify it had 33 records. But this time I set the datasource to the XML file in the code rather than the dataset and I only got 1 page with 33 records and not 1000 records and 18 or so pages.

So I guess the question is why crystal reads the XML created from the dataset and not the dataset itself.

I can't really live with making XML files for each report due to the sensitive nature of the data.

[former_member183750 · Accepted solution]

From here, you'll need to get someone in TS to have a look. I can do it, but I will need the report and the xml. As the forums do not allow attachments, I can create an ftp container for you to upload the files to. Only other alternative is to create a phone case here;

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...

and talk to someone over the phone, doe a webex, etc. Let me know which option is best for you.

Ludek

[Former Member]

I think I'm all set.

It seems that the crystal report/viewer gets confused if the report was initially designed and setup with multiple tables and linkages between tables. Then if you pass it a single table in a dataset it tries to link that to the original Tables and you get duplicate data.

We rebulit our inital reports based on a command, then passed the single table from the dataset to it and all is well.

Thanks for your help

[former_member183750]

Glad to hear it's working. Interesting behavior as I would have expected an error or the fields being stripped out. But in any case, a report built on multiple tables should be passed multi-table dataset.

Ludek

[Former Member]

Crystal Version is 11.5.11.1470

[former_member183750]

What happens if you point the report in the designer at the xml as described in [this|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken]; blog?

Ludek

[former_member183750]

Let me know the exact version of CR you are using (Help | About).

Ludek