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 > march 2006 > threads for tuesday march 21

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

Create clickable URL in Field Column
Posted by Erok at 3/21/2006 11:21:35 PM
I have a column in my report that I would like to make clickable with a html A tag, I created a formula as follows: = "<a href='http://www.mywebsite.com/?queryvar=" & data.field.value & "'>" & data/feild.value & "</a>" When I render the report, I just see the text, but it isn't clickable....more >>


reporting services on windows xp
Posted by Traian Stoian at 3/21/2006 6:48:15 PM
hi all I've just installed visual studio 2005 and I can not find reporting services on my Windows XP machine. Is this expected or am I doing something wrong ? ( because on another Windows Server 2000, I saw that was installed ok ) thank you very much ...more >>

Reporting Services Web Browser Hosted by Vitural PC
Posted by xav at 3/21/2006 6:19:41 PM
Hi, can any one help I have a virtual PC running Reporting Services - Problem is that I can not see the Webbroswer on the host machine or any other machine on the network Both Vitual PC and Host are on the same domain I can veiw the Reporting Services Web Browser on the Virtual PC I have...more >>

Running Value Problem
Posted by Keith at 3/21/2006 4:10:07 PM
Hi, I used RunningValue function within a table and returned the following result. I have two questions. 1) How can I remove (not just hide but remove) the first row that contains "0"? 2) How can I set values beyond Month 3 to blank fields instead of all of these same "$87,736,926"? This i...more >>

Logon failure
Posted by Jim Abel at 3/21/2006 3:33:30 PM
To get my reports to work from the 2005 Report Manager I had to put the Execution Account into the Local Administrators Group, otherwise I got a Logon Failoure message when attempting to view the report. Is this how it's sipposed to be?...more >>

Scatter Chart issue
Posted by msdnuser at 3/21/2006 2:50:09 PM
Hi all, I have to create a report with scatter chart in reporting services 2005. I need to set the scale with min 0.5 and max 2 for both X and Y axis and the both axis should cross the other at 1. I tried checking Numeric or timescale value in X axis properties. Whatever I do always both th...more >>

Using 2005 Reporting Services to access data in custom business objects when report is hosted on server
Posted by Microsoft News Groups at 3/21/2006 2:47:21 PM
I see that it is very easy to bind a 2005 Reporting Services report to custom business objects when using the ReportViewer control and Local Processing mode. I would prefer to host these reports on a Report Server to have the benefit of scheduling, security, etc. The MSFT documentation m...more >>

NoRows Property in RS2005
Posted by Tom Bean at 3/21/2006 2:34:55 PM
Is the NoRows property of a Data Region broken in Reporting Services 2005? I have set the message to be displayed for both subreports and tables and the message is never displayed when the data set is empty. It used to work in RS2000. Thanks, Tom ...more >>



HELP! Report Manager Error: HTTP status 400: Bad Request
Posted by R Mariotti at 3/21/2006 2:22:29 PM
Hello, I have been struggling with installing SQL Server 2005 Reporting services for several days now, so I figured that I’d post my experience on this TechNet to see if anyone has any suggestions. Basically, the Server Manager always returns “The request failed with HTTP status 400: Ba...more >>

upgrade question on RS 2000, WSS and .net 2.0
Posted by dporter at 3/21/2006 12:38:20 PM
I am having trouble upgrading a machine. It has Reporting Services(RS) 2000 SP2 and Windows Sharepoint Services (WSS) SP2 running side by side. They are working just fine and have been for quite some time. The problem is I would like to have .net 2.0 installed as well. When I installed it, so...more >>

Table Headings
Posted by smithy at 3/21/2006 12:11:19 PM
I need to position headings for columns in my table report. I do not want the headings IN the table but as a column heading outside the table. When I create text labels to hold the headings they look OK in design, but when I do a preview, they are shunted across to the far left of the page. ...more >>

Default Value of <Select All>
Posted by jtstrassburg at 3/21/2006 11:58:47 AM
Does anyone know how to default the value to <Select All> in a multi-list? Can you test to see if the user has selected that? ...more >>

