Dynamic Report with Dynamic Query

[mahdi]

Hi,
I need a dynamic report and wonder if I can do that with StimulReports.Net.
By dynamic report, I mean both dynamic query and dynamic design. So the End-User should be able to do the following steps:

1: Dynamic Query
-Show list of some tables and user selects the desired tables. System should find relations of the tables and if there's no relation, user selects the relations himself.
-From each table, user selects the desired fields.
-User selects filters conditions on the fields, order of fields, sorted fields, grouped fields, etc...
-...

2: Dynamic Design
-User adjusts the generated columns, their sizes, colors, etc...
-User selects paper type
-...

Can I do these steps with StimulReports.Net? How?
And if it's not possible, what other tools do you suggest?

[Edward]

I need a dynamic report and wonder if I can do that with StimulReports.Net.
By dynamic report, I mean both dynamic query and dynamic design. So the End-User should be able to do the following steps:

1: Dynamic Query
-Show list of some tables and user selects the desired tables. System should find relations of the tables and if there's no relation, user selects the relations himself.

Yes, all of this is possible. Please see the following flashing tutorial:

http://www.stimulsoft.com/livedemos/dat ... igner.html

-From each table, user selects the desired fields.
-User selects filters conditions on the fields, order of fields, sorted fields, grouped fields, etc...
-...

The following links are clearly show how these task may be done in the Stimulsoft Reports.Net:

http://www.stimulsoft.com/livedemos/Rep ... eport.html
http://www.stimulsoft.com/livedemos/Rep ... ilter.html
http://www.stimulsoft.com/livedemos/Rep ... _Data.html
http://www.stimulsoft.com/livedemos/Rep ... roups.html

2: Dynamic Design
-User adjusts the generated columns, their sizes, colors, etc...
-User selects paper type
-...

Stimulsoft Reports.Net is a page-based report generator. This means that the developer and the user of the Application which includes Stimulsoft Reports.Net dlls can design each page as they wish.

The layout of the page can be changed in the rendered report from the window of preview or on the stage of creating of the report for each page independently from other pages.

Please download our trial version and run the Demo.exe example application. There are lot of example reports on different features of the report engine.
Press the Design button to run the Designer for each report. Also changing of the report's layout of each report is possible.

Also please see the sample solution PrintTable which shows content of the DataTable 'on the fly'. Report layout is created automatically in runtime, then the report can be rendered or re-designed by the end user before rendering. For this just insert report.Design() command after code of adding components to the report's page.
This command will show the Designer for that report layout.

Double click in the Designer in any place of the Page component (or go to File - Page Setup) and you will see the page layout setup dialog, where the layout r size of the page can be easily changed.

Please let us know if any help is required.

Thank you.

[mahdi]

Thanks for the reply.
I took a look at the samples, but just before testing the demo version I have some other questions.

1- Is it all possible in Web-Based applications too? I mean, both dynamic query and dynamic design by end user; so that the end-user would be able to make his own reports in web app.

2- As I see in the flash tutorials, End-User seems to have unlimited access in design form. I want to limit End-User in some cases. For example I want to limit end users available data sources, so that End-User just be able to use some tables that I mention, not the whole data. Is it possible too?

[Edward]

Thanks for the reply.
I took a look at the samples, but just before testing the demo version I have some other questions.

1- Is it all possible in Web-Based applications too? I mean, both dynamic query and dynamic design by end user; so that the end-user would be able to make his own reports in web app.

For designing reports in the web-browser we are working now on the new product DevReports Studio, which will allow you to design reports right in the web-browser. Here is the link which allows you to try this new functionality wright now:

http://devreports.stimulsoft.com/

2- As I see in the flash tutorials, End-User seems to have unlimited access in design form. I want to limit End-User in some cases. For example I want to limit end users available data sources, so that End-User just be able to use some tables that I mention, not the whole data. Is it possible too?

To add restrictions to the Dictionary about existing there datasources you can as shown in the following topic:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=545

But if user has been given with ability adding/editing DataSources then it can write any possible SQL query and access to any data which is available in accordance with his privileges in the database. Here access is limited only with access rights for certain user/role on Server. We can't limit it on the side of the Stimulsoft Reports.Net.

Thank you.