Last post May 07, 2018 05:24 AM by TRIMS30
May 07, 2018 05:24 AM|TRIMS30|LINK
Am using ASP.Net.
When I login to my program I dynamically assign a connection string to all of my SQL Database Accesses based upon the user who logs in.
Connection string is part of the users profile.
User Login "A" has a connection string pointing to a dataset on Server "A" and User Login "B" has a connection string pointing to a identical dataset schema on Server "B"
How do I apply a dynamic connection string to the reports I've written using Crystal Reports so User "A" reports his data and Use "B" reports a different set of data?
When I created my ASP.Net (VB) project I use the Add Sql Server Tool. I then created my Crystal Reports using the Wizard.
So, in vb code how do I dynamically assign my reports to a connection string?