Master Detail and ADOQuery
Hi All,
I'm using FastREports Ver 5.1.1 , simle problem but I can't see what the problem is , In essense I have two tables
"Select * from t_asset_serv_hdr" Query for Master Table
" Select * from t_aset_serv_dtl WHERE RecID = :RecID" Query for second table with one parameter
I set the ADOQuery Master Table to the 1st Query
I then set The Parameter Editor to <DBFaultHdr."RecID"> for the parameter "RecID" with an Integer as the type
Drop a Master Data Band and set - run the report and I get all the master data
The I drop a Detail Band on the report set the DataSet and run -
The report shows nothing - I can do the same using ADOTables and it works perfectly - Any ideas why or am I missing something really simple ?
Any Help appreciated
Kind regards
Trevor
I'm using FastREports Ver 5.1.1 , simle problem but I can't see what the problem is , In essense I have two tables
"Select * from t_asset_serv_hdr" Query for Master Table
" Select * from t_aset_serv_dtl WHERE RecID = :RecID" Query for second table with one parameter
I set the ADOQuery Master Table to the 1st Query
I then set The Parameter Editor to <DBFaultHdr."RecID"> for the parameter "RecID" with an Integer as the type
Drop a Master Data Band and set - run the report and I get all the master data
The I drop a Detail Band on the report set the DataSet and run -
The report shows nothing - I can do the same using ADOTables and it works perfectly - Any ideas why or am I missing something really simple ?
Any Help appreciated
Kind regards
Trevor
Comments
"Select * from t_asset_serv_hdr" Query for Master Query
"Select * from t_aset_serv_dtl WHERE RecID = :RecID" for Detail Query
Set the ADOQuery2.Master = ADOQuery1
I have also Problems with Parameter.
All works fine in the case the Parameter are integer or string, but with uniqueidentifier it doesn't work?