# Using value from user response to make the report dynamic

Hi all

First Column, first row of cross tab. (value = 5770.85)
The formula is as follows:
=<Total Units Glass(Top 20 Month)> Where (<Financial Month No(Top 20 Month)>=6 And <Fiscal Year(Top 20 Month)>=2003)

Note that the (<Financial Month No(Top 20 Month)>=6) Â“6Â”value is hard coded and
(<Fiscal Year(Top 20 Month)>=2003) Â“2003Â”value is hard coded.

This report is prompt driven, and the values Â“6Â” and Â“2003Â” in this examples are gained from the following prompts respectively:
=UserResponse (â€śTop 25â€ť , â€śSelect Financial Month eq to?â€ť)
=UserResponse (â€śTop 20 Monthâ€ť , â€śSelect Previous Financial Year eq to?â€ť)

How can I use the value from the user response listed above in the formula above to make the report dynamic, i.e. when the report is run for a different month/year combination, so that the selected values are reflected in the field.

I have tried the formula as follows, but it gives me a syntax error.

=<Total Units Glass(Top 20 Month)> Where (<Financial Month No(Top 20 Month)>= UserResponse (â€śTop 25â€ť , â€śSelect Financial Month eq to?â€ť)) And <Fiscal Year(Top 20 Month)>= UserResponse (â€śTop 20 Monthâ€ť , â€śSelect Previous Financial Year eq to?â€ť))

I have also tried to convert the Â“userresponseÂ” formula to a variable, and then use that as part of the Â“whereÂ” statement, but that also gives me an error.

Any ideas???