ParrameteRR not refreshing data
Posted: Tue Oct 30, 2001 12:46 am
I^ve written a quick report to try out the ParameteRR function.____I ask the user for a parameter ("A" for all recs or "C" for only completed recs) to determine which recs to print. I then use this parameter in a Calculated item "PRT_REC" which gets set to TRUE or FALSE depending on the status of each record & the ParameteRR the user entered. I then use the "PRT_REC" calculated item in the report query to select which records to include.__ __All works OK when I preview to the screen the first time & all recs are displayed (as the default for the ParameteRR is "A" for ALL).____Then I preview it again and change the ParameteRR to "C" and just the Completed recs are displayed as expected.____If I then preview it for a third time & don^t touch the ParameteRR - just press OK - then only the Completed recs are displayed even though the default value for the ParameteRR is "A" for ALL - and I notice that the Select Recs screen doesn^t come up - the report just starts straight away as if it is using the current subset of data & not refreshing the selected data. If I preview again, but this time change the ParameteRR to "A" -even though it is defaulting to "A", then it re-selects the data and displays all recs as expected. __ __It^s as if when you press OK to the ParameteRR screen without changing anything, R&R knows that none of the parameters have been changed & therefore decides to not refresh the selected data - even though it needs to because the currently selected data was not selected with the default ParameteRR values.__ __Any thoughts???__ __TIA__ __Rick__