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 > may 2006 > threads for wednesday may 17

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

how to change database at runtime?
Posted by Lori at 5/17/2006 6:36:58 PM
Hello, Our customers often have 2 or more databases with the same structure. How can we pass the database as a parameter at runtime in Reporting Services 2005? Thank you, Loreaca ...more >>


Installing RS
Posted by Lisa Calla at 5/17/2006 4:33:05 PM
I'm trying to install sql server reporting services for sql server 2000 on my Win2003 server. In the system prerequisite check, I get the warning 'IIS is either not installed or not configured for a server component installation.' Well, IIS is installed (I can get my default page from http...more >>

GROUP BY on same line?
Posted by Pieter Coucke at 5/17/2006 4:16:42 PM
Hi, I want to do a group by in a Report (RS 2005), but the group by has to be on the same line. For instance: Imagine I have a table tblPerson (Name, FirtsName, Country, DateOfBirth, ....) - Simpson, Homer, USA, 12-12-1970 - Johnson, Bart, Belgium, 05-02-1978 and a tblCars (Brand, Color...more >>

Impersonation Problems on RS WS
Posted by dsabo at 5/17/2006 3:20:02 PM
Hi all, I'm running RS 2005 on a Win2003 R2 x64 english server. The regional settings are configured for spanish (venezuela). When I run Report Manager from IE, everything works ok, but when I tried to render the same report with the web service it fails, "datatype is not valid"...more >>

Using Displayname or Description
Posted by NeedToKnow at 5/17/2006 2:46:01 PM
I have a report embedded in another html document. I would like to get the report name or something to identify the report and render it in the html document. It looks like displayname is set in code when you create and render the report in reportviewer. Is there a way to set this direct...more >>

Report Execution Error
Posted by Roy at 5/17/2006 2:41:08 PM
Hi All, We have SQL Server 2005 Enterprise installed on Windows Server 2003. I created a data model from a remote server and deployed the model. When I browse to the folder and click Report Builder and create the report then click Run Report I get the following error: Report Execution Error ...more >>

Upgrading reporting service database from 2000 to 2005 error
Posted by Pete at 5/17/2006 2:17:02 PM
I am trying to upgrade my SQL 2000 reporting service database to 2005. I am following the direction outlined in SQL Server 2005 Books online, article number 143724, Migrating reporting Services. When I try to upgrade my reporting service database I receive the following error, when Upgradin...more >>

Missing Image in PDF Export copy of report
Posted by Elliot Rodriguez at 5/17/2006 1:56:59 PM
I have an ASP.NET application that passes stored procedure params and generates a dynamic report with one or more Image controls. The image paths are created with absolute references to their locations in a separate web directory, the one that the .NET app calls the report from. So the store...more >>



Can I use data drive subscription on a remote sql standard version
Posted by Joaquin at 5/17/2006 1:19:02 PM
I would like to upgrade our report server to sql 2000 enterprise edition to be able to use the DD subscriptions.. if I do do upgrade the server, will I be able to connect to a sql server on another box with the standard version and continue to use DD subscriptions on that remote server. or is...more >>

ReportItems in Page Footer
Posted by Jen Torres at 5/17/2006 12:51:02 PM
I have several text boxes in the page footer of my report, which reference various ReportItems. The values are displayed correctly when previewing the report. However, when I print the report the values are not printed. All of the other textboxes which contain static information is printin...more >>

Display SRS Rendered PDF File in IE inline
Posted by Paul Keegstra at 5/17/2006 12:40:01 PM
Hi, I have a web application (1.1 framework) that includes several SQL Server 2000 Reporting Services reports as part of the solution. I include in my application a web form that allows the user to select a report, specify any applicable parameters, and then run the report. In my "run...more >>

Oracle Support
Posted by Peter Manse at 5/17/2006 12:05:01 PM
I'm hoping someone at MS is monitoring this and can give us some hope. Another thread in this forum suggests that Reporting Services Oracle support is not all there yet. Is this true? If so, what's the plan? My specific need is to execute Oracle [stored] procedures that take parameters to ...more >>

The definition of the report 'Main Report' is invalid
Posted by Amy at 5/17/2006 11:34:02 AM
I'm trying to access a custom assembly in repot designer. I copied the dll to C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies In one report (rdlc), I'm able to access the above DLL. I have another project which has a report (rdlc) but this one cannot access the abov...more >>

how to controll user access in comercial deployment?
Posted by Stephen Lonsdale at 5/17/2006 10:19:02 AM
Hello, We have used SSAS and SSRS to develop a BI reporting suite for our data warehouse and would like to deploy this into our customer base, but at the same time protect our investment. How do we control or limit the number of users that can use our cubes and reports? We would like to...more >>

Limitation of Varchar 8000 in executing a dynamic MDX inside stored Procedure
Posted by shagarwal at 5/17/2006 9:00:53 AM
Hi, I have a Stored Procedure in SQL which build a Long MDX query .Then i connect to OLAP and execute the query .The dataset returned is used in Report. When my dynamic query exceeds the varchar (8000) limit , Error that comes : ''Unquoted string in the Query'' . This error comes ...more >>

how to JOIN data
Posted by Ray at 5/17/2006 6:34:01 AM
Hi, How is it possible to JOIN between tables from two different sql servers in a dataset in reports, (using MS reporting services Version 9.00.1399.00)? Can I use two dataSources in one dataset? servers 1 is SQL server 2005 and server 2 is SQL server 2000,sp3 is Linked server the only way...more >>


DevelopmentNow Blog