calculate a report parameter (hidden) based on a previously chosen parameter

thelcd

<p>Hi all,</p><p> </p><p>I'm trying to create a parameter automatically based on user input.</p><p> </p><p>For example, the user will select a date parameter and the month+1 will be calculated from the list box.</p><p> </p><p>A query is then executed based on the month > input_choice and < calculated_param.</p><p> </p><p>I'm wondering how to do this..,</p><p> </p><p>it seems that when the report is executed the parameter is not "linked" to the user choice....</p><p> </p><p>Any help appreciated.</p>

Hans_vd

<p>Hi,</p><p>I wouldn't create two parameters for this.  You can bind the same report parameter to two different data set parameters.  You can then add the month in the query:</p><p> </p><p>select *</p><p>from table</p><p>where data_column between p_date_param and add_months(p_date_param, 1)</p><p> </p><p>The add_months function is how it is done in an Oracle database, not sure how it is done in other databases</p>