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
Solved

SSRS Selection formula

Posted on 2009-04-15
5
892 Views
Last Modified: 2012-05-06
Crystal Reports has a selection formula what would be the equivalent in SQL Report Servicies?
0
Comment
Question by:Hollie18502
5 Comments
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
ID: 24174215
Hollie,
I believe the closest thing in Reporting Services to the Selection Formula in Crystal is the Filters on the properties sheet for tables, grids, etc.  You will have to work with the expressions in there to come up with a formula to limit the records displayed.
SSRS-Table-Properties.png
0
 

Author Closing Comment

by:Hollie18502
ID: 31570446
I actually figured it out over the week end.  and you're right this is the closest thing to using a selection formula.   It worked perfectly.   Thanks
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Report Builder 3.0 3 45
SSRS Dynamic Column Names - Last 8 Weeks 3 42
View SQL 2005 Job package 16 70
Why use this lambda? 12 35
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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