prompting filters 1

[samimichaels]

How do I create a prompt, so that when a report is run, it asks me for a filter.. for example a date. That it would ask me for a date that I could folter my report by?

 

[marckssg]

Create a parameter field making sure you change the value type to date. Then go into the select expert and click on show formula, then formula editor.

Then create a formula like this:

{Table Name.DateField} = {?dateparameter}

Now everytime the report is opened you will be prompted to input a date into the parameter which will then be used to filter the report.

Cheers

Marc

 

[LenaS]

I have created a parameter called "asof"
gone into the select expert and added ledger.bookper "is less than or equal to" {?asof}
this created the formula
{ledger.bookper} <= {?asof}
initially it will prompt me for the numeric value and refresh the report. If I leave CR and get back in, call up the report and tell it to print, it does not prompt me to re-enter the parameter. Only if I click on the refresh toolbar option do I get the option to re-enter or run with previous data. I would like it to prompt always at run-time

 

[IdoMillet]

Turn off the 'Save Data with Report' option under the File menu.

Cheers,
- Ido ixm7@psu.edu