Forum Discussion
Show only data already filtered in Table object
Good afternoon
I have two table objects and a report. Table1 and Table2. Table 1 and Table2 are related by an ID. Table1 is a header and Table2 is its detail.
Upon entering the report, Table2 pulls out all the records and I just want you to take out already filtered records when you click on a line in Table1. That is, when I enter the report in Table2 I do not deploy anything and it is necessary to click on a line of Table1.
Is it possible to do this?.
Thank you in advance
2 Replies
Syndicate_Admin
This is not clear to me. Could you please provide a sample of the 2 tables, and describe which column you want to filtered with.Usually, once you have a relationship between the 2 tables, you may use table 1 column in the filter panel. And the data from the table 2 will display only filtered result.
Paul Zheng _ Community Support TeamGood afternoon
First of all, thank you for answering. I have two tables that have the same query as a data source. When you enter the report you see the following:
The table above I want to show you how it is, in this case with the three lines.
The table below, I want when I enter the report to be empty. And that when you select a line from the table above filter below:
That already works for me, as I show in the following image, you see that when you click on a line in the table above, the table below also shows only one line:
Can you do what I ask?. As I indicate, the two tables actually have as their origin the same data, but in the one above I show some columns and in the one below I show others.
I'm waiting for your answer.
Thank you!!
