Forum Discussion

pal95's avatar
pal95
Helper III
5 years ago

Drilltrough-like functionality in Reports Builder

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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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

  • josef78's avatar
    josef78
    Memorable Member

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