I'm not sure if this can be done but thought I would throw it out for you guru's to help with.
I have several drill thru reports running off of my main report. The filter in my main report is FY = ?, Pd = ? and Sub pd = ?.
My second report has to be year to date so the Pd has to be Pd <= ?
Is there a way to build the filter in the second report so that I don't have to use a prompt? I want it to look at the prompts in the 1st report.
Thanks
I have several drill thru reports running off of my main report. The filter in my main report is FY = ?, Pd = ? and Sub pd = ?.
My second report has to be year to date so the Pd has to be Pd <= ?
Is there a way to build the filter in the second report so that I don't have to use a prompt? I want it to look at the prompts in the 1st report.
Thanks