Click Event for sub report

[ymc]

I have some requests from client about:

1. They want to display some data in the form of bar chart and during double click on the specific bar then display the detail. My idea is about can I just have a double click event and then rendering another report or enable the pre-rendered page to display? Any idea which method is possible to get the result.

2. The request is nearly the same as above but this time is click on the row and pass the value to render another report base on the clicked row data?

Thx.

[Vital]

Hello,

1. They want to display some data in the form of bar chart and during double click on the specific bar then display the detail. My idea is about can I just have a double click event and then rendering another report or enable the pre-rendered page to display? Any idea which method is possible to get the result.

At this moment this is not possible.

2. The request is nearly the same as above but this time is click on the row and pass the value to render another report base on the clicked row data?

Yes, it possible. Please see sample project LiveReports from standard delivery.

Thank you.

[mihiri]

Would you please explain how case 2 is done, this example is not clear to me..
Thank you in advance

[Vital]

Hello,

Would you please explain how case 2 is done, this example is not clear to me..
Thank you in advance

Each component in report have filled Bookmark property (or Tag property). This value used as parameters for detail reports. Before report running we have signed to Click event of
report:

Code: Select all

report.CompiledReport.Click += new EventHandler(click);

In event handler of this event we use following code:

Code: Select all

private void click(object sender, EventArgs e)
		{
                        //Component which generate click event
			StiComponent comp = sender as StiComponent;
                        //Our parameter
			string customerID = (string)comp.BookmarkValue;
            
                        //Run report with parameter
			if (customerID != null)
			{
				StiReport report = new StiReport();
				report.RegData(dataSet1);
				report.Load("..\\..\\Details.mrt");
				StiDataBand dataBand = (StiDataBand)report.Pages["Page1"].Components["DataBand1"];
                                //Parameter assigned to databand filter
				dataBand.Filter.Value = "{Orders.CustomerID==\"" + customerID + "\"}";
				report.Show();
			}
		} 

Thank you.

[mihiri]

thanks a lot for your detailed description. But this code is not available in the
"C:\Program Files\Stimulsoft Reports.Net 2007.3\.Net 2.0\Samples\C#\LiveReports\LiveReports.mrt"
am I browsing the wrong place?

[Vital]

Hello,

Please see code of Form1.cs.

Thank you.

[Pio Leonardo V. Rapirap]

Had a look at this code:

Code: Select all

private void click(object sender, EventArgs e)
        {
                        //Component which generate click event
            StiComponent comp = sender as StiComponent;
                        //Our parameter
            string customerID = (string)comp.BookmarkValue;
           
                        //Run report with parameter
            if (customerID != null)
            {
                StiReport report = new StiReport();
                report.RegData(dataSet1);
                report.Load("..\\..\\Details.mrt");
                StiDataBand dataBand = (StiDataBand)report.Pages["Page1"].Components["DataBand1"];
                                //Parameter assigned to databand filter
                dataBand.Filter.Value = "{Orders.CustomerID==\"" + customerID + "\"}";
                report.Show();
            }
        } 

tried it, and successfully duplicated this one.


Hi! just a quick question.

how would it work if instead of loading an mrt file,
we load a compiled report instead

Code: Select all

report = StiReport.GetReportFromAssembly("Detail.dll");

is Filtering a databand value same as

Code: Select all

dataBand.Filter.Value = "{Orders.CustomerID==\"" + customerID + "\"}"; 

I tried this statement (although I know it wouldn't work)

Code: Select all

		StiDataBand dataBand = report.CompiledReport.GetComponents()["DatadsProject"] as StiDataBand;
		dataBand.Filter.Value = "{dsProject.busent== " + strBusEnt + "}";

it's obviously incorrect and honestly I don't have any idea how to do it :pffft:

Any Thoughts?!
Is it possible to create a parameter inside the Detail.mrt
and pass a value from it?

Are parameters accessible inside a compiled report? (dll) :byebye:

[Edward]

Hello.

how would it work if instead of loading an mrt file,
we load a compiled report instead

In that case the filter could be created with help of variables. This variables can be set before rendering and filters will work as expected.

Please make the following steps:

- Create MyVariable variable in the Dictionary.

- Set the Filter asexpression in the Designer as following:

Code: Select all

Orders.CustomerID==MyVariable

- before calling Render() or Show() command, assign the variable in the compiled report:

Code: Select all

myCompiledReport["MyVarialbe"] = 5;

Thank you.

[Pio Leonardo V. Rapirap]

Hello.

how would it work if instead of loading an mrt file,
we load a compiled report instead

In that case the filter could be created with help of variables. This variables can be set before rendering and filters will work as expected.

Please make the following steps:

- Create MyVariable variable in the Dictionary.

- Set the Filter asexpression in the Designer as following:

Code: Select all

Orders.CustomerID==MyVariable

- before calling Render() or Show() command, assign the variable in the compiled report:

Code: Select all

myCompiledReport["MyVarialbe"] = 5;

Thank you.

Worked like a charm!
Great Thanks Edward!

[Edward]

Hello

Please let us know if any help is required.

Thank you.