Parameters display(Urgent)

I have a reporting requirement which is mentioned below
I have three(3) parameters in my report which are
Year
Semester
Quarter
I have a text box in my "Report Layout" which should show me these parameter
values according to the following requirement.
1) If a particular year is selected say "2007" and "Semester" and "Quarter"
parameters are selected as "All" then the text box should display "2007".
2) If a particular "Year" is selected say "2007" and "Semester" parameter is
selected as say "Semester 1" and the "Quarter" parameter is selected as "All"
then the text box should display "Semester 1 2007".
3) If a particular "Year" is selected say "2007" and "Semester" parameter is
selected as say "Semester 1" and "Quarter" parameter is selected as say
"Quarter 1" then the text box should display "Quarter 1 2007".
Please help me in doing this if anybody has the solution.
Also let me know if there are any possibilities to give "radio buttons" for
the parameters in SSRS 2005.
Thanks in advance.
--
Regards,
ArvindRavishYou have to use an Expression to fill Value property of the textbox, using
string concatenation and conditional statement (like IIF or Choose).
For example :
IIf(Parameters!Semester.Count < 10, Parameters!Year & Parameters!Semester,
Parameters!Year )
--
Jean-Pierre Riehl
http://www.blog.djeepy1.net
http://www.bewise.fr
"ArvindRavish" <ArvindRavish@.discussions.microsoft.com> wrote in message
news:6A5FB99D-BBCC-4EEA-BC65-02FDCF693544@.microsoft.com...
>I have a reporting requirement which is mentioned below
> I have three(3) parameters in my report which are
> Year
> Semester
> Quarter
> I have a text box in my "Report Layout" which should show me these
> parameter
> values according to the following requirement.
> 1) If a particular year is selected say "2007" and "Semester" and
> "Quarter"
> parameters are selected as "All" then the text box should display "2007".
> 2) If a particular "Year" is selected say "2007" and "Semester" parameter
> is
> selected as say "Semester 1" and the "Quarter" parameter is selected as
> "All"
> then the text box should display "Semester 1 2007".
> 3) If a particular "Year" is selected say "2007" and "Semester" parameter
> is
> selected as say "Semester 1" and "Quarter" parameter is selected as say
> "Quarter 1" then the text box should display "Quarter 1 2007".
>
> Please help me in doing this if anybody has the solution.
> Also let me know if there are any possibilities to give "radio buttons"
> for
> the parameters in SSRS 2005.
> Thanks in advance.
> --
> Regards,
> ArvindRavish