Friday, March 30, 2012

Immediate Help Needed Please!

Hi All,
This is a repost from last Friday
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
Box Properties) but neither of the statements worked for me. Any help?
Below is my case Statement...
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') ENDWhat is the jump to producing now? Is it jumping to any report? Are you
getting an error message?
"Ben Cole" wrote:
> Hi All,
> This is a repost from last Friday
> 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
> Box Properties) but neither of the statements worked for me. Any help?
> Below is my case Statement...
>
> 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
>|||Daw,
The error msge I'm getting is: "Report can not be compiled. Verify the
report name and that the report is in the current project."
I made sure the report names are all in the current project and are viewable.
Thx
"daw" wrote:
> What is the jump to producing now? Is it jumping to any report? Are you
> getting an error message?
> "Ben Cole" wrote:
> > Hi All,
> > This is a repost from last Friday
> >
> > 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
> > Box Properties) but neither of the statements worked for me. Any help?
> > Below is my case Statement...
> >
> >
> >
> > 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 tested it with iif and got it to work with the following format:
=iif( Fields!MyField.Value ="MyValue", "Report 1", "Report 2")
I don't think that you can use CASE in the Edit Expression window. This
example assumes that your reports are in the same project. You don't need
.rdl at the end of the names - I grabbed the report names by expanding
Constants in the Edit Expression window.
Hope that helps!
"Ben Cole" wrote:
> Hi All,
> This is a repost from last Friday
> 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
> Box Properties) but neither of the statements worked for me. Any help?
> Below is my case Statement...
>
> 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
>|||Thx daw for your help... I did try your example and still got the same error
msge.
I hope I'm not asking for too much here?
I was wondering if you can convert my CASE statement below with IIF
statement so I see what it actually looks like
thx for all your help!!
"daw" wrote:
> I tested it with iif and got it to work with the following format:
> =iif( Fields!MyField.Value ="MyValue", "Report 1", "Report 2")
> I don't think that you can use CASE in the Edit Expression window. This
> example assumes that your reports are in the same project. You don't need
> .rdl at the end of the names - I grabbed the report names by expanding
> Constants in the Edit Expression window.
> Hope that helps!
> "Ben Cole" wrote:
> > Hi All,
> > This is a repost from last Friday
> >
> > 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
> > Box Properties) but neither of the statements worked for me. Any help?
> > Below is my case Statement...
> >
> >
> >
> > 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
> >|||Try this:
=iif(Fields!ReportType.Value =1, "First Report",iif(Fields!ReportType.Value
=2, "Second Report",iif(Fields!ReportType.Value =3, "Third Report",
iif(Fields!ReportType.Value =4,"Fourth Report" ,iif(Fields!ReportType.Value
=5, "Fifth Report", iif(Fields!ReportType.Value =6,"Sixth Report","Seventh
Report"))))))
This statement assumes that if the ReportType value is not 1 through 6, that
it is 7 and will jump to the seventh report. Good luck!
"Ben Cole" wrote:
> Thx daw for your help... I did try your example and still got the same error
> msge.
> I hope I'm not asking for too much here?
> I was wondering if you can convert my CASE statement below with IIF
> statement so I see what it actually looks like
> thx for all your help!!
> "daw" wrote:
> > I tested it with iif and got it to work with the following format:
> >
> > =iif( Fields!MyField.Value ="MyValue", "Report 1", "Report 2")
> >
> > I don't think that you can use CASE in the Edit Expression window. This
> > example assumes that your reports are in the same project. You don't need
> > .rdl at the end of the names - I grabbed the report names by expanding
> > Constants in the Edit Expression window.
> >
> > Hope that helps!
> >
> > "Ben Cole" wrote:
> >
> > > Hi All,
> > > This is a repost from last Friday
> > >
> > > 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
> > > Box Properties) but neither of the statements worked for me. Any help?
> > > Below is my case Statement...
> > >
> > >
> > >
> > > 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
> > >|||A BIG Thx to you, daw!!! I finally got it to work!!
Thx again!
"daw" wrote:
> Try this:
> =iif(Fields!ReportType.Value =1, "First Report",iif(Fields!ReportType.Value
> =2, "Second Report",iif(Fields!ReportType.Value =3, "Third Report",
> iif(Fields!ReportType.Value =4,"Fourth Report" ,iif(Fields!ReportType.Value
> =5, "Fifth Report", iif(Fields!ReportType.Value =6,"Sixth Report","Seventh
> Report"))))))
> This statement assumes that if the ReportType value is not 1 through 6, that
> it is 7 and will jump to the seventh report. Good luck!
> "Ben Cole" wrote:
> > Thx daw for your help... I did try your example and still got the same error
> > msge.
> >
> > I hope I'm not asking for too much here?
> > I was wondering if you can convert my CASE statement below with IIF
> > statement so I see what it actually looks like
> > thx for all your help!!
> >
> > "daw" wrote:
> >
> > > I tested it with iif and got it to work with the following format:
> > >
> > > =iif( Fields!MyField.Value ="MyValue", "Report 1", "Report 2")
> > >
> > > I don't think that you can use CASE in the Edit Expression window. This
> > > example assumes that your reports are in the same project. You don't need
> > > .rdl at the end of the names - I grabbed the report names by expanding
> > > Constants in the Edit Expression window.
> > >
> > > Hope that helps!
> > >
> > > "Ben Cole" wrote:
> > >
> > > > Hi All,
> > > > This is a repost from last Friday
> > > >
> > > > 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
> > > > Box Properties) but neither of the statements worked for me. Any help?
> > > > Below is my case Statement...
> > > >
> > > >
> > > >
> > > > 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
> > > >

No comments:

Post a Comment