Last post May 23, 2011 03:52 PM by microsoftee
Apr 20, 2011 09:32 AM|aspbuddy|LINK
In my .net web application, I am passing 'workstation id' in my connection string, which I am using later on in SQL Server to handle some business logic.
Same way, I want to pass workstation id from crystal report to sql server.
So, is there any way in .Net to change the workstation id in crystal report, when it makes connection to SQL Server?
I am using Pull method to bind data to Crystal report.
May 23, 2011 03:52 PM|microsoftee|LINK
Why are you passing value for your business logic in ConnectionString? You can pass it on in any SQL function OR SP.
Drop a ReportSource control to form and 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