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 2007 > threads for thursday may 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

Matrix or Table?
Posted by Just Another Reporter at 5/31/2007 6:59:45 PM
I am trying to create a report that should have fixed columns. I started out creating a matrix, but was having loads of trouble keeping the columns I wanted. Here is what it should look like: Total <0 days 1 day 2 days 3 days 4 days 5-10 days 11-15 days 16-30 days ...more >>

Parameter with @ sign
Posted by Ed at 5/31/2007 6:18:00 PM
Hi, I would like to know under Data Set --> Parameter, do I have to add a @ sign right before the name of parameter? I know I have to use it in SQL like select * from customers where customerID = @CustomerID. Can I just use CustomerID in Parameter box or I have to use @CustomerID? which ...more >>

Turn off paging?
Posted by Eric at 5/31/2007 3:01:11 PM
Is it possible to turn off the paging feature at the report level? I have some reports that a 3-4 pages long and the users just want to scroll through it all. They are just viewing them through the ReportServer virtual directory... thanks! ...more >>

Change a subreports report source
Posted by Tim Kelley at 5/31/2007 12:47:00 PM
Is there a way to change a subreports report source on the fly? I would like to change the report based on a parameter that is passed to the main report. Thanks, Tim ...more >>

Impersonation not working correctly in custom code module
Posted by Jason at 5/31/2007 10:55:01 AM
I have a Reporting Server setup in a lab and one setup on my development machine. Both use to run Reporting Services 2000. We recently upgraded to Reporting Services 2005. I am having a problem on both machines impersonating the logged-in user in my custom assembly that is called from the repo...more >>

Request failed HTTP status 504 (Gateway Time-Out)
Posted by Laurahn at 5/31/2007 10:35:20 AM
When i run my report from Win App with a Report Viewer control ("Microsoft.Reporting.WinForms.ReportViewer"), over a XP machine, i got this error: "The request failed with HTTP status 504: Gateway Time-Out" Thanks, =) ...more >>

SSRS returned data too large
Posted by Rob at 5/31/2007 10:25:01 AM
I had a quick question regarding SSRS 2005 and the amount of data my reports generate. Is there any way to limit the report to only pull back the first page (or first 5 pages) of data to a report? Some of these reports bring back 50+ pages worth of data and I am getting complaints that ...more >>

Cannot install BI Developement Studio
Posted by Mark at 5/31/2007 8:33:01 AM
I am able to install SSRS, and it works from my local machine. I also installed SQL Server 2005 locally so the ReportServer and ReportServerTempDB can be created locally on my computer. However, BI Development Studio will not install. I get an message about APPCOMPAT. I tried another instal...more >>



server mgmt studio can't connect to ReportServer
Posted by Bill at 5/31/2007 8:14:02 AM
Help. Recently, studio has not been able to connect to reporting services (connects to db engine, analysis, etc ok). Only thing happening around that time is failed VS2005 update <low c: space, downloaded to other drive & ran from there OK>. Reporting services is still running, cranking out...more >>

Cannot Install Reporting Services Components!!
Posted by Ayman at 5/31/2007 7:24:29 AM
I have set up a Virtual Machine that runs Windows Server 2003 x64. When I come to install SQL Server Express edition the Reporting Services components don't even show up as options for installation. Oh, I'm installing Express edition with advanced services by the way and I have the 3.0 .NET serv...more >>

Referencing a total for a group inside that group?
Posted by Doug at 5/31/2007 7:18:00 AM
Is there any way to do this?? I am trying to display percentages of the total along with the number of items. What I want to do would look something like this. Group header: Detail X X/Sum of all X's Group footer Sum of all X's I can't seem to find a way to refer to the item in...more >>

Column width
Posted by Hasan Dalwai at 5/31/2007 1:31:00 AM
i am using reporting services 2000 & my backend is sql 2000. In one of my reports, i have a parameter which needs to take value more than 1400 characters but in reporting services report view i can only give 1200 characters. Kindly let me know how do i resolve this issue. ...more >>


DevelopmentNow Blog