we are in teh process of migrating the reporting of our application to SQL reporting services.
We still need to solve teh following issue.
When we design a report, we do it it on a sample data Base.
Then this report is deployed with the application, and when the report is loaded into teh report viewer, teh application should be able to change the data source by .
the changes should apply only for this session, and not to all report, as another user or teh same user might run this report but based on another data dource.