I just gave an example. The months might be changing. So i was looking any dynamically arranging it.

I attached the code below. In the results you can see jan coming first, but i need it to last as it is from 2012.

CREATE TABLE #Sales (SalesDate smalldatetime,Customer int,Sales...

Thank you. But ExecutionLog has data when the report is completed. I wanted to know that when report is running.

But anyway there is field called JobType which has values 0...

They use different data source and tables. I was looking for something like crystal report has limit of running 20 reports at a time.

No, each sales rep name and sales are displayed on top and with date of sales in detail section.

Yes, i'm sorry, wrong post. Instead of posting it to reporting services forum, i posted here.

When i run it it gives me error, saying not a valid identifier.

The ISO Week for above statement gives 51 but it should be 52.

Ok, the current date is 2012/01/04. So for previous week will be 2011/12/25.

When we use datepart for 2011/12/25, it gives 53. But it must 52 as we have 52 weeks...

That displays values

Cust % Sales TotalSales

1 1.00% $12 $12

2 0.00% $13 $0

3 2.00% $14 $14

Thank you, I think this will help me.

When i just use the =SUM(Fields!Sales.Value, "DataSet1") expression, it gives me total sales $39 i.e. (12 + 13 +14)

Yes, the field names are correct. Nothing has been underlined in the expression. Below is the exact expression:

=SUM(IIF(Fields!CreditAllowance.Value > 0, Fields!Sales.Value, 0), "DataSet1")

My dataset name is dataset1. I usually don't change the dataset name, so it is DataSet1.

Hi Steve,

When i tried your expression, it gives shows me error in that field. I used the expression

SUM(IIF(Fields!Percent.Value > 0, Fields!Sales.Value, 0), "DataSet1")

I don't have grouping on this report, so...