Reports

Conditional formatting, text will not display in color
I am using a conditional statement, =iif(Fields!MPlvl.Value = "FFB", "Red","Black"), The text is not showing in red, but instead the cell is displaying "Red". My report is displaying "Red" and "Black", but not in the colr red and black. Do I need to define the color, or set the color somewhere. Thanks f... 13 Jun 2008 13:20

how to avoid using a list item
I want to build a report based on 2 datasets. Each dataset has a multi-select parameter on Region. On the report are 2 tables displayed both based on a different dataset. I want te display the report paged by Region (=the chosen parameter values). I believe I can't us a list item because a list item only can be... 12 Jun 2008 10:47

SCOM Reporting Install Problem
I am trying to install SCOM Reporting on one Management Server. My database is clustered on a different server. I installed SQL Reporting Services, and ran Reporting Services Configuration Manager. I was able to create the virtual directories without a problem. When I try to setup up the DB connection, I am running... 14 Jun 2008 19:56

How to return large multi-value list to sql sp?
SSRS2005... I have a large multi-value parameter list that I need to return to a SQL stored procedure. The list is too large to perform well with XML. I'm looking for ideas on how to accomplish this. One idea I have is to write a function that you pass the multi-value list to. This function inserts each item ... 12 Jun 2008 14:54

Chart
How can I add a line to a area chart in reporting services? ... 12 Jun 2008 06:42

Is it possible to attached TimeStamp under File Name when I create
Hello, Just add @timestamp to filename, like this : "filename @timestamp". "Ken" wrote: Hi, I'm trying to create Subscription delivered by "Report Server File Share". I need to attach the TimeStamp into File Name instead of just increment file names as newer versions are added. Is it possible?... 12 Jun 2008 02:07

ReportViewer - how to fill a text box from data on the parent form
I have a report with a data region (table or matrix) that is filled from a dataset. The menu that supplies the parameters for the report's dataset resides on the web page on whch the ReportViewer is placed. During the criteria selection I build a textual descripton of the selections mand by the user. This is... 27 Jun 2008 03:57

Subscription Job fails to run
I have a report that runs just fine. When I create a standard subscription (email) to run each day, the subscription is created ok. The job is created in SQL Server no problem. When the job executes, I always get : 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK SERVICE'. Both dataso... 16 Jun 2008 00:25

reporting services - data type that is not valid.
Hi, I have a column in a table I am using for report that has text divided by a pipe | character. I need to tell reporting services to break apart that string onto a separate line for each segment divided by a pipe. For example, I have 1-3 | 3-6 | 6-9 | 9-12 |Over 12 and I need 1-3 3-6 6-9 ... 12 Jun 2008 12:51

Slow Print
I have a 2005 report with 3 tables side by side each using a different dataset. There are no subreports. The report opens up quickly in the viewer but takes over 2 minutes to print. The report is only 1 page long. It does export to PDF w/ no issues. Tried printing from 3 different workstations and 2 diff... 11 Jun 2008 15:54