Displaying parameter list in report header
Posted by gdjoshua at 3/21/2006 11:31:22 AM
I'm trying to display a parameter list of items to a textbox in the header. Somehow it never evaluates anything after the first item in the array. 1st below is the expression... 2nd is the custom code. I don't know what I'm doing wrong... 1. =code.ParameterList(Parameters!ProgCatCode...more >>

Usage Report
Posted by Promod at 3/21/2006 11:13:07 AM
Does someone know where is date information added in ReportServer database, when a new user is added from report manager. I would like to create a usage report which reports, monthly number of users added to the reporting application. Thanks, Promod. ...more >>

<Select All>
Posted by jtstrassburg NO[at]SPAM gmail.com at 3/21/2006 11:08:18 AM
Is there a way to default a multi-value parameter to "Select All"? Also, can you test to see if the user clicked <Select All>? I want to display the parameter on the report as the user selecting all. ...more >>

logon failure error in Reporting Services (rskeymgmt error)
Posted by Mujir at 3/21/2006 10:43:21 AM
Hi, I have Reporting Services 2000 installed and I have a remote report server database. The Report Server is configured to use a domain user account to connect to the report server database. The password of the domain user account is changed a few days ago and I updated the...more >>

Auditing Reports
Posted by Vipul Shah at 3/21/2006 10:41:33 AM
We have a many reports in many folders. We are now at the point that we need some kind of tool to audit all these reports for following: Security connectionStrings Data Sources ReportLocations I saw in ReportServer database there are all kind of tables which has all of these information,...more >>

Query in Textbox
Posted by Scott Lindsey at 3/21/2006 10:41:30 AM
I want to retrieve a description from a reference table based on a value in a current dataset. For example: Report has a query of select name, departmentid from employee When the department changes I want to print the department description in the group header for the new department. Can...more >>

Cannot Deploy Report Model
Posted by Jim at 3/21/2006 10:41:20 AM
I'm going through the 2005 SSRS tutorial for creating a report model and I cannot deploy the model. The message I get is: The permissions granted to user 'DOMAIN\USER' are insufficient for performing this operation. Both the SQL Server 2005 and SSRS are deployed on my machine on which I am ...more >>

Page Numbers
Posted by Jim at 3/21/2006 10:39:37 AM
This may seem a dumb question..but Im adding "=Globals!PageNumber" in the footer section of a table and I still get an error when the report builds saying this variable can only be used in the header and footer sections..how can I use this? thanks...more >>

Multi-developer environment, share database?
Posted by Maran at 3/21/2006 8:01:28 AM
You who work in a multi-developer environment. Do you share "ReportServer" database or does every developer has his/her own database? Maran...more >>

Reporting Services 2000 RSClientPrint
Posted by DotNetNow at 3/21/2006 7:22:27 AM
For some reason I am not seeing the Printer Icon on my RS tool bar when running a report off of the report server. I looked in my add-ons for Internet Explorer and RSPrintClient.DLL is installed and active. However, it says that it is not verified. How do I correct this problem? Do I hav...more >>

Action jumping to wrong report
Posted by jon.fife NO[at]SPAM gmail.com at 3/21/2006 6:49:22 AM
Hello all, I have a set of master reports that have linked copies in different directories based on which customer is logging in to view them. Many of the fields in these reports have actions to jump to other reports. The problem I'm running into is that the action is jumping to the report in ...more >>

CreateReport method delivers empty response
Posted by Sandra Geisler at 3/21/2006 3:56:27 AM
Hello, I use the web service for the reporting services with Delphi 7. I call the CreateReport method and it works fine (the RDL is uploaded to the server), but the SOAP response raises in exception because the answer is empty: '<?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmln...more >>

Email Subscriptions Issue
Posted by Chris Taylor at 3/21/2006 12:00:00 AM
Hi, I've been having an issue getting email subscriptions going. I've followed the link on Configure a Report Server for E-mail Delivery on msdn2 and it looks like it creates the report, I'm just getting an odd CAS issue I don't know how to resolve. Here is the info from my log Repor...more >>

Report Builder and Joins
Posted by Kevin Antel at 3/21/2006 12:00:00 AM
Is there a way to use the online report builder web app and do table joins? If so, how? If not, just let me know. Thanks. ...more >>


DevelopmentNow Blog