Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Nov 18, 2009 5:01 am**

hi,

I need help with Stimulsoft Reports Designer.Web. I want to bind a Dataset to report.

this is the code :


dim sensql as string="select  * from estudio where rownum  < 11"
dim ds as new dataset
dim da as new sqldataAdapter(sensql,connection)
da.fill(ds, "table")

            report.Load("D:\InformeLimpio.mrt")
            report.RegData("table" ds)
            Me.StiWebDesigner1.Design(report)

but when I execute the report the information is not shown.

Posted: **Wed Nov 18, 2009 9:33 am**

Hi

In case if you are using official release version 2009.2, then you need an additional event handler to have a data for launching the report from the Web Designer:

It is a GetPreviewDataSet method of the StiWebDesigner class:

Code: Select all

dim sensql as string="select  * from estudio where rownum  < 11"
dim ds as new dataset
dim da as new sqldataAdapter(sensql,connection)
da.fill(ds, "table")
e.PreviewDataSet = data;

Thank you.

Posted: **Tue Nov 09, 2010 2:57 pm**

Hi every body.
I sea allmost all topic in forum and seem int all of them posit that we know what is our tables and columns in dataset of our reportbut allways not thus
1-sometime we may want to edit the report in webdesigner that we dont know any thing about its data set but we sure it works with our data base , so befor call the design() function we pass what data set to our report via regdata(//what_dataset) ??
2- or we may want to set full access to data base to one user to create the every report that need to design well we pass a full data base to designer dictionary and he/she design every report by every columns in every tables or viwes in database and save it , in viwe report mode namely after load our report and we want to pass it to stiwebviewer we pass what data set to it since we cant pass all data base to our report ??!