Creating reports and dashboards | Stimulsoft community forum

Dear Stimulsoft team,

We would like to integrate the Report web Designer. We have few questions to clarify the functionalities of the device:

1- in creating "New Data Source" - there is option to select several data source (table, view, stored-procedures). But we noticed that several tables are not seen - Emp, Dep, Activity, etc. What can be the reason that some data-sources are not returned in wizard ?
2 - We have more than 1000+ table, view and stored-procedures. Is there a way to filter or limit the list in Designer (programmatically, visually, from sql-server side, etc.)?
3 - Regarding 2nd point, can we give a search of filter box for end user to input text ?

[SEE IMAGE ]


4 - in Standard Report , Is there a way in WIZARD to join several data sources (like inner join .. ON .. ) so User will no need to specify filters, sql lines. Basically, he will have to select by what column to join and what will be the master table , thats all ?

Hello,

1- in creating "New Data Source" - there is option to select several data source (table, view, stored-procedures). But we noticed that several tables are not seen - Emp, Dep, Activity, etc. What can be the reason that some data-sources are not returned in wizard ?

Sorry, we don't have answer on this question. Maybe this is connected with the large amount of tables.

2 - We have more than 1000+ table, view and stored-procedures. Is there a way to filter or limit the list in Designer (programmatically, visually, from sql-server side, etc.)?

It's impossible to set any limits there. But you could disable this dialog and write SQL queries.

3 - Regarding 2nd point, can we give a search of filter box for end user to input text ?

There is no search feature in this dialog. Please, send us a feature request if you need it and we will discuss with our team.

4 - in Standard Report , Is there a way in WIZARD to join several data sources (like inner join .. ON .. ) so User will no need to specify filters, sql lines. Basically, he will have to select by what column to join and what will be the master table , thats all ?

It's possible to create one-to-many relations between data sources.
If you need other ways to join data you could write more complicated SQL queries.

Thank you.

Dear Stimulsoft,

Thank you for you reply.
Can you please provide the documentation of video link where i can see one-to-many relations between data-source ?\


Regards,
I A

Hello.

Please, read this section of the User manual:
https://www.stimulsoft.com/en/documenta ... lation.htm

Thank you.