Okay, got some nice fake consumable data? Doesn't have to be real, just has to be representative of your table structure(s) ... or the output of your stored procedure...

And please...

If all you want to do is divide your counts over a fixed population size, then it's easy. Create a variable and populate it with a COUNT from your...

Given the data, this works:

SELECT RecID

, BO_ID

, Code

, Code_Date

, MAX(CD1) AS Msg1

, MAX(CD2) AS Msg2

, MAX(CD3) AS Msg3

FROM

(SELECT 1380900 AS RecID

,'XZ01' AS BO_ID

, 12 AS Code

, '1/16/2015' AS Code_Date

, 'P302'...

Try this:

...

WHERE TT11.Period>=@BeginPeriod

AND TT11.Period<=@EndPeriod

Instead of

=iif( Fields!ColA.Value<>Fields!ColB,"Red","Green")

try

=iif( Fields!ColA.Value=Fields!ColB,"Green","Red")

CYA and make a backup and keep it in a safe place...

then offer to sell it to him later... No, just kidding about the last part.

Here's one I did based on the database provided by Itzik Ben-Gan in his book. It's the same kind of Customers/Orders/Line Items database. What I'm doing is showing all...

This will return all APInvoiceNum values that contain at least one IT-related expense.

SELECT APInvoiceNum AS Invoice

FROM GLJrnDt1

WHERE GlJrnDt1.SegValue BETWEEN '310100' AND '330500'

/* You may not need these extra filters here...

Imran,

Given that you're a novice and haven't posted much here before, it's a good idea that you read Jeff Moden's article Forum Etiquette: How to post data/code on a forum...

If you specify the...

Please don't cross-post. I think this is a better place for your original question, which is here:

http://www.sqlservercentral.com/Forums/Topic1696469-150-1.aspx#bm1696655

If you post the same question in several forums, responses are harder to...

This parameter limits the data specific to IT related costs which is correct but I want to see IT costs that appear on an invoice which may have costs other...

I suppose you could, but the downside to doing it in SSRS is that you pull back a bigger dataset, and T-SQL will run circles around SSRS doing this any...

How about this one[/url]?

The part you want is at the end of the article.

I would probably see if HappyCat59 knows.