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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|