I am trying to use a parm in my select statment, to limit records returned by the report. Right now, I have a parm set up to ask the user for a reporting period (month) and the report returns only data for that period. So, currently, if the user wants more than one period of data, they can select each period in the "enter parms" window (I have allowed for multiple values).
I would like to create an option so the user, when promted for the parm, can simply select "all" to get all 12 periods of data, or select an individual, or multiple periods. I am having a hard time figuring out how to accomplish the ALL scenario. The Period field in the database is a number.
Any help would be greatly appreciated thanks,
I would like to create an option so the user, when promted for the parm, can simply select "all" to get all 12 periods of data, or select an individual, or multiple periods. I am having a hard time figuring out how to accomplish the ALL scenario. The Period field in the database is a number.
Any help would be greatly appreciated thanks,