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 > april 2006 > threads for monday april 10

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

report subscription unable to due file write operation - even when run under local administrator ID
Posted by astro at 4/10/2006 10:20:06 PM
I'm running some VB code to fire off a report subscription that generates a pdf file. Even when run under local admin I get a "AccessDenied" exception. How can this be? I setup the credentials for the report as follows: rs.Credentials = New NetworkCredential("administrator", "mypasswo...more >>


q: formating number
Posted by JIM.H. at 4/10/2006 2:51:01 PM
How can you format number in 1,234 format without decimals in detail section of a report...more >>

Tables with 0 Detail Rows Do not Export
Posted by JStandard at 4/10/2006 2:42:02 PM
Greetings, I have a Report with a Table Object in it that is tied to a particular dataset ( a query). I have a date parameter for the query, so the user can view the dataset over different periods. If a user runs the report and the query returns no rows, the report will simply show a th...more >>

IE 7.0.5335.5 Beta 2 and SSRS 2000
Posted by TTU at 4/10/2006 12:57:02 PM
Hi, I'm trying to track and issue with IE 7 and reporting services. First off, the report export to Excel works fine using IE 6 In IE 7 when I initially generate the report from a link in our website, the report comes up correctly, but when I attempt to export that report to xls, PDF...more >>

Hiding Parameters
Posted by David at 4/10/2006 12:17:02 PM
I want to hide 2 of the 5 parameters in my report. I figured out how to do this by clearing out the Prompt in the Report Parameters and by setting my default value. When I view my report via Report Manager, the parameters are hiden like expected. When I try to override the parameter at run ...more >>

Sorting problems
Posted by Justin30519 at 4/10/2006 12:08:02 PM
Hello. I am using DevStudio 2003 to develop a report in Reporting Services 2000. I am having a hard time getting sorting to work. When I move my mouse over a column name, it becomes a hand to indicate that it is a link. When I click on it, there are two problems: 1. It opens a new report in...more >>

Is there a way to subtotal or total data from subreports?
Posted by Kyle Jedrusiak at 4/10/2006 11:59:59 AM
Kyle Jedrusiak ...more >>

Finding credientials to connect to RS database
Posted by Scott M at 4/10/2006 11:50:43 AM
First of all sorry that the message is so skatty. I have a lot on my plate right now :) When I installed our instance of Reporting Services on our report box I cannot remember if I rsactivate-ed and rsconfig-ed the installation with a windows user or a DB user. I need to know b/c we rece...more >>



Request Length Exceeded
Posted by Mark Lauser at 4/10/2006 10:43:02 AM
I am working in Visual Studio 2005. I have a Report Model project with a data source, a data source view which contains all of the tables in my database (SQL Server 2005), and a Report Model that contains the items that I want the users to be able to work with. When I deploy the project, I...more >>

Machine Rebuild - restored ReportServer database
Posted by epperlys NO[at]SPAM gmail.com at 4/10/2006 10:17:40 AM
I recently had to rebuild my local machine. As such, I backed-up all of the relavent local databases that I needed (including the RS dbs). After the rebuild, I have attempted to connect my new instance of RS to a restored version of the ReportServer database. The instance initialized after I g...more >>

Parameter in Order By?
Posted by David at 4/10/2006 9:22:02 AM
How do you pass a parameter from Reporting Services to SQL query (Dataset) for ORDER BY clause?...more >>

Xbar Chart
Posted by John Wright at 4/10/2006 8:55:14 AM
Is is possible to create an X-Bar chart with the standard tools for reporting services? If not, does someone know of a reporting package for Reporting Services that does have X-bar chart abilities. Thanks. John ...more >>

Initial Login ignores security settings
Posted by Stan at 4/10/2006 8:44:02 AM
Hi all, have a weird one. I'm using Reporting Services 2000 and we're on Active Directory. I have two folders in my reports default page, “Folder 1" and "Folder 2". Both of these contain reports. I add a new role only to Browse and view Reports on "Folder 1". The first time the user ...more >>

ReportViewer (.NET 1.1) can't pass in the parameter...sometimes!
Posted by Roy Assaly at 4/10/2006 8:42:57 AM
Here's my problem: I have 4 web sites in 4 environments. Let's call them A, B, C, and D. Reporting Server is installed on A, and on another server, let us called it Z. There are 4 website, also installed on A, B, C, and D. When I run the website on my localhost machine, all my paramters ...more >>

Can we build Web UIs with SSRS?
Posted by Water Cooler v2 at 4/10/2006 8:33:14 AM
If all one needs is a bunch of reports, then, instead of going the whole hog writing a UI in a bespoke ASP.NET application, can one take the sole refuge of SQL Server 2005 Reporting Services to do a neat UI along with the reports? As in, one of the parameters for a report may be a period range...more >>

Error Accessing Server Report from VS2005
Posted by Ross at 4/10/2006 8:22:55 AM
I've tried 2,505,767 things to get this to work and still can't. I imagine there are others having a similar issue. Get the following unhandled IOE from Visual Studio using a ReportViewer control on a Server Report: Client found response content type of '', but expected 'text/xml', The req...more >>

Formatting a textbox
Posted by E at 4/10/2006 8:14:16 AM
I need to format a phone number parameter the user enters. Currently when I print the parameter entered it displays like this ##########. I want to format it to look like ###-###-####. Does anyone have any ideas for making it look like that? ...more >>

reduce the table height when NORows in table having a footer control
Posted by Rajesh.jain25 NO[at]SPAM gmail.com at 4/10/2006 8:00:53 AM
hi, i am using two header ,three grouping level and in a table and there is a one Report Footer in report. when there is no data present then the report hide all groups and Detail rows but the Report Footer still remains at same position. i want that the Footer should also aligned to top when t...more >>

load balanced scale out deployment issues
Posted by HC at 4/10/2006 7:06:03 AM
Hello, I have a scale out deployment of Reporting Services consisting of 2 Report Servers in a load balanced cluster using an F5 BigIP setup in RoundRobin mode, and the report catalog db sits on on a separate sql server. We use a vIP with a DNS name that hits the F5. The F5, in turn, is s...more >>

Problem with using report parameters in SQL query function, SSRS 2
Posted by Jouni at 4/10/2006 6:06:01 AM
Using Visual Studio to build reports for Reporting Services 2000: is it allowed to pass a report parameter to a FUNCTION in dataset defintion. Like: select function(@variable) from table where .. I get "syntax error or access violation" when trying. Regards, Jouni...more >>

Problem connecting to ReportingServices (SQL2005)
Posted by Nicolas Nickisch at 4/10/2006 12:00:00 AM
Hi NG, the installation of SQL2005 went o.k. Whenever I try to connect to the ReportingServices module using Management Studio, I get the following error message (the original messages is in german): Der Server hat eine Protokollverletzung ausgeführt.. Section=ResponseHeader Detail=Au...more >>


DevelopmentNow Blog