Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Query for parameter suggested values (global variable for entire project?)

We are trying to set global variables StartDate and EndDate that all queries can references as a filter.   I would like to set StartDate to this TSQL formula SELECT DATEADD(MONTH, -12, DATEADD(MONT...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thank you for the feedback, still encountering problems. I followed instructions as noted in screenshot below and the Query dropdown box still won't accept values. Is there anything else I'm missing?

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

Based on your screenshot, you are missing the step that get a list from the date column in your table. As stated in the blog I have post, To get a list from a column in your table,  you need to click on the column to select it and then right-click and select either:

  • Drill Down
  • Add as New Query

After you successfully get a list, you can have a list mark which looks like as follows.


Thanks,
Lydia Zhang