Impromptu Drill Through

[spicysudhi]

i am confused.

i know that to work drill through, we need to have the names same, i was successful in cubes, now trying in impromptu.

question is is this column title, lable or original column name should be same?

[
title : the title on the report
lable : in the query a lable against the database column
original column: database column name
]


will it be possible to have drill through when i have the SQL statement in the query data instead of the column selection. if possible which of this should be same in parent and child report, example i have query like this,
SELECT ORD_NO AS "order_no", ORD_LN "Order Line" from orders;

then whether the column names in reports should be same as ORD_NO or ORDER_NO ???

thanks,
sudhi

 

[spicysudhi]

is drill thru possible when the SQL statements are written behind the report instead of the column selection?

thanks,
sudhi

 

[spicysudhi]

when parent is a query & child is direct columns it works. if both are direct sql then, application crashes, result is same even if the both reports got same sql (implies same column/titles).
my server problem or application?

 

[sln007]

The names of the columns (those in the "data" tab&quotneed to be the same. Then you can select those columns when setting up the drill-thru fields.