Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).
Article Goal: Set up a default value with a dynamic query in VDM's parameter setup.
In this article we are going to cover the steps to populate the default value of a parameter using a dynamic query.
Where Do You Populate the Default Value with A Dynamic Query?
To set up the Default Value using a Dynamic Query you will need to open / create a view in VDM and go into the parameters tab. Once in the parameters tab, select the parameter you want to begin modifying.
Why Populate the Default Value with A Dynamic Query?
Using the dynamic query to populate the default value will allow you to run a report with pre-set values based on the query used.
Not yet available.
Steps To Populate the Default Value with A Dynamic Query
1. Open VDM
2. Open / Create a View
3. Click on the Parameters tab.
4. Add / Modify a parameter
5. Set the Dynamic property to True under Default Value.
6. Enter / Paste a query into the Value under the Default Value section (Can copy & paste your dynamic query if you already have one).
7. Run the View to confirm you are getting the desired Default Values from your query.