 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Languages / VB.NET / April 2007Data duplication of each record in Crystal report
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 maybe your detail section has 2 lines of controls in it? On Apr 5, 4:23 am, haresh.a...@gmail.com wrote: > hi to all, this is Haresh Bhatt, > [quoted text clipped - 10 lines] > > 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 On Apr 6, 10:58 pm, Subhro.gu...@gmail.com wrote: > 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. > [quoted text clipped - 3 lines] > --- > Posted via DotNetSlackers.com Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.