1. Home
  2. Forum
  3. Report Platform
  4. Dynamic datasource per report
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Dynamic datasource per report

Hi there, we are looking at implementing Report Platform running on an Azure Service. We have an MVC App whish is used by multiple customers. Each customer has their own dedicated database containing the data they want to report on.

We have around 30 standard reports which we would like to allow the end users to run from our app. How would you recommend we set this up? Clearly we want to avoid having to create copies of all 30 reports for each customer and updating the data source for each database. Is there a way we can make the report select the correct data source for the logged on user, either dynamically using server permissions or by passing the datasource as a runtime parameter from the app? Or do you have a better solution? One idea I had was to create a separate Report Server instance in the Azure App Service Plan for each customer, but that doesn't seem like the best approach.

We would also like the end users (some of them) to create their own reports. These would be separate to the standard reports and should only be available to that customer.

3 Replies
RR Rajesh Rajendiran Syncfusion Team January 3, 2018 12:51 PM UTC

Hi MarkMorrall, 
 
Sorry for the inconvenience. 
 
At present we do not have option to render the report with data source based on logged on user. 
 
We had created a new support incident under your Direct-trac account. Please follow-up with the incident created for further assistance.  
 
Thanks, 
Rajesh. R 


DC David Crumb December 12, 2018 08:01 PM UTC

Hi there;

Is there an update on this thread?  Is it possible to set the datasource for a Syncfusion Report Server report at runtime?

Many thanks,

--Dave


MM Mageshyadav M Syncfusion Team December 13, 2018 11:48 AM UTC

Hi David Crumb,  
 
Yes, you can change data source dynamically during rendering time based on logged in user. To achieve your requirement, you need to assign the data source for the groups and need to add the users to that group who need to view the report with that data source. We have prepared the below document to achieve your requirement in details. 
  
 
Regards, 
Mageshyadav.M 


Loader.
Up arrow icon