Standalone Filters - Best Practice usage

[twlarsen]

Hello,

I’m trying to come up with the best way to use a standalone filter in framework manager.

I have a table with records that look like this:

Date; Posting Month;
11/15/2008; 200811
12/31/2008; 200812
1/1/2009;  200812
1/7/2009; 200901


I want to be able to select Posting Months 200811-200812 using a standalone filter that a report writer can pull down into the report in report studio.  The posting months needed for this filter change on a monthly basis, so I don’t want to store the actual values in the filter, I would like to store the values somewhere in the database so that they can be easily changed

Thanks,

Todd

[blom0344]

Create a table that stores the desired value for the posting months. Inner join these to the  existing table. Instruct users to drag an object from the additional tablle in the report and the inner join will automatically act as a filter for the desired values..

Just one method..

[twlarsen]

Thanks Blom, your expertise is always nice to see.