"C.M" wrote:

> you could try a nested IIF statement in the "jump to report" expression box .
>
> -------------------------
> IIF(Parameters!option.Value=1,"1_subreport",IIF(Parameters!option.Value=2,"2_subreport","blank_subreport"))
> -------------------------
>
> or a switch statement is the same expression box .
>
> ---------------------------------------
> =Switch( Parameters!option.Value=1,"1_subreport",
> Parameters!option.Value=2,"col_2_subreport" )
> ----------------------------------------
> "Ben Cole" wrote:
>
> > Here is the CASE statement I've used:
> >
> > CASE (WHEN ReportType = 1 THEN 'First Report.rdl' WHEN ReportType = 2
> > THEN 'Second Report.rdl' WHEN ReportType = 3 THEN 'Third Report.rdl' WHEN
> > ReportType = 4 THEN Fourth Report.rdl' WHEN ReportType = 5 THEN 'Fifth
> > Report rdl' WHEN ReportType = 6 THEN Sixth Report .rdl' WHEN ReportType =
> > 7 THEN Seventh Report .rdl') END
> >
> > I did change the report names for security reasons!!!
> >
> > Thx, Ben
> >
> > "C.M" wrote:
> >
> > > PLease show your IIF statement . IT may just be a formating issue
> > >
> > > "Ben Cole" wrote:
> > >
> > > > Hi All,
> > > >
> > > > Has anyone used the "Jump to Report" to pull up any one report from a
> > > > selection of 7 other sub-reports.
> > > > I am trying to pull up a specific detail report from 7 sub-reports using an
> > > > individual pin # and the "report type" from the main report.
> > > >
> > > > These sub-report types are grouped from type 1 thru 7. I have used the the
> > > > "IIF" statement and the "CASE" statement within the (Fx in the Advanced Text