Hi guys, This is a Relational Question,
I have a requirement to have a Source and Target Report established based on a month time period.
So, the Source Chart shows a Bar Chart based on one month and the Drill-thru Target Report should
show a Month of data from the same exact Fact table.
Of course, the detailed report has a Prompt Page and I don't need the Prompt Page
to be displayed when I'm passing parameters from Source to Target.
If you have any recommendations, I would greatly appreciate it .
OK, I figured it out. :) :)
Used the ?parametername? to bypass the Prompt Page display for the selected parameter in the Target and Source.
Established a Drill-thru parameter and passed it to Target so the Target knows it's a call from a Source
Chart and not a direct run of the Report.
Here is the code in the Target for the Date Selection:
if (?drill? = 'Y') then ([Presentation View].[Date] >= _add_days(current_date, -31) ) -- Go back 31 Days
else
([Presentation View].[Date]>= ?Begin_Date_Param?) -- Bypass 31 Days and Use Prompt Page values.
Same code for getting the End Date since if they run the report directly, you'll need the Target's Prompt Page to
work and not the Drill-thru stuff.
Same thing for the End Date.
works great! 8) 8) 8)