It should work in SSRS 2008. I am not sure about SSRS 2005. If that is the case then insert a row (Below Group) and use above expressions.

But, did you...

Yeah... and using code function is the BEST option for this problem.

Use below expression in the last rows:

Total Quantity with Excise Duty = 0

=SUM(IIF(Fields!ExciseDuty.Value = 0,Fields!Quantity.Value,0))

Total Quantity with Excise Duty <> 0

=SUM(IIF(Fields!ExciseDuty.Value <> 0,Fields!Quantity.Value,0))

Here you go:

Select Row Group --> Click Sorting --> Click Add button and write following expression:

=IIF(Fields!Counselor.Value = "No Counselor"," ",Fields!Counselor.Value)

Steve Cullen (6/9/2010)

---

It is considered poor practice to use "select *" for anything but simple, temporary queries.

The good new is that it's easy to make SQL write your queries for...

I can answer your query but I need to understand your question correctly.

Could you explain it with example/snapshot?

Did you check CanGrow properties?

Also try to place matrix control in a rectangle and try again.

I think you can create a Stored Procedure with Input Parameter @CurrentDate. You can filter records based on this parameter.

While calling this Procedure in SSRS report, you can pass Default...

I guess your OR conditions should be placed inside parenthesis "()"

But I dont understand why are you replacing characters from both left and right side since its same in both...

May be below link can help you:

Sort Dimension Members in DESCending order

Try this link:

Sort Dimension Members in DESCending order

Here is the link what you exactly needed:

Sort Dimension Members in DESCending order

I dont think it is possible without Script (C# or VB.NET) language.

However you can create a staging table and load the data into that table. Once you get the data,...

You can follow below steps:

1. Create a new Role and add required users in Membership tab of Edit Role wizard.

2. Give Read Access to Data Sources and Cubes.

3. Create Excel...

It works fine for SSAS as well.

You can add connection string variable in package configuration file. Connection Manager will pick whatever the Server name defined in config file.

I have more...