Data duplication of each record in Crystal report

  • Thread starter Thread starter haresh.amis
  • Start date Start date
H

haresh.amis

hi to all, this is Haresh Bhatt,

I make a view in MS SQL 2000 and execute it gives me expected result.
but when I run the crystal report it gives me result in duplicate
records.

View work fine in SQL Server but in Crystal report each record display
two times

I am trying to find out it's solution.

have you any idea?

pls tell me
 
In all probability u have more that one sql statement in ur command used. If such is the case pls. see that the one which is to return only one row is returning 2 and by virtue of that ur recordsize is inceasing by 2. Remember that u will always have to be careful that ur main result has multiple no. of records and others return only single row.

Thanks,

Subhro
 
uh the sproc works fine in SQL Server so it's probably NOT having 2
sql statements

do you have 2 lines of detail information?
a lot of people do things like this on purpose in crystal

they make one visible and not not visible.. dynamically
 
Back
Top