WarrenTheWindmill
Programmer
I am trying to create a report that contains 2 subreports.
I want to enter from and to dates at the level of the main report and have them used by both the subreports
The subreports are based on different tables but have the same column name, so I have renamed each of the tables as O as in O.fieldname.
I have created a from and to parameter in the main report, which does not link to a field but merely asks for a date.
I have then used the subreport links to link these parameters in the normal way.
If I run this report it does not return any data. If I run th sub reports separately the data appears as expected, so its as if the linking between the main and sub reports isn't working properly.
I've use parameters routinely without problems. Am I missing something obvious?
Help would be very much appreciated as I have run out of ideas!
I want to enter from and to dates at the level of the main report and have them used by both the subreports
The subreports are based on different tables but have the same column name, so I have renamed each of the tables as O as in O.fieldname.
I have created a from and to parameter in the main report, which does not link to a field but merely asks for a date.
I have then used the subreport links to link these parameters in the normal way.
If I run this report it does not return any data. If I run th sub reports separately the data appears as expected, so its as if the linking between the main and sub reports isn't working properly.
I've use parameters routinely without problems. Am I missing something obvious?
Help would be very much appreciated as I have run out of ideas!