Solved

Expression for Go to report action property for group values

Posted on 2011-02-17
1
449 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:Projack
[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
 
LVL 18

Accepted Solution

by:
chrismc earned 500 total points
ID: 34923734
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
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question