Data duplication of each record in Crystal report

[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

 

[aaron.kempf]

maybe your detail section has 2 lines of controls in it?

 

[Subhro.gupta]

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

 

[aaron.kempf]

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