How to use dynamic query parameter in RS?

Hi All,

I am trying to make my first report using dynamic parameter to query oracle database.

The parameter list is list of several year. The report will diplay the data from the year the user choose in report parameter. This is no problem. But when I want to show data from all of the years which I add a item i parameter list with "All", So if user choose All, the report will show all data. Thanks for any help.

Here is my query in data tab:

SELECT PERIOD, LEV_HARDAT_VIKT, LEV_CLAGER_KUND_VIKT, LEV_HARDAT_TOTALT_VIKT, LEV_ORDINART_VIKT, LEV_OVRIGT_VIKT, LEV_TOTALT_VIKT,
NULAGE_CLAGER_VIKT, NULAGE_NYVALS_VIKT, NULAGE_OVRIGT_VIKT, NULAGE_TOTALT_VIKT, INSORT_CLAGER_VIKT
FROM ELLEN.ELL_FORS_MRV_VY1
WHERE (FLOOR(PERIOD / 100) = :YEAR1)
ORDER BY PERIOD

I could be something like this:

SELECT PERIOD, LEV_HARDAT_VIKT, LEV_CLAGER_KUND_VIKT, LEV_HARDAT_TOTALT_VIKT, LEV_ORDINART_VIKT, LEV_OVRIGT_VIKT, LEV_TOTALT_VIKT,
NULAGE_CLAGER_VIKT, NULAGE_NYVALS_VIKT, NULAGE_OVRIGT_VIKT, NULAGE_TOTALT_VIKT, INSORT_CLAGER_VIKT
FROM ELLEN.ELL_FORS_MRV_VY1
WHERE (FLOOR(PERIOD / 100) = :YEAR1) OR :YEAR1 = 'All'
ORDER BY PERIOD