Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Course Of The Month
6 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Expression for Go to report action property for group values
Posted on 2011-02-17
I have dataset group in SSRS called Sales_Type and values could be "Online", "Phone" or "Walk in" . I have an action property go to report on this group. I need an expression on the action property that will open different reports for values; Online", "Phone" or "Walk in" . Who can help me the the expression?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
If the Action is on the cell with the value in it then you can use Me.Value in the expression to test for or use that cells value;
For instance;
=Switch(Me.Value = "Online","OnlineReport", Me.Value = "Phone", "PhoneReport", Me.Value = "Walk in", "WalkinReport")
If not you can access the field directly, Fields!theField.Value.
If you do that from a group as your title suggests it should still work.
Cheers
Chris
For instance;
=Switch(Me.Value = "Online","OnlineReport", Me.Value = "Phone", "PhoneReport", Me.Value = "Walk in", "WalkinReport")
If not you can access the field directly, Fields!theField.Value.
If you do that from a group as your title suggests it should still work.
Cheers
Chris
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Hi All,
I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Hi,
I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month6 days, left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.