Wrox Programmer Forums
|
BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2008 Reporting Services by Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee; ISBN: 9780470242018
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8 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
 
Old August 30th, 2009, 04:52 PM
Authorized User
 
Join Date: Aug 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSRS Sub Reporting.

I have put the Sub Report Control and set the report name which i want to show in the control, but when i m trying to setup the parameter to link master report with sub report but NAME combo is empty no one link field i could see, what I am doing wrong please do tell me.
 
Old August 30th, 2009, 05:19 PM
Wrox Author
 
Join Date: May 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What verison of Reporting Services are you using and what design tool (i.e. Report Builder 2.0 or BIDS?) Report Builde will not show you a list of reports. BIDS or Visual Studio will show a list of all reports in the same project. Does the subreport render if you just type the name of the report?
__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access
 
Old August 31st, 2009, 11:25 AM
Authorized User
 
Join Date: Aug 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sub Report

Thanks Mr. Paul, I am using Sql server 2008 reporting services and using BIDS to develop the report, actually i can see report list in the report combo i have set the report also but when i m trying to set the parameter to call up the detail report in the Advance>Parameter>Name Combo is empty whereas ValueCombo which is next to it is showing all Master report fields.

Last edited by RiazFarooqui; August 31st, 2009 at 02:02 PM.. Reason: Some Mistake
 
Old September 1st, 2009, 02:09 AM
Authorized User
 
Join Date: Aug 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation Links And Drill Through Report.

Same kind of problem I am facing in linking or drill through the report. I have select Goto Report, Selected the rptCustomer from the Report Selection Combo, when i m trying to setup the Parameter again NAME combo is not showing any field to be linked with the current report Value Combo which is next to Name Combo is showing all the fields of current report. Then I Typed CustomerID in Name box and select CustomerID from Value box but still error is appearing CustomerID is found in the report.
 
Old September 1st, 2009, 03:13 AM
Authorized User
 
Join Date: Aug 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up Link/Drill Trough And Sub Report Calling.

I am sorry Paul, i did not follow your book instruction by instruction, I missed that instruction where you mention creating of Parameter in calling report and then link it with master report, anyway I download the code from this forum and check each step, i made same what you have done in your example and it is working now.

Thanks & Regards.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SSRS: Custom reports naveenjv Reporting Services 1 October 12th, 2007 02:17 AM
ASP 3.0 and SSRS? donm Reporting Services 0 September 26th, 2007 07:03 PM
Regarding SSRS Frame Work mike.chary Reporting Services 0 August 17th, 2007 09:35 AM
SSRS Custom Report iSheahan BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 February 8th, 2007 12:52 PM
Print problem in SSRS hthakkar BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 March 14th, 2006 09:20 AM





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