I used a select/case statement that looks at a parameter in the select expert of a report that has 2 subreports. I have it coupled with a date range parameter as well. I have the same parameters passed on to the subreports and I also used the select case statement in the select expert of the subreports. When I run the report it completely ignores the date parameters that are passed to the subreports. When I take the select case statement out ot the subreport's select expert and leave the date parameters the report works fine. Is there some limitation in the select expert for subreports as regards the select case statement?
Basically I want to be able to find 2 account numbers in a table based on a single parameter. I.E. If "ZA" then ACCT.CODE "*1234*" or ACCT.CODE "*5678*". I then want the subreports to run the same way but pulling criteria from different tables. It would pass "ZA" to the subreport and then run the same select statement.
The main report provides the correct data but the subreport ignores the date ranges that are passed.
Any ideas would be helpful.
S. Kriesten
Basically I want to be able to find 2 account numbers in a table based on a single parameter. I.E. If "ZA" then ACCT.CODE "*1234*" or ACCT.CODE "*5678*". I then want the subreports to run the same way but pulling criteria from different tables. It would pass "ZA" to the subreport and then run the same select statement.
The main report provides the correct data but the subreport ignores the date ranges that are passed.
Any ideas would be helpful.
S. Kriesten