sql server reporting services: can i have the same parameter 3 times for different results? -- sql server reporting services

can i have the same parameter 3 times for different results?

Tenchy
11/15/2006 11:29:02 AM

sql server reporting services:

I have 3 list/tables/columns..which ever is the easiest. I want to have a
parameter for the user to pick YEAR1 YEAR2 YEAR3 from drop down lists.
The only problem is when i make the first parameter, it doesnt let me make
another one, since its basically the same as the first, When i tried to make
a new one and change the name, it doesnt work. I basically want to have the
same parameter 3 times, for 3 different years. Which will show the measure
for those three different years based on what the user choses from the drop
down.

Year 1 Year 2 Year3

1 1 1

1 3 2

2 3 2

3 2 2

4 5 3

5 2 2

6 1 1

It seems like it would be easy, if it was 2 or 3 different parameters, but
since im working off a Cube (ANALYSIS SERVICES) when i click the parameter
check box in the dataset for the three different tables, nothing shows up
but the first parameter i made. Why is this? and how do i get it to give me
3 drop down boxes with the same field, but different values, based on the
users choice??

Re: can i have the same parameter 3 times for different results?

Kaisa M. Lindahl Lervik
11/15/2006 10:12:01 PM

Should these years be interchangeable, or could you use Year1, Year1+1 and
Year1+2?

If you could let the years be grouped together, you could stick with your
first parameter.

You might be able to create a few named sets or something, to make the
second and third year parameter. Not sure how, though. (And can't access
cubes right now, so can't check it out.)

On a side note, I've just given up on the whole new way of doing cube
queries. I usually do it the old school way. :)

Kaisa M. Lindahl Lervik

[quoted text, click to view]