?
Solved

SSRS Selection formula

Posted on 2009-04-15
5
Medium Priority
?
907 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
[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
5 Comments
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 2000 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
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…
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…

770 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