Hi Steve,

As you said, one way of doing that would be by programmatically altering the connection string for each user who logs in (user instance), in some kind of Session_Start() method that you may have in your app, here is a useful thread on how to do this. 

However, I wanted to let you know that in NA Reporting 2011.2 you can change report's data sources at runtime using Data Source Providers. This allows you to customize (through code) how data is loaded. In your case, you can switch connection strings or queries according to the current user's permissions or even modify/filter data before being rendered in the report.

Here you have a running sample which uses a Data Source Provider to retrieve data from an ADO.NET Entity Framework Model. And here is a topic on how to use Data Source Providers.

Hopefully one of these alternatives will work for you.

Regards,

Miguel

The only thing we came to was to give you a way to easily write those IReportDataSourceProvider implementations. We created a T4 template that you can point to a Report with SQL DataSources created, and it will generate an IReportDataSourceProvider implementation with the same SQL query that it's in the report. You can get the template here.

To use it, you will need to:

•  Add the DataSourceProvider.tt to the project where your report is. You'll need to add it as many times as reports you have.
• Rename the .tt file with the name of the DataSourceProviderInstance you want to create, but leaving the .tt extension
• Open the .tt file, and where it says

              // Set here the name of the report!
              string inputFile = @"$NameOfTheReport.igr$";

  Replace it with the name of the actual report:

          string inputFile = @"Report1.igr"

•  After you do that, you'll see a .cs file created as a child of the .tt file in the Solution Explorer. That .cs file will have the code for the DataSourceProvider.
• The DataSourceProvider.cs code has the generated code for a data source provider that executes the SQL sentences in the report and returns them as part of the data source provider. It probably won’t compile until you:
  
  • Add a reference to InfragisticsWPF4.Reports.v11.2.dll and System.ComponentModel.Composition.dll, or add an empty DataSourceProvider with ‘add new item’, which adds those references for you.
  • Add a reference to System.Configuration

After that, you'll have the a ReportDataSource implementation that will basically do the same thing as the reporting engine is doing. In one part of the T4 template, it says

using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["<#= project.Properties.Item("DefaultNamespace").Value + ".Properties.Settings." + dataSource.ConnectionStringKey #>"].ConnectionString))

That is where the connection string is set. You'll need to change that code in the .tt file to retrieve the connection string from whenever you want.

Keep in mind that the template code generation won't be triggered automatically after you change the report, so for any change in the datasources for the report you'll need to trigger the execution of the template runner. This can be done by modifying the .tt file or by right clicking in the file and selecting 'Run Custom Tool'.

We'll add support for this scenario natively as soon as we can. I apologize for the complex workaround.

Regards,

There's a new version here. It will create a single source file with DataSourceProviders for every report in the project.

Here there is a question/answer on how to run T4 as part of the build.

Let me know if this helps.

Regards,

Andres