I'm learning Reporting Services 2000, and running it on a Win2k3 server. I am the only person using the server and the network, so there are no issues about many people trying to access anything. While learning to build an ASP.NET application I ran across something strange. The first time...more >>

Is it possible to parameterize a value within an expression in SRS 2000 report? I would like the 10 in the expression below to be a user selectable parameter. =iif(Fields!LastHeartbeat.Value < dateadd("n", -10, Now()), "Red", "Black") Regards, Pete Zerger, MCSE(Messaging) Co-founder...more >>

I am building a report with a query that includes a field of type datetime. I would like to change the color of the text in this column to RED if the value contained in the field is earlier than now() - 10 minutes. I would appreciate direction as to the appropriate function to use in this sc...more >>

Hello all, i have a text box in the page footer region that i want to refer to in the report body. How do i refer it? When i enter the text box name and value it says cant find text box. thanks in advance Ishan...more >>

I need to filter data based on some AD groups. What's the best approach to tackle this? Do I create SQL tables from the active directory and create many (140 or so) data driven subscriptions? Do I use an AD web service to provide me the directory info? I was thinking the AD web service w...more >>

Hello I write url Http://Servidor/Reports and present problem Access denied to the Path C:\Archivos de programa\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin". Check the permisos and the user ASP.Net have Full acces Thanks Hernan ...more >>

When my underlying data is in a relational source, I can call a report using URL access like this : http://myserver/ReportServer?/Test/KPI/KPI+by+Site&RegionName=Inland But when using a cube that doesn't work. This affects both URL access and "jump to report" (I suppose the latter uses the f...more >>

If I publish a website in vs05 and Check "Allow this precompiled website to be updatable", everything works. If I uncheck the box, then the rdlc files get sent to the website minus their guts, but with the standard placeholder text you see in aspx files that are precompiled. When you reques...more >>

My problem right now is I have three layers in my sheet. Objective level measure level region level facility level The facility level is not a problem, just a Field!Facility.Value, it's a straight pull from the db. Region is fine, it's a sum(Field!Facility.Value) Measure is a bit tricky, b...more >>

I want to create a report that lists names in three or four columns across the page. For example John Doe | Jane Doe | Bubba Doe | Alex Doe Me Doe | Her Doe | Their Doe | My Doe I have tried to use the table control but can't figure it out. Any suggestions? John ...more >>

Hi, When I am installing "Reporting Services in SQL 2005", there is a problem "SQL Server Setup failed to retrieve the SSL Certificate Name". How can I solve this problem ...thank you.. Umit...more >>

Greetings, I was under the impression that SSRS 2005 was able to support multi-value parameters w/o the use of dynamic sql inside the query. If this is true can someone please clarify the syntax or point me somewhere that has it? Currently my query looks like the following: select col...more >>

I am running a report that is using a stored proc that has been changed. I made the changes that I am aware of however there seems to be a field somewhere in an expression that causes this error ... I cannot figure out how to locate the field! It doesnt tell me what expression or what field....more >>

Hi - can anyone help me with the best way to group & repeat charts? The scenario is that I have 3 different CPU capacity report charts ran on 20 different servers & I want to group the reports together by server so it will look like: Server1 CPU Chart1 CPU Chart2 CPUChart3 ...more >>

Hell Everybody, Let's suppose on my report I have a matrix with sales data - regions in columns, years in rows. Now I need to add an additional total column with, let's say, total profit. I tried to accomplish that adding a hidden value. Unfortunately it seems like I have no control over...more >>

i added an app.config to my custom assembly but when i try to read keys from it i get Nothing back. my config file looks like this: <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="SERVER" value="j4b-web-srv6" /> <add key="DATABASE" value="GUIDEWEB...more >>

I have a report with 12 parameters. They all have a default setting. When I go to preview the report in the IDE it automatically starts to generate the report with the user having to hit the view report button. Is there a way to keep the report from auto generating without user interaction?...more >>

Hi, How to insert HTML text in my .RDL report file? Thanks in advance...more >>

Hi everyone, I have a report where I have a rectangle witha bunch of lists and textboxes on it which I hide on a certain case. The problem is, its still taking space on the report page when the report is generated. It doesn't appear, but I get a big empty space.... Is there any way to let t...more >>

I'm creating a SOX compliance report in Reporting Services 2000 via SQL Server 2000. We will be upgrading in the next 3 months to 2005 on both, so I need this question answered for both databases. How do I pull permissions & fixed roles for all mapped NT accounts? I can find the many of...more >>

Am i trying to check if a field has been returned or not before i display the value as i know that in the future this field will eventually be avaible. I have read some posts that suggest using the IsMissing check but i have found documents on the internet that says thet reporting services do...more >>