I have a report and I prompt the user from VBA and add those selected values as conditions in the report (not as sending the value back to the prompts in the query builder). Now I like to display those conditions in the report, Can anybody please tell me how to achieve that.
Dwayne,
I don’t have a fixed set of prompts from vba. I jump between different forms based on user input from the previous form. So I don’t know how many variables I may need. So I thought of traversing the Conditions in the report once I add all the conditions. But I am confused with the collection set of conditions as I am new to VB or SDK. The Report has only one dataprovider generating one query. Please help me how to parse through the conditions to capture the objects and values selected.
Well, your code is already building / changing the data provider, so I’m a little confused on what more could be needed. That said, take a look at the code behind this utility. That utility copies a data provider, so it touches every part of the data provider, and should nudge you in the right direction.
my code is adding conditions to the query.It’s not building the whole SQL. I was trying to display the conditions as selection criteria in my reports… The link will help me I guess. Thanks