Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Drill-Thru Two Tables

What is the best way to show one table as a summary and a 2nd table to show only the drill-thru results of a single # selected in the first table?
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

Nope, current drill through feature not works on summary records. For this scenario, maybe you can try to create a bridge table and use link id as drill through key.

 

In addition, it will be help if you share some expected result for your requirement.

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Here is an example of what I'd like to do if it is possible.    Click on a # from the main report which shows a 2nd report specific to that cell.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Anonymous,

       

      Is there any columns contains guid or other information to link summary one and detail one?

       

      For example:

      Summary table

      ID Name Value
      123 BOB 24

       

       

      Detail table:

      ID Name Value
      123 BOB 12
      123 BOB 10
      123 BOB 2

       

      You can setting id as 'drill through' column to achieve drill summary to detail records effect. If you mean drill 'summarize value' to 'detail values' without relationship keys, it is impossible.

       

      Regards,

      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Yes I have a relationship between two tables that will link these two together.   What is the best way to create these relationships and is it possible the jump-link can take me to table 2 within the same table view with a "back button" to return me back to table one?  All within the same table view?