Transfer date value from Prompt to prompt

[ranjankumar]

In summary page i have from and to date prompt , while click the drill through
from summary , detail report will display. Date prompt ( date of ) value of
summary page should sit in detail page date prompt . so in detail i should have only 2 date parameters.


ex :

summary
--------
from date prompt value :  jan/01/2009    To date prompt date value : jan/31/2009

Details
--------

Default date will be current date like below

from date prompt value :  May/28/2009    To date prompt date value : May/28/2009

But i need  like below in detail prompt ( from summary it should sit here ) :

from date prompt value :  jan/01/2009    To date prompt date value : jan/31/2009


So in detail report i should use only 2 parameters not four parameters in details filter

[Rajaggopal]

Have a filter in the drill target report to filter out the data item using from and to date, then pass from and to dates from source report using Pass by Parameter method and have it displayed in your target report.

If you do not want to filter target report on from and to date but only want to display them in report page, create two data items in target report query From Date and To Date with expressions ?From Date? and ?To Date? respectively. Then have two filters in target report [From Date] = ?From Date? and [To Date]=?To Date?. Then pass From and To date parameters from source report to target report.

[Gopinath]

Hi Rajan,

Use the same parameter names for date prompts in Summary and Detail report.

Pass the from and To dates from the source report using Pass Parameter Value from Drill-through definitions.

Now the date prompts in your detail report will by default hold the values selected in your summary report.