I just cannot figure out how to create a dynamic reporting so that the recordsource of the subform change based on data in the source table.
I have one report with some general stuff in the header section. I have 10 different "subreports" and I want all kind of combinations of those reports. The best way to do it would is to put those in "dynamic" report.
Now, the source of this main report (parent) is a table which includes 52 combinations of those subreports. The fields in the records includes SQL-clauses or report name for the recordsource for the subreport. But I cannot get this work. I have tried days to get this work but no success.
It seems that after opening the report the subreport recordsource info cannot be changed.
I would really like to prevent making 52 reports by making this report generator based on data in the field.
How can I do this?
I have one report with some general stuff in the header section. I have 10 different "subreports" and I want all kind of combinations of those reports. The best way to do it would is to put those in "dynamic" report.
Now, the source of this main report (parent) is a table which includes 52 combinations of those subreports. The fields in the records includes SQL-clauses or report name for the recordsource for the subreport. But I cannot get this work. I have tried days to get this work but no success.
It seems that after opening the report the subreport recordsource info cannot be changed.
I would really like to prevent making 52 reports by making this report generator based on data in the field.
How can I do this?