Dynamic Drill Through Reports by passing Source Table Name and Filters as the Parameter Value Prompts

This is not currently being worked on. However the ideas are valid. We will continue to monitor this request through voting and will adjust it's priority accordingly.

Please let me know if you need any information.

Please let me know if you need additional information. This should work close to Query Macros. But Query macros require Static column names to be defined within a list report. Here below are more details:

I want to build a List Report (which will be used as the target drill thru Report) which should display the results based on certain parameters that I pass from a Parent Report.

I am looking for the options for the List Report to work in either of these ways

1. I want to pass the Database Table Name, Column Names, Date Filter condition as parameters to the List Report via the Parent Report

Parameters: Database Table Name, Filter Condition, Database Columns

As an Example : Database Table Name = "Customer"

Filter Condition: "ActiveDate='2020-08-05'

Database Columns: ColumnA, ColumnB, ColumnC

I want the List report to display the results from the Table with a SQL Equivalent of:

SELECT * FROM Customer WHERE ActiveDate='2020-08-05'

{OR}

SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'

2. I can pass the SQL Query and Date Value via Parent Report to the Drill Thru Report (List Report)

Parameters: Database_SQL_Statement, Date_Filter_Value

As an Example : Database_SQL_Statement = "SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate="

Date_Filter_Value="'2020-08-05"

I want the List report to display the results from the Table with a SQL Equivalent of:

SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'

3. I can pass the whole SQL Query as Parameter via Parent Report to the Drill Thru Report (List Report)

Parameters: Database_SQL_Statement

As an Example : Database_SQL_Statement = "SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'"

I want the List report to display the results from the Table with a SQL Equivalent of:

SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'

Basically it does not have to be a List Report I basically want the users to see the detailed results either through List Report Report or any other way possible.

More details here :https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=d6c60b64-dafa-419d-a2e3-7659c5a13caf&CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=digestviewer#bmd6c60b64-dafa-419d-a2e3-7659c5a13caf