1. Home
  2. Forum
  3. Report Platform
  4. Dynamic Shared Datasource
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 Shared Datasource

Hello all,

I am trying to make the report designer controle in my application, grant access to my customers (in my case Teachers), and give them the ability to design their own reports, using a single shared datasource.

My probleme is making this shared datasource shows filtred data depending on the logged user.

In other words, can i filter a shared datasource, programaticly when using the designer.

1 Reply
VS Vinoth Srinivasan Syncfusion Team January 8, 2018 01:55 PM UTC

Hi Namec, 

We don’t have programmatic option to change the database access based on the user in report designer. To filter the data’s related to the currently logged in user, use query parameter in report dataset and create a parameter called UserID and make it hidden then set  =User!UserID in an parameter expression, which retrieves the currently logged on user. Add the query parameter condition Table.UserID = @UserID in your shared dataset which will gets the data only based on current user. If your requirement is to get different tables based on the logged in user then share more details on the requirement, it will be helpful for us to analyze the requirement. 

Regards, 
Vinoth S.

Loader.
Up arrow icon