Enable Drilldown in StiWebViewerFx

[kris@bplogix.com]

I have installed your latest build and was able to design a report that uses drilldown. It works great in Preview mode. But when I view it in the StiWebViewerFx it does not work. What do I need to do to enable the Drilldown option in StiWebViewerFx?

[Vladimir]

Hello,

Please try to define the GetDataSet event of the StiWebViewerFx component, and register report data in this event:

Code: Select all

protected void StiWebViewerFx1_GetDataSet(object sender, StiWebViewerFx.StiGetDataSetEventArgs e)
{
    e.DataSet = new DataSet();
    e.DataSet.ReadXml(appDirectory + "\\Data\\Demo.xml");
}

or:

Code: Select all

protected void StiWebViewerFx1_GetDataSet(object sender, StiWebViewerFx.StiGetDataSetEventArgs e)
{
    e.Report.RegData(data);
}

Thank you.

[jay@bplogix.com]

That worked thanks!

How do I pass filter data from a drill-down to a "Data from other Data Source" datasource? I would like to pass the filter data to a new page, and run that page based on the field that was clicked. I see how I can add the filter data the DataBand ... but how do I use it in the actual datasource?

Thanks!

[Vladimir]

Hello,

You can add a filter to the "Data from other Data Source" as well as a filter for Data Band. Please see the video tutorial:

http://www.stimulsoft.com/livedemos/ste ... _Page.html

Thank you/

[jay@bplogix.com]

That video shows how to add the drill down data to the DataBand filter .... but how do you use the drill down data in the dictionary on a "Data from other Data Source"?

Adding the filter to the DataBand means the reporting engine is processing the entire datasource ... for performance, the drill down operation needs to pass the filter data to the datasource so that the report engine is only dealing with a small result set.

Thanks

[jay@bplogix.com]

To clarify what I am looking for ... I have an input datasource that looks like this:

Sales_Rep Region Amount
---------- -------- ---------
John West 100
John East 200
Sue North 150
Sue East 150
Sue East 150
John West 125
Sue North 100
Bill North 500

I use a Data from Datasource to show a total for each sales rep that looks like this (this works fine):
Sales_Rep Total_Sales
--------- ------------
John 425
Sue 550
Bill 500

If the user clicks on a sales rep, I want it to drill down and show the total sales for that sales rep by region. So If I click on John, I want it to show
Sales_Rep Total_Region
--------- ------------
West 225
East 200

How do I configure the filter for the drill-down page? I tried to create a Data from datasource grouped by region, with a filter on Sales_Rep of the drill-down data. But that returns no results. It seems that the datasources are all read prior to the drill down occuring.

Thanks

[Alex K.]

Hello,

Please see the sample report in attachment.

Thank you.

[jay@bplogix.com]

I am afraid that did not work. I am using pre-release from yesterday SW_2011.06.15.

When I click on "John" it works. But any other user returns incorrect data. I displayed {(string)this["Sales"]} on Page3 and it always shows "John" no matter what is selected.

Also, the filter is applied on the DataBand ... is there a way to apply the filter to the DataSource. My concern is that the DataSource has a lot of records ... it may be a performance problem if I can only apply filters to DataBand. I assume filters at the DataSource are faster.

Thanks,
Jay

[jay@bplogix.com]

Were you able to see the same results as me?

[Alex K.]

Hello,

Unfortunately, on the current moment, the report using double DrillDown will not work on the web, because all parameters are applied to the original report that is stored on the server.

Thank you.