Paramaterized report filter

[Guest]

I have a report with a filter on the report property sheet that looks
something like:

X = [Enter X:]

So, when the report opens (opens or loads?) the user is prompted to "Enter
X:" and everything works fine.

Now, I want to be able to capture and use this value (that the user types
in) in another place on the report. How can I do that? Can I just treat
"[Enter X:]" as a report object with the name [Enter X:] ?

Something tells me that this is more involved. Perhaps I need to get the
value from the user prior to the filter being loaded and then formulate the
user based on the value already obtained.

Any help with this is greatly appreciated. Thanks.

David

 

[Allen Browne]

Yes, you can use [Enter X:] anywhere on your report.

If this parameter is a number or a date (not just text), be sure to declare
the parameter in your query (Parameters on Query menu in query design), so
you can specify the data type.

 

[Guest]

Allen,

Thanks for your help. The parameter is an integer. How does one declare a
parameter in a report filter?

Thanks again.

David
---------

Yes, you can use [Enter X:] anywhere on your report.

If this parameter is a number or a date (not just text), be sure to declare
the parameter in your query (Parameters on Query menu in query design), so
you can specify the data type.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

I have a report with a filter on the report property sheet that looks
something like:

X = [Enter X:]

So, when the report opens (opens or loads?) the user is prompted to "Enter
X:" and everything works fine.

Now, I want to be able to capture and use this value (that the user types
in) in another place on the report. How can I do that? Can I just treat
"[Enter X:]" as a report object with the name [Enter X:] ?

Something tells me that this is more involved. Perhaps I need to get the
value from the user prior to the filter being loaded and then formulate the
user based on the value already obtained.

Any help with this is greatly appreciated. Thanks.

David

 

[Allen Browne]

What I tend to do is provide a form where the user opens the report.

Place a text box on the form where the user can enter a value. If they enter
something, build a WhereCondition for the OpenReport action. In the report,
you can then refer to:
=[Forms]![MyForm]![MyTextbox]

Set the Format property of the text box to indicate its data type.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Allen,

Thanks for your help. The parameter is an integer. How does one declare a
parameter in a report filter?

Thanks again.

David
---------

Yes, you can use [Enter X:] anywhere on your report.

If this parameter is a number or a date (not just text), be sure to declare
the parameter in your query (Parameters on Query menu in query design), so
you can specify the data type.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

I have a report with a filter on the report property sheet that looks
something like:

X = [Enter X:]

So, when the report opens (opens or loads?) the user is prompted to "Enter
X:" and everything works fine.

Now, I want to be able to capture and use this value (that the user types
in) in another place on the report. How can I do that? Can I just treat
"[Enter X:]" as a report object with the name [Enter X:] ?

Something tells me that this is more involved. Perhaps I need to get the
value from the user prior to the filter being loaded and then

formulate
the

user based on the value already obtained.

Any help with this is greatly appreciated. Thanks.

David

 

[Guest]

Allen,

Thanks very much. Why didn't I think of that! (Just a rhetorical
question).

David
-----------

What I tend to do is provide a form where the user opens the report.

Place a text box on the form where the user can enter a value. If they enter
something, build a WhereCondition for the OpenReport action. In the report,
you can then refer to:
=[Forms]![MyForm]![MyTextbox]

Set the Format property of the text box to indicate its data type.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Allen,

Thanks for your help. The parameter is an integer. How does one

declare

a
parameter in a report filter?

Thanks again.

David
---------

Yes, you can use [Enter X:] anywhere on your report.

If this parameter is a number or a date (not just text), be sure to declare
the parameter in your query (Parameters on Query menu in query

design),

so

you can specify the data type.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


<David> wrote in message I have a report with a filter on the report property sheet that looks
something like:

X = [Enter X:]

So, when the report opens (opens or loads?) the user is prompted to "Enter
X:" and everything works fine.

Now, I want to be able to capture and use this value (that the user types
in) in another place on the report. How can I do that? Can I just treat
"[Enter X:]" as a report object with the name [Enter X:] ?

Something tells me that this is more involved. Perhaps I need to

get
the

value from the user prior to the filter being loaded and then formulate
the
user based on the value already obtained.

Any help with this is greatly appreciated. Thanks.

David