Rather than using TClientDataSet, did you try to use TDISQLite3UniDirQuery with FastReport directly? I have attached an example project which I will add to the DISQLite3 demos with the next version. It does handle master-detail, but maybe it helps nevertheless? Ralf On 23.08.2011 12:50, Thompson77 wrote: > Hi, > > I want to use DISQLite3 with Delphi 7 and FastReport 4 to generate a > master-detail report. > For this I have to use 2 TClientDataSets and link them together with > MasterSource and MasterFields properties set. > > I did the following: > > DISQLite3UniDirQuery1 with "SELECT id,groupname" (id is INTEGER, > groupname is TEXT) --> DataSetProvider1 --> ClientDataSet1 -> DataSource1 > > DISQLite3UniDirQuery2 with "SELECT rid,groupid,lastname,firstname" > (rid and groupid are INTEGER, lastname and firstname are TEXT) --> > DataSetProvider2 --> ClientDataSet2 -> DataSource2 > > Then I set the MasterSource property of ClientDataSet2 to DataSource1. > > When I want to set the MasterFields property with the Field Link > Designer in Delphi to "groupid=id" I get the error "field 'groupid' can > not be dealed as type variant". > > Has anyone an idea what I can do to solve this? > > Regards, > Thomas