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 > january 2006 > threads for friday january 6

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

Can RS 2005 uses all the new enhancements running on SQL server 2000 SP3a?
Posted by steve kwon at 1/6/2006 4:11:54 PM
Hello, Can RS 2005 uses all the new enhancements running on SQL server 2000 SP3a? Steve ...more >>


RS 2005 requirements
Posted by steve kwon at 1/6/2006 3:32:11 PM
Hello, Does Reporting Service 2005 require a SQL Server 2005 or can Reporting Service 2005 run using SQL Server 2000 at SP??? ? Steve ...more >>

Toggle Column Visibility in Table
Posted by LureManGary at 1/6/2006 2:33:02 PM
I have a table report with two levels of Groupings. Dept-Employees-Detail... The table has 8 columns total, with drilldown enabled. When you first open the table you see the first and last colmn of data (department and hours worked) when you toggle the department field you see the employee...more >>

Data Sources
Posted by Alex at 1/6/2006 1:13:02 PM
Is there anyway to use a Class File (VB.Net or C# class that generates a DataSet) as the data source for a SQL Server 2005 Reporting Services report? If there is, where are some examples or how-to's? The only obvious way I see to generate a Data Source for a SQL report is a sproc or dynami...more >>

RS 2005
Posted by pbb at 1/6/2006 12:33:01 PM
I need to be able to pass a dataset to a report and then have a Print Dialog open on the client-side for the user to print the report. Is this possible with RS 2005? I saw that you could pass a dataset to a report in local mode, but I haven't seen how to pull up the Print Dialog and print th...more >>

Can't use VS 2003 for reports now that VS 2005 and SQL 2005 are installed?
Posted by Lee at 1/6/2006 12:18:44 PM
I've been using Visual Studio 2003 successfully for several months to develop a web-based reporting solution. I've also had SQL Server 2000 installed, including the evaluation version of Reporting Services. I just recently installed Visual Studio 2005 (but left Visual Studio 2003 installed as ...more >>

Setting linked reports to print landscape
Posted by Carmen at 1/6/2006 12:07:04 PM
I have linked reports that are printing portrait even though the "master" report was set to landscape. I understand this is a problem and found another post suggesting to use the following code: Dim rs As New ReportingService.ReportingService rs.Credentials = System.Net.CredentialCache.Def...more >>

Getting data from other source
Posted by Jack at 1/6/2006 12:02:25 PM
I need to make a report which is getting data from Microsoft CRM and Informix. The way I intend to do it is making a view in the CRM database with data from CRM and a linked Informix server. Now I have a little problem getting data from informix, or rather the right data. In the sql q...more >>



Dynamic Columns Report
Posted by Vishal at 1/6/2006 11:51:29 AM
Hi, I am trying to design a report with has data for the past 12 months. i.e. user parameters are Month = 4 & Year = 2005, the report should have columns from 05/2004 to 04/2005 i.e. past 12 months. I have managed to get the data using a stored proc, how can get the column headings to be...more >>

RS 2005 Web Parts
Posted by Jim at 1/6/2006 11:49:21 AM
I am using the SQL 2005 Reporting Services web parts within a WSS site. SQLRS uses IIS virtual smtp server for delivery which works fine. Using the report explorer web part, when I setup a subscription, the value in the To: field defaults to the uneditable <username> rather than a full mail ad...more >>

Installing Report Designer Alone on 2000
Posted by Keith at 1/6/2006 11:23:13 AM
Is it possible to install the report designer on a development system that is connected to a server with Report Services for SQL 2000? ...more >>

RS/MDX - Column Parameter / Field name in dataset problem
Posted by JoelBarish at 1/6/2006 11:01:11 AM
In creating a dataset with MDX, the field names (column captions) for my dataset always resolve to the actual member name in the AS cube. For example, if i use the following query as the datasource With Set [GenericMeasureName] as '{[Measures].[Quantity]}' SELECT {[GenericMeasureName]} ON COLU...more >>

Subreports running in main reports detail rows
Posted by dt1820 NO[at]SPAM gmail.com at 1/6/2006 10:18:56 AM
Is it a know bug/error that a subreport cannot run inside a tables detail rows? If so has a work-around been found for this. I am getting the following error to occur, but only when i place the subreport inside the main tables detail row: An error occured during local report processing. An int...more >>

DaysOfWeek CheckBoxList
Posted by Moistly at 1/6/2006 8:27:59 AM
I have a checkboxlist of days of the week that I wish to be checked if they are in the current schedule. Is there a neater way of accomplishing this than the code I have at present? Dim recurrence As New WeeklyRecurrence recurrence = CType(schedule.Definition.Item, WeeklyRec...more >>

Internal Reporting Services Error
Posted by Jeff at 1/6/2006 7:31:34 AM
The following is the error I've been receiving from my RS Server when attempting to pull reports via HTML call from a VB.net application on the same server. Everything worked fine until the start of December...any ideas of where to start to fix this?? I've tried a great many things. <Head...more >>

Page Numbers on Subreports?
Posted by CraigZello at 1/6/2006 5:51:02 AM
How can you get the footer section (Page Numbers) of subreports to print when part of a main report? Im using RS 2000. Thanks, Craig...more >>

Installation: SQL Server 2005 surface area configuration, error WI
Posted by pbrel at 1/6/2006 1:30:03 AM
Hello, I'm trying to install RS 2005 on my server. First the installation is ok, to validate it I checked (as explained in the installation guide) with "SQL Server 2005 surface area configuration", but I have always an error when I want to validate the "windows intergated security". The err...more >>


DevelopmentNow Blog