topic Re: Drilltrough-like functionality in Reports Builder in Report Server

Drilltrough-like functionality in Reports Builder

pal95 — Wed, 09 Sep 2020 09:52:26 GMT

Hi, I would like to make something similar to drill trough in the reports builder. I have a parameters like:

ID
TIME
LOCATION
NAME

And I would like people to pick ID, and then Time, Location and Name should be updated automatically, so, for example:

ID = 1

Time: 10:59
Location: City
Name: A

And if someone pick another parameter, for example 2, I would like the report to show the values linked to ID = 2, so

ID = 2,

Time: 11:28
Location: Town
Name: B

I can't achieve it as if I put one main parameter (user can choose the relevant ID), and other internal parameters in the report, these internal parameters don't refresh when the user changes ID.

Re: Drilltrough-like functionality in Reports Builder

Greg_Deckler — Wed, 09 Sep 2020 21:14:28 GMT

pal95 Not following this, can you post sample data? Screen shots? I am not able to visualize this what you want.

Re: Drilltrough-like functionality in Reports Builder

josef78 — Thu, 10 Sep 2020 08:09:26 GMT

setup default value of secondary (hidden/internal) parameters (eg.town) based on first parameter (ID}