You could do it using a variable linked to a while clause. I have had a similar situation where different operators wanted a different number of copies of a specific print. I added a routine which enabled them to set the number of copies required which is stored in a table within the access...
To clear the fexigrid you only have to input;
flexgrid1.clear
To repopulate the grid with the new recordset you open the recordset and add the results into the flexgrid.
I have had to resolve a similar situation and have found two approaches that work they are;
a) Put the parameters in a temporary table and allow CR to select data dependent on them.
b) Run the select within VB and put the results in a temporary table which CR will use to create the report. On...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.