MasterData\DetailData query Details
Hallo all,
i m newbye in fast report .I use fastreport 3.24
My first problem is to replicate the exemple in FastReport (MasterDetailUDS).
But in my case i transferred the datas in a database and i called a query.
I ll be more exact.
SQL CODE
The sql is divided in two queryes.
The first : select * from master order by idmaster ;
The second : select * from detail,master where detail.idmaster = master.idmaster order by detail.ID
The table master contain this record
ID Name
1 1
2 2
3 3
The table detail contains these records
ID IDMaster Name
1 1 1.1
2 1 1.2
3 2 2.1
4 2 2.2
5 3 3.1
6 3 3.2
In fast report i put first the MasterData and after the Detail Data
In delphi7 i put 2 tfrxDBDataset one for each adoquery and i connect them at each masterdata and detaildata in fastreport.
So the output i would like to se would be :
MASTER DATA
DETAILDATA
1
1.1
1.2
2
2.1
2.2
3
3.1
3.2
But instead i see
1
1.1
1.2
2.1
2.2
3.1
3.2
Where i make errors ?
Thank all for future answers.
i m newbye in fast report .I use fastreport 3.24
My first problem is to replicate the exemple in FastReport (MasterDetailUDS).
But in my case i transferred the datas in a database and i called a query.
I ll be more exact.
SQL CODE
The sql is divided in two queryes.
The first : select * from master order by idmaster ;
The second : select * from detail,master where detail.idmaster = master.idmaster order by detail.ID
The table master contain this record
ID Name
1 1
2 2
3 3
The table detail contains these records
ID IDMaster Name
1 1 1.1
2 1 1.2
3 2 2.1
4 2 2.2
5 3 3.1
6 3 3.2
In fast report i put first the MasterData and after the Detail Data
In delphi7 i put 2 tfrxDBDataset one for each adoquery and i connect them at each masterdata and detaildata in fastreport.
So the output i would like to se would be :
MASTER DATA
DETAILDATA
1
1.1
1.2
2
2.1
2.2
3
3.1
3.2
But instead i see
1
1.1
1.2
2.1
2.2
3.1
3.2
Where i make errors ?
Thank all for future answers.