An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
COURSE of the MONTH
11 days, 22 hours 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,
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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss. This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in. And this behavior is only see…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month11 days, 22 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.