Crystal reports, items in double

[touf]

Hi,
I've a problem in a crystal reports report, the detail information is
displayed 2 times. I'm sure that the dataset contains the true information
because I see it in a datagrid so the problem in Crystal reports definition.
Does someone have the same problem before, or know what can be the cause.
thanks.

In my dataset there are 4 datatables with no relation between them, and all
the detail information is from one datatable.

 

[Bernie Yaeger]

Hi Touf,

Multiple tables are the cause of the problem.

It's a bit weird, though, and I seldom can figure it out decisively. I
usually end up removing one of the tables and the doubling disappears, and I
have yet to fully understand why this sometimes happens.

Try removing one or another table and test; once you've isolated the
offending table, determine what data it contained that you must have in the
report - then change your code to include the appropriate columns in one of
the other data tables, if that's possible, or else rebuild the routine using
an sp.

HTH,

Bernie Yaeger

 

[touf]

Hi,
thanks for your help, I've found the problem, it was because I've a total
field of an other datatable... I don't know why it does this problem... but
when I've removed it the problem was fixed.

don't understand a lot of things but my problem is resolved.