Relation - Data Dictionary
Hoping somebody can help me....
I have 1 Datasource with 4 tables from a SQLite database.
On my report I have the following bands
- Page Header
- Data Band
- Page Footer
I have created a relation between 2 of the tables.
I have added 10 fields from table 1 to the report and 1 field from table 2.
I am expecting the field from table 2 to change with the main data (table 1) but it does not.
for each record from table 1, the data from table 2 does not change!
How can I get this working? Please help
Thank You
I have 1 Datasource with 4 tables from a SQLite database.
On my report I have the following bands
- Page Header
- Data Band
- Page Footer
I have created a relation between 2 of the tables.
I have added 10 fields from table 1 to the report and 1 field from table 2.
I am expecting the field from table 2 to change with the main data (table 1) but it does not.
for each record from table 1, the data from table 2 does not change!
How can I get this working? Please help
Thank You
Comments
I think if you create the main band to link to table 1, then add child band and link to table 2, and add all fields to the child band, shrink the height of the main detail band to 0, this might work, not sure, I'm fairly new to FR myself.
Jason