Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 23rd, 2006, 12:08 PM
Authorized User
Join Date: Mar 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Parameters / Filters

I've built a report (not using the wizard). I've got everything the way I want it. But, I've got 2 things I don't know how to do:

1) How do I apply a parameter as a filter to every field? When I use the wizard I have the option of selecting an object that has a filter property for the entire report. I haven't found the equivalent in the report builder.

2) I want this report to be accessed from another report. When the user clicks on a field in ReportA I want this report (ReportB) to load up. I want the parameter/filter for ReportB to be the ID of the object the user clicked on ReportA. What's the best way to do this?

All suggestions/answers are greatly appreciated! Thanks in advance!

Similar Threads
Thread Thread Starter Forum Replies Last Post
Parameters / Filters in a datatable AussieRay VB Databases Basics 3 February 22nd, 2007 10:26 AM
MDX filters an Parameters GabrielP BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 2 May 16th, 2006 08:31 AM
About filters alf.guzman Servlets 0 December 16th, 2004 06:07 PM
logins/filters desireemm SQL Language 1 August 17th, 2004 05:53 PM
Filters filters and again .... GregoryHu Access VBA 4 July 28th, 2004 10:59 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.