problem of dataset with multiple tables

[shaof]

hi I am having problems for both seeing data in StiWebViewer and in preview of StiWebDesigner with dataset which contains more than one dataTables. (it works with dataset with only one datatable)

I have a dataset which was genereted like:

Code: Select all

dsAll.DataTable.Add(td1);
dsAll.DataTable.Add(td2);

i use this code to populate the report data for preview when open the page with StiWebViewer:

Code: Select all

report.Load(appString + ReportPath);
          report.RegData(dsAll.DataSetName, dsAll);
            StiSqlDatabase database = new StiSqlDatabase(data.DataSetName, ConfigurationManager.ConnectionStrings["CS1"].ToString());
            report.Dictionary.Databases.Clear();
            report.Dictionary.Databases.Add(database);
            report.Dictionary.Synchronize();

on the StiWebDesigner_GetPreViewDataSet event I have:

Code: Select all

e.PreviewDataSet = dsAll;

please help
thanks in advance

[Vladimir]

Hello,

Please try to clear the list of existing database connections in the GetPreviewDataSet event:

Code: Select all

e.Report.Dictionary.Databases.Clear();
e.PreviewDataSet = dsAll;

Thank you.

[hadisaadat_du]

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 ??!