Record Select - selecting a range of values
I am trying to modify a report which currently is pulling information based on a value for the month (in number format).
So a parameter is used, someone inputs a number and the record select is then set to only pull records of that month. Simple enough.
What I am trying to do now is change it so that the user can select a range, for example "1-12" which will look at all months.
I am having trouble accomplishing this.
I have a few formulas set up so one of them simply gets the range:
shared stringvar startmonth;
shared stringvar endmonth;
Then others which can process them, make a list of all the values in between etc.
Now, I just dont know how to get those values into the record select. I can't declare a shared variable in the formula, and I dont know how else I can pass all the values to it so we can select the right data.
sharon towler replied
the parameter is declared in the stored procedure?
if it is in the stored procedure create 1 more and call it beg per
rename the other end per
in the record selection
if in beg per to end per
it should pick up the records in that period
if the parameter is in the report then modify it to select range of values
then use the above formula in the record selection