BeforeOpenDataPipelines fired once

Timbralofacil

Hello

I'm evaluating your report solution in order to see if you can meet my requeriments.

However I'm stuck on the middle of a Report, I've constructed 5 dataviews linked together successfully, when I print the Report I only see that main Dataview is fired and I saw only this data on the report result, but the other 4 dataviews are not triggered why?

Thanks

nicocizik

Hi Alejandro,

The BeforeOpenDataPipelines event is designed to fire only once before all datapipelines are opened. This event was added so that it would be possible to easily add custom parameters to the underlying SQL or perhaps generate custom SQL before any data is accessed.

Perhaps a bit more information about what you are trying to accomplish will allow me to recommend how to proceed with your report and which event(s) to use.

Timbralofacil

Thanks Nico

Please take a look at the next picture



As you can see I have many dataviews designed but only the main named "Factura" is fired when I executed the "print" method, the rest of the dataviews are not triggered so the final report is not complete.

I only get data from the "Factura" dataview but I need the rest of the linked dataviews also in order to fill the report.

Thanks

nicocizik

Hi Alejandro,

A report will only traverse the dataset it is connected to. If you need to traverse more than one dataset, you will need to use subreports (connected to those datasets) to do so.

I suggest taking a look at the Developer's Guide that is installed with ReportBuilder and working through the included tutorials. This will give you a good base for how ReportBuilder functions and how to create the high level reports you need.