Multiple Years in parameter for selection criteria

[AnnetteB1305]

I have a report where I have a parameter that asks the user for the year required. This is set up as a string. I want to allow multiple values which I have set in the parameter but then I'm falling over with the selection criteria

Year({INF_OPP_EXT.SALE_DATE})in tonumber({?Reporting Year})

It is asking me to subscript the parameter but not sure what this means and how to do this

Thanks,

Annette

 

[lbass]

Change the parameter to a number datatype and then use:

Year({INF_OPP_EXT.SALE_DATE}) = {?Reporting Year}

You can use "in" if you wish, but it's not necessary.

-LB

 

[AnnetteB1305]

Yes but that puts a comma in the display of the field on the parameter selection and they don't like that.

 

[lbass]

You could create a number parameter and add the year as the value, and then add the year also as the description--without commas. Then check the setting "Show Description Only". This means you have to manually enter several years, but it doesn't take that much effort. Then you would still use the formula I suggested.

-LB

 

[AnnetteB1305]

Great I'll give it a go....never thought of that