Hello,
I am working on a report that consists of 1 parent and 2 child tables, linking on a single common column. The 2 child tables have essentially the same types of data, but having 2 different tables made using a tabbed grid linker very easy (without having to save some kind of "type" identifier in the different grids).. My database is SQL Server and the report SQL connection is ad hoc..
Anyway, I am getting multiple copies of the same records within the 2 sub reports I have included in the main report.. So, if for a single record in the parent table there are 2 rows in child 1 and 3 rows in child 2, then the subreports display 6 rows of data in each subreport area (2x3)
What I was hoping Alpha did was similar to what I can do with Crystal: Define the main report based on the parent table, define the 2 subreports based only on those child tables, and then they are linked via parameter fields in the main report definition.
So my options are mess with the SQL connection and try to apply filters at that level, maybe, or work with the filters in the subreports themselves. I am not sure how to modify the SCANNING("SQLDATASOURCE") filter that is applied to the subreports by default. Is there a test for uniqueness I could use? Suppress duplicates or something like that? Each child table has a row_id column that is a unique identifier, but there could be 2 row_ids that match between the child tables...
Sorry if the above is confusing..
TIA
Erik
I am working on a report that consists of 1 parent and 2 child tables, linking on a single common column. The 2 child tables have essentially the same types of data, but having 2 different tables made using a tabbed grid linker very easy (without having to save some kind of "type" identifier in the different grids).. My database is SQL Server and the report SQL connection is ad hoc..
Anyway, I am getting multiple copies of the same records within the 2 sub reports I have included in the main report.. So, if for a single record in the parent table there are 2 rows in child 1 and 3 rows in child 2, then the subreports display 6 rows of data in each subreport area (2x3)
What I was hoping Alpha did was similar to what I can do with Crystal: Define the main report based on the parent table, define the 2 subreports based only on those child tables, and then they are linked via parameter fields in the main report definition.
So my options are mess with the SQL connection and try to apply filters at that level, maybe, or work with the filters in the subreports themselves. I am not sure how to modify the SCANNING("SQLDATASOURCE") filter that is applied to the subreports by default. Is there a test for uniqueness I could use? Suppress duplicates or something like that? Each child table has a row_id column that is a unique identifier, but there could be 2 row_ids that match between the child tables...
Sorry if the above is confusing..
TIA
Erik
Comment