Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > august 2006 > threads for thursday august 10

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Reporting Services - Please Advice
Posted by User at 8/10/2006 7:25:50 PM
Hello, I need some guidance on this possible misundestanding. I believe that Reporting Services is mainly used for those kind of reports where you have consolidated data and then you may drill-down to get details about it, but for operational reports where you have letter style reports with...more >>


(Select All) value
Posted by Rob at 8/10/2006 2:40:02 PM
I would like to display "ALL" in a text box if the (Select All) option is selected as a parameter. I can display 1, 2, 5 to every single selected value in the textbox using the JOIN function. But if the (Select All) parameter is selected, I would rather display "All" in my textbox instead ...more >>

How do I set a set a report parameter value using the webform RVC?
Posted by Chris G. at 8/10/2006 2:22:01 PM
SSRS 2005 We have an ASP.NET application which permits the user to switch between different databases depending on their permissions. As soon as the user chooses a new database, the application shows data from the new database. I am using the Report Viewer Control to allow the users to run...more >>

How to keep the report from rendering when the Rpt Viewer 1st Appe
Posted by Chris G. at 8/10/2006 2:11:02 PM
SSRS 2005. I am using the webform Report Viewer Control to render remote reports. When the page containing the RVC renders so does the report. How to I keep the report from rendering until the user runs it? I know I could accomplish this by making a required parameter and not providing...more >>

Cannot Change Title of Report Explorer Web Part
Posted by mrobert at 8/10/2006 1:04:05 PM
I am using the SQL Server Reporting Services - Report Explorer Web Part in SharePoint Portal Server 2003 SP2. By default, the title is set to "Report Explorer". When I modify the web part, I can change the title. When I click Apply and OK the change appears on the web part but when I exit...more >>

Print Multiple Documents with VS2005 Local Report
Posted by Orlando at 8/10/2006 12:45:02 PM
Hello all. I have a document (that could be for example an invoice) that was done with VS2005 Local Report. This document is exported to PDF in the application (with response.OutputStream.Write). Now I want to be able to print multiple documents (for example invoices), by generating a P...more >>

cascading parameters
Posted by ATB4U at 8/10/2006 12:29:01 PM
I am a little confused on these cascading parameters. Can I use them with stored procs and how? I have one main stored proc and many smaller ones for the parameters. I seem to be missing where to link them? ...more >>

Drillthrough Reports not working in Webforms Report Viewer Control
Posted by Chris G. at 8/10/2006 12:21:02 PM
I am using SSRS 2005. I created a report (Report A) which links to another report (Report B). The drillthrough works fine both in Visual Studio and via Report Manager. I have an ASP.NET application which uses the Report Viewer Control to display Report A. When I click the links in Report A...more >>



(RS 2000) Row Count in Header?
Posted by Vagabond Software at 8/10/2006 12:11:46 PM
I am using Reporting Services 2000 and need to know if there is a way to list the number of rows returned in the Header or Footer? Any help is greatly appreciated. - Carl ...more >>

Counting with a filter
Posted by Dan D. at 8/10/2006 12:08:02 PM
Using SS2000, VS2003, RS2000. I want to list all of the individual orders and how they were shipped. Then I want to count the total number of orders and get a count for each method of shipment. So, the data might look like this: Order # Shipped 1 UPS 2 Fed...more >>

Table Question multiple datasets
Posted by Marc Bumgarner at 8/10/2006 11:26:38 AM
I have a table that has 8 columns (4 columns for previous years Data and 4 columns with ytd data from the current year) the table is grouped by Month using dataset 1 (previous years data). The question is how do i get the current years data into the table??? Example of the desired output ...more >>

VS 2005 Crashes When Deploying Report
Posted by bjkaledas at 8/10/2006 10:40:02 AM
Hi guys. About three or four times a day VS 2005 will crash when I am deploying a report. Has anybody experienced this? Any suggestions to fix this? Thanks! BJ...more >>

parameter length limitation
Posted by Robert at 8/10/2006 8:11:01 AM
Hi, I am using sql reporting services 2000, i am trying to pass a parameter with the length of 3000 character and since the URL limitation is 2040 i used the post method as follow <FORM name=Form1 method="post" target="_self" > <input name="rc:LinkTarget" value="_self" type="hidden"...more >>

Custom Data Extension Parameters
Posted by Nathan at 8/10/2006 7:37:02 AM
I am currently writing a Custom Data Extension using the RS 2000 Microsoft.ReportingServices.Interfaces dll. I’ve found quite a few examples online and have almost gotten it to work the way I would like it to. I have implemented the IDbCommandAnalysis.GetParameters interface and when I cre...more >>

allow null on a multi value parameter
Posted by Bjorn at 8/10/2006 12:00:00 AM
Hi, I don't seem to be able to set "allow null" on a multi value parameter. I have this parameter with default values from a stored procedure, I want the report to be able to generate without having something selected from the multi value parameter. How is this possible? Bjorn. ...more >>

Urgent: Default parameter choice trouble
Posted by michael v at 8/10/2006 12:00:00 AM
Use of default parameter value is unstable in report manager ? When looking at report in visual studio it choose the one I tell it too - but in report manager it doesnt ? But this doesnt apply to all parameteres - some are working but there aint any differnece in the settings ? Any ideas...more >>


DevelopmentNow Blog