Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Can I pass my SQL statement to the report? Post Reply Post New Topic
Author Message
pgeorge33
Newbie
Newbie


Joined: 04 Dec 2012
Online Status: Offline
Posts: 8
Quote pgeorge33 Replybullet Topic: Can I pass my SQL statement to the report?
    Posted: 05 Dec 2012 at 3:30am
I have been experiencing problems with records getting displayed multiple times in several reports I am tryng to generate. 
 
In my program I generate the SQL statement (using Access), get the data from the database and pass the dataset to the report using

objRpt.SetDataSource(ds.Tables[0]);

However when I show the report, my report has thousands of more lines of data than the the data set I passed in.  Almost like the data was getting accessed from the database without the WHERE statement.
 
I suspect it is a problem with the Database Links I have setup but I can't seem to get it to work correctly.
 
Can I simply pass the SELECT command to the report and avoid these issues?
 
Peter
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.