Forum Discussion
Help with parameter binding!
Hi JMAlloway - I don't think this can work because you are effective changing the data source connection with the Dynamic M Parameter. You could use the parameter to filter between tables within a database, but not to change between databases.
Thanks for the reply, Daryl! Maybe I'm thinking of this in the wrong way. I'm able to successfully pass a parameter value to the database name. If I manually change the parameter value and refresh, the change in database is successful. My issue is that I need the parameter value to change dynamically. For example, based on the current date, I need the parameter to display the last day of the previous month. (This is because the database is named the last day of each month). I'm thinking I should investigate creating a list query.