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 > october 2005 > threads for monday october 31

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

Blank Pages following report
Posted by Rick via SQLMonster.com at 10/31/2005 10:17:39 PM
I have a report that uses 7 subreports. Some reports show, some don't depending on the data received from the Shared Datasource. My initial report appears fine in the viewer, however I have a single page following the last page with data containing only the header. When I create a pdf, I have...more >>


Reporting Services Database not supported by my instance of sql se
Posted by Rich at 10/31/2005 10:14:01 PM
Hello, I downloaded the trial version of Sql Server Reporting Services from http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en But when I try to install the service I get the error message that the instance of Sql Server that I am...more >>

Install RS for multiple websites on single computer
Posted by Dilip Kumar at 10/31/2005 6:38:09 PM
My understanding is that RS installs ONLY on the default website. I'm hosting four websites on a single IIS computer. I want to use Reporting Services separately on each of the websites. That is, each will have its own database and its own set of reports. Is this possible? How? Thanks. Dil...more >>

Make RS the default website in RS 2005
Posted by Bruce L-C [MVP] at 10/31/2005 2:15:44 PM
When installing RS 2000 I did not have to do anything to have RS be the default website for the server. For instance, I could put in http://myserver and it would re-direct to http://myserver/Reports/Pages/Folder.aspx I have gone into IIS Manager attempting to set the default appropriately but...more >>

RS 2005 Prompts for User
Posted by Bruce L-C [MVP] at 10/31/2005 2:12:11 PM
I did a default new install of RS 2005. I am not using SSL. The server is Windows 2003 with SP1. I have not done anything with roles. I am connecting to reports from my computer. My domain/user is part of the administrators account on the server. The server is not a domain controller. Default ...more >>

Avoid User Login
Posted by Wayne Wengert at 10/31/2005 1:33:21 PM
I have an ASP.NET application that includes a Report Viewer form. The user clicks on a radio button list item to sekect the report to be viewed. The system requires the user to enter a userid and password to view the report. Is there a way to simply have the report display? I do not want user...more >>

Size Chart Dynamically in RS2005
Posted by Jason L Lind at 10/31/2005 12:12:02 PM
Hi, I am trying to size a chart dynamically with respect to the number of rows in the data set it is rendering from (it's a bar chart) so that the graphic will render appropriatley. Is there any way to do this? Thank you, Jason Lind...more >>

Default Parameter Values
Posted by Vinny Vinn at 10/31/2005 12:03:01 PM
How can i have the user run a report in which the user may or may not select a value for the parameter?I dont want to set a default value for the parameter because that would limit the results of the query to whatever value you set as the default. I tried Robert Bruckner of [MSFT] suggestio...more >>



Set PDF security options on export from SRS?
Posted by Tom Garrity at 10/31/2005 11:51:43 AM
Is it possible to set permissions on a PDF export from SRS to prevent changes to the document? I'm looking for functionality like within Acrobat's menu: Document -> Security -> Restrict Opening and Editing...more >>

Drill down problem, report jumps to top of table!
Posted by l.holmes at 10/31/2005 11:37:40 AM
Hi I have a report with a table which has two groups. Each group is collapsed by default when the report loads. When I click on the first group expand icon (+) the group expands but also the report jumps up the screen so that the top of my first data row in my table is alligned to the top o...more >>

Problem in RTM Version
Posted by Tom at 10/31/2005 8:29:05 AM
After installing the RTM version of SQL 2005, I have noticed a problem. I cannot add an SSIS datareader as a datasource type. In fact, SSIS does not appear in the drop-down list. I uncommented the SSIS data reader extension in the rsreportserver.config file, but it still will not allow me to s...more >>

Inconsistent Subscription Success
Posted by richard.warner NO[at]SPAM zurich.com at 10/31/2005 7:57:05 AM
Hi, I've got a production SQL Reporting Services installation and have created some file share subscriptions for one of the reports. Sometimes the subscriptions work and sometimes they don't. My customer has now had enough and wants to have them working all of the time (unsurprisingly!). ...more >>

RS2005 - Response Time
Posted by Terry at 10/31/2005 7:01:06 AM
When running a report in VS, the report run fast but when running the same report via the browser (<servername>\reportserver), the report runs slow. How can I increase the response time in running the report via the browser? Thank you....more >>

Group by expiration date
Posted by Jeff Metcalf at 10/31/2005 6:49:08 AM
Is there a way to get this down to one select statement and group it as such in Reporting services? select custnmbr,contnbr,enddate,Cast(total as Money) from svc00600 where enddate >=getdate() and enddate <=getdate()+30 order by enddate asc select custnmbr,contnbr,enddate,Cast(total as Mon...more >>

Installing RS 2005 support for Visual Studio 2003
Posted by Ryan at 10/31/2005 4:23:21 AM
Hi All, Does anyone know if it is possible to author RS 2005 reports using Visual Studio 2003? I ask because I installed both SQL 2005 and Visual Studio 2005 recently but support for designing or compiling reports in VS 2003 has been removed by the installation. My project in VS 2003 now fa...more >>


DevelopmentNow Blog