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 > september 2006 > threads for wednesday september 20

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

Default Value for Paramters
Posted by SQLKen at 9/20/2006 4:51:16 PM
HI, I set the default value for the report, but it doesn't show at runtime. what is the problem? any work around trick? Thanks Ken ...more >>

AM PM format
Posted by Mark Goldin at 9/20/2006 4:25:06 PM
How can I show time portion of a date in "hh:mm:ss" AM?PM format? Thanks ...more >>

401 Unauthorized When Access Application Remotely
Posted by Cyke at 9/20/2006 1:38:03 PM
Hello, I have developed a web application which has a ReportViewer control embedded in the page and connects to a remote Reporting Services server. Everything works fine locally in my development environment. However, when I deploy to the test server, the ReportViewer control throws a Report...more >>

Re-installed RS2000 and "Setup could not initialize the report server"
Posted by VancouverGuy at 9/20/2006 11:14:04 AM
Hi folks, I'm trying to reinstall Reporting Services 2000 on a Win2k3 box with 4 procs. The install completes successfully, but at the last screen I recieve a message saying "Setup could not initialize the report server" I have checked the following kb articles, but I still see the same...more >>

In a subscription, if the email fails, will I get notified?
Posted by DragonVic at 9/20/2006 11:09:02 AM
I have subscriotions that fail because someoen's email is no longer valid, where is this information stored so I can fix the problem? I have a large list and it is hard to do manually....more >>

Need help with editing body columns and contents
Posted by David at 9/20/2006 10:54:02 AM
Hello, I am new to MS RS and need help with clarification about body columns. How can I accomplish a one-page report with 2 columns in the body section? How do I edit the contents in the columns when I am in VS design mode? I have a report that was previously built with only one column in th...more >>

problem with dates in parameter
Posted by Brian L at 9/20/2006 9:16:01 AM
Report query uses @startDate and @endDate for current date and tomorrow. For currentdate I use =Today and that seems ok but if the report is run at 3PM the time shows 3PM rather than 00:00:00. EndDate is more problematic. I've tried many different suggestions from within this forum for obtai...more >>

Use RS2005 to run reports from a sql2000 db
Posted by Damon Johnson at 9/20/2006 9:15:01 AM
We have sql2000 EE installed on a dedicated WS2003 machine. RS2000 is not installed. I have just installed sql2005 SE and RS2005 on a seperate workstation running WS2003. Can I use RS2005 on the workstation to run reports from the sql2000 database on the dedicated server? I tried sear...more >>



A text file data source
Posted by Kerrie at 9/20/2006 8:53:47 AM
Hi all, I have to write a report that uses a .txt file as a data-source and I am not sure how to do that. Anyone know where I can find out how to set this up? ODBC Connection? The .txt file format is like this....(top 5 rows) 20040881 2004/12/22 01:30:12 NONIMPACT 20040883 2004/12/22 15:02...more >>

Passing UnNamed Parameters
Posted by BillB at 9/20/2006 8:07:02 AM
I have a Un-Named Parameter. User specifies any number from 1-24. for this example 12 (meaning I want to find the Fiscal_Year,Fiscal_Period 12 months back from Today) DataSetAA Source is (Reporting Services) Select Fiscal_Year,Fiscal_Period, Start_Date from Table A1 I'm looking for...more >>

HTTP status 400: Bad Request
Posted by cathedr NO[at]SPAM wa.state.gov at 9/20/2006 7:22:02 AM
I have SQL Server 2005 setup on an existing server. I just added SQL Reporting Services to a Windows 2003 server. The initial install of Reporting Services went flawlessly. After installation, I added the Service Pack to Reporting Services so it would match the SQL Server I want to point ...more >>


DevelopmentNow Blog