Filter Dynamically based on another variable Prompt Values

[rrbo]

Hi All,

I have report that contains the prompt Base Line begin Date and Base Line End Date;
In the report i have a column like Year.
I want to include filter for Year based on the above prompts.

That Means I have data for Year field in data base is 2002,2003.I am getting those two values on my report.
I am giving Prompt values for another variable not for the same year field as 1/1/02 and 12/31/02

My question is i want to filter year based on Those prompt values. for ex here Year should be filtered for 2002.I want to include this filter dynamically(Globally)

Can any body give me the suggestions ,syntax on how can we insert the filter dynamically.


Please let me know how to do this.

Thanks

 

[sriramna]

Well, you could always add the appropriate SQL WHERE clause to the SQL of the report:
WHERE MyYearfield = YEAR(MyPromptedField) ?