[CLOSED] Creating a parameter to use within synonym
Hello Everyone,
Hoping you guys can help me with a little task I have. I want to create a filter in my synonym. Specifically a date filter. However I want to be able to select the value for this filter for those reports using this synonym at run time. Basically I am trying to create a parameter that normally is created in a report, and throw it back a level.
Has anyone done something like that before? I am aware of how to create a variable within a synonym (syntax in text below), however I have no clue how to make it into a parameter. VARIABLE NAME=&&DATE_NAME, USAGE=I10, $
*EDIT* My reason for doing this is that I am working with a no-SQL Database that is indexed on a date field. Thus in every single report/chart we need to have this parameter in there. What I would like to do is allow those building these charts to simply drag a filter instead of having to set up a parameter every single time.
Appreciate any advice you all have! Thanks
ZachThis message has been edited. Last edited by: FP Mod Chuck,