Hi,

If the error is something like "failed to evaluate filter expression" then it's likely due to the fact that SSRS apparently does not implicitly cast numeric values. Try using...

That's right. Your target machines will not require SQL Server, SQL Express, or SSRS installed on them. ReportViewer is a standalone redistributable form control (cf. my link above). It renders...

Hi. This is a common requirement. Probably what you need is this expression in the textbox:

=Join(Parameters!YourParameterName.Label, ", ")

OR

=Join(Parameters!YourParameterName.Value, ", ")

depending which you want to display.

Note that the (0) in...

I find it's a minimum of trouble to write a simple Windows Forms app and use the ReportViewer control in Local mode against a BindingSource connected to the Access database....

The following SSC article may put you on the right track:

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/63415/[/url]

You can use something like this in the header textbox, if the two parameter values will never change:

=IIF(Parameters!pathway.Value = "NONAdmitted patients 18 weeks", "NONAdmitted", "Admitted")

Try the following expression in the BackgroundColor property of the matrix cell:

=IIF(Not(InScope("matrix1_rowCategory")) And Sum(Fields!cellvalue.Value) <= 20, "Red", Nothing)

where matrix1_rowCategory is the name of your matrix's row category, and cellvalue is...

Most likely you will want to put a conditional expression in the BackgroundColor property of the matrix cell, which tests both the value in the cell and whether it is...

Hi,

Thanks for showing a data sample. I assume you're using SSRS 2005, since customizing header groups like this is apparently a lot easier to do in SSRS 2008 within...

Hi Andy,

Then leave the date out of the items returned in your query, and keep it in the WHERE clause:

SELECT LEFT(SLCustomerAccount.CustomerAccountNumber, 4) AS [Account...

Yep, I think you'll have better luck that way.

Hi!

I think what you're asking is a T-SQL question. You'll probably get an error if you use HAVING without an aggregate expression. Why don't you put the conditions in a...

tsmith (7/17/2009)

---

Writing a query is not an option. The report we need to generate runs off a stored procedure, and we do not want to touch it. What I am...

I tend to do this using special characters, one of two ways:

1. Using the same text font as the rest of the report, I put a bullet character (•) for...

Yes, you can apply a border property to a whole matrix group by first selecting the group in the designer. But if you've got more than one group, you may...