Last post Mar 13, 2011 03:53 PM by microsoftee
Feb 12, 2011 04:53 AM|vigneshtr11|LINK
I have serveral databases with same tables. I created a crystal report to show the report for respective logins from the database. I have a problem in it. In crystal report when i changing the database it should not change the respective table. It loads
only the table what we give in the connection string first time. Could you please help me on this.
Mar 13, 2011 03:53 PM|microsoftee|LINK
Drop a ReportSource control to form and create a dummy stored procedure to provide appropriate fields for report at design time, link to that SP only for report design after this in application set CrystalReportSource control's report file .rpt and set DataSources
to SQLDataSource control, set SQLDataSource control commandText to your query.
This is how I deal with it, more details about ReportSource control at MSDN