Creating reports and dashboards | Stimulsoft community forum

I need to know the following:

1. Can we control the connection string of the report designer and runtime before it connects to the database
we have a multitennant and need to control both the connection string and the context passed to sql server
this would be both for the designer and the report/chart display

2. can we extend the web.designer and add our own objects. as we already have an application we would need to be able to drag components on to the designer, these may be .net web controls but at a minimum the could be an iframe. but the key is that we can add objects to the toolbar in the web.designer

3. can we generate our own reports in an xml format that the runtime will then display, ie if our app has a wizard can we ask users questions and then create the xml based on their answers and use that to display the report

4. is it possible to have the reports that are displayed in an actual web application, so far the only examples we see look like a print preview a4 page. we want the dashboard to be in our application as part of it

Hi

wayne wrote:1. Can we control the connection string of the report designer and runtime before it connects to the database
we have a multitennant and need to control both the connection string and the context passed to sql server
this would be both for the designer and the report/chart display

No problem, you can control the Connection string in the designer's Dictionary as follows:

report.Compile();
report.CompiledReport.Dicionary.Databases["MyDatabaseName"].ConnectionString = "...";

and after that to call webviewer or web designer.

But Web Designer does not allow you to change this using the code only.

wayne wrote:2. can we extend the web.designer and add our own objects. as we already have an application we would need to be able to drag components on to the designer, these may be .net web controls but at a minimum the could be an iframe. but the key is that we can add objects to the toolbar in the web.designer

For now the answer is no.

wayne wrote:3. can we generate our own reports in an xml format that the runtime will then display, ie if our app has a wizard can we ask users questions and then create the xml based on their answers and use that to display the report

Yes, it is possible, please see the "PrintTable" and "PrintTable" applications from the standard installation of Stimulsoft Reports.Net.

wayne wrote:4. is it possible to have the reports that are displayed in an actual web application, so far the only examples we see look like a print preview a4 page. we want the dashboard to be in our application as part of it

There is no way to add buttons into web viewer. But you can add a combobox into the page. So you could choose the report to render.

There are three ways for printing of the reports in Stimulsoft Reports.Net:

1) webViewer.PrintToPdf() - the report will be exported in Pdf format. Using this format your reports will be printed exactly in the way they have been rendered in winforms viewer.

2) webViewer.PrintToPopupWindow() and webViewer.PrintToDirect() - these methods use the Web browser print capabilities.

Printing will be done in the HTML text format. HTML representation of the report can not guarantee 100 per WYSIWYG on the paper. Paper size will be controlled with help of the browser.

Thank you.

Hi Edward,

thank you very much for the quick responses.

the key here is point 2

2.

ok I really don't understand how it is impossible to add a component to that toolbar, even if its a very simple type of function.

if we have the source we HAVE to be able to add an object to the toolbar or even hijack one of the existing objects in order that we can show a webcontrol or a class of our own in that area.

now we have serious developers expert in .net and will definitely purchase this if it is possible.

so if you can think of a way this i would really appreciate it.


finally on point 4
i wasnt trying to control the printing capability.

What i'm trying to do is have the application setup in such a way that this tool can be embedded in the middle of our applicaiton either in an iframe or by embedding the control, so that it looks and feels like part of the overall application.

so can i hide the print button?
can i change the view so its not limited to A4?
Basically is it possible to get one of these dashboards into our application and have it look like a web app instead of a print preview

(printing isnt a priority for us)


thank you very much for your time, this is a very impressive tool and i do hope we can use it

Hello,

2.

ok I really don't understand how it is impossible to add a component to that toolbar, even if its a very simple type of function.

if we have the source we HAVE to be able to add an object to the toolbar or even hijack one of the existing objects in order that we can show a webcontrol or a class of our own in that area.
now we have serious developers expert in .net and will definitely purchase this if it is possible.

Main problem is client part - report designer. It created not on .net language. We have used Adobe Flex. If you ready change it we can help you with your request.

finally on point 4
i wasnt trying to control the printing capability.

What i'm trying to do is have the application setup in such a way that this tool can be embedded in the middle of our applicaiton either in an iframe or by embedding the control, so that it looks and feels like part of the overall application.

so can i hide the print button?

Yes you can. Please use ShowPrintButton property of StiWebViewer.

can i change the view so its not limited to A4?

Size of page setted in report designer with help of PageSize property. Limitation depend on browser printer settings.

Thank you.