Report Designer possibilities

[IskandarAir]

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 ?

[HighAley]

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.

[IskandarAir]

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

[HighAley]

Hello.

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

Thank you.