Forum

Is it possible to implement drilldown in spreadsheet template based reports?

Hello Peter,

of course, there is such a possibility.

There are two ways: the standard one, when a certain value is opened from the report, for example, a product card, and the second method allows our to call our procedure when we double-click on the report.

For the first method, we need to specify the "DetailsPatameter" for the desired cell (pic.1).

The code may look like this (pic.2). Note that the "SpreadsheetDocument" must be in Read-Only mode!

The result looks like this: we generate a report and double-click on the cell. After that, the product card opens (pics 3 - 4).

The second method is more complicated, but also more interesting. I will describe it a little later.

Can I assign to DetailsParameter some procedure or function name I want to invoke on double click?

Yes, you can. This is the second way.

I will try to make an example today or at least tomorrow.

So, if we want to call the procedure with a double click, we need to do the following:

Firstly, it is necessary to display the "SpreadsheetDocument" on the form, and not show it separately (pic.1).

Similarly to the first example, we set the details parameter (pic.2)

But unlike the first example, we pass the Structure as a detail! Moreover, it can be a very complex structure in which you can put any data you need (pic. 3)

And most importantly, we have an event that allows us to process this structure with a double mouse click (pic.4)

For example, like this (pic.5)

But here everything depends on your imagination.

and I have attached the source code for your convenience.

Thanks, Alex!