Are the values you're trying to count exactly = to LA? All upper case, no leading or trailing spaces that need to be trimmed. SSRS can be really...

Try using SUM instead of COUNT.

SUM(IIF(your field Value = "LA",1,0))

This way it's summing ones or zeros instead of conditionally counting fields.

Substitute IIF( for IF, a comma for THEN and another comma for ELSE and place a close paren ')' at the end.

IIF syntax is IIF( check expression, true expression, false...

Just so you know why the IIF doesn't work: IIF is a function. SSRS reads the entire statement kind of from the inside out. It sees the division operation before...

I'd go with Lowell's solution instead of my temp table option.

Select your data into a temp table and do a final select that sums the counted fields and groups by the location and year.

That's one quick and dirty way to...

Didn't even know we could do such things Jack.

At your suggestion, it's been done. Thanks

I use the query below to generate a dataset for a report that tells me when subscriptions fail to send e-mail or post reports to file shares based on the...

I don't think you can do it. At least I can't see any property for text direction or text orientation. Sorry I couldn't help.

I like these two:

Microsoft SQL Server 2005 Reporting Services

Brian Larson

McGraw-Hill, Hardcover, Published December 2005, 767 pages, ISBN 0072262397

Professional SQL Server 2005 Reporting Services

Paul Turley, Todd Bryant, James Counihan, Dave...

Try using these resources then ask again if you still can't figure it out.

http://msdn.microsoft.com/en-us/library/aa237787(SQL.80).aspx (SSRS2000)

http://msdn.microsoft.com/en-us/library/ms159150(SQL.90).aspx (SSRS2005)

HTH

is250sp (11/5/2008)

---

Here is my IF statement:

=iif(Fields!PROD_MIN.Value > 0, Fields!THROUGHPUT.Value / (Fields!PROD_MIN.Value / 60), 0)

result: When PROD_MIN is > 0, calculation is done, but when its zero, it display #Error

I...

Select all of your cells within your table (click the upper leftmost cell and drag to the lower rightmost cell) and enable all borders for them. Think that should...

latingntlman (10/29/2008)

---

I, too, am getting #Error when running my report. I'm trying to get the name of the month and year to display in my header. The year...

Couple thoughts...

Christophe - SSRS from it's inception has been able to use any ADO.NET data as a datasource. I've even used an Excel spreadsheet as a datasource.

Regarding Hacker's...