Creating reports and dashboards | Stimulsoft community forum

Hello!

Within our web application we work with restricted data, that is why we need make available only data within reports for users to which they shall have an access. Some users shall have available only selected tables. Only selected table‘s columns shall be available for some users. Other users shall have access only to some records from table.

How suitably insert in application intermediate layer between MS SQL database and Stimulsoft Reports, which allows managing required accesses? Does it exist any other recommended solution this problem?

Is available any exemplary project demonstrating similar functionality?

Thank you

Hello,

You can implement this task in your Web application. Depending on the user, to receive data in the application and pass to a designer only the data which are necessary to a specific user, using the RegData method.

Thank you.

Hellow Andrew,

But how can a web application to know which data needs to report? The application knows the tables which the user can work. But how to detect which tables (SQL Commands) are actually needed to generate the report?

Or can I implement my own DataProvider and not be dependent on the SQL DataProvider?

Thank you.

Hello,

Using these methods, you can find out which data sources are used in the report. And from the code you can load them only. Thank you.