Recall variable

  • Looking for was that the last variable could be stored to be used the next time the report was open. Example: Having the to and from dates remain. Or having the from date be the next to date and the to date the current date.

  • Just a thought...

    create a table with the parameters as fields.

    have the report's parameters use the value from this table as defaults but not available values.

    have the dataset that is used for the report come from a stored procedure. In that stored procedure, have it update your parameter table. Just keep only one record in the parameters table.

    Then the next time the report comes up, the parameters from the previous rendering would populate the parameters in the report. Since you don't restrict the available values they can be changed.

    I haven't tried this, but it should work.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply