Thanks for the Input Niraj.

By implementing the switch or IIF I am restrting the codes to the specified numbers. And also I have to do the same thing over and...

Please help me.

Solved the problem.

Its soo weired... I cannot even imagine this happens. I cannot even explain why does this happen.

OK...here is what I did....

Use RunningValue() function. You can find it under Aggregates.

Hope this helps.

I am checking existing row value with the previous row value and hiding the repeated one.

The above posted problem is solved. I have created two functions in Report properties ,Code which...

Thanks Joe. I understand that these are defined in backend. Please go through the Many to Many and Many to one records with consecutive transa... posting. I have...

Thanks for the response James. I'll work on it and update you acccordingly.

I need to do a sum of Payment values for distinct values of Transactions Nos. Can anybody please shed some light on this topic.

Thanks for THE Helpful link James. I am working on it and will update you accordingly.

Thanks Prasad for the suggestion. The values that I get from the database are repeated....

Thanks for the reply Martin. By doing DISTINCT COUNT I can only get the count of number of distinct rows. I want to add the visible row values.

For example: Say,...

Thanks for the reply. I thought about it before I post this question and also checked with the execution plan. This values generated for this report is by a query...

Thanks Jon Spink. I have done those vaidations behind the scenes in VIEW and using that in SSRS.

Thanks

The Multi-Valued parameter is a string. I am fllling all the four parameters with their datasets, which work fine.

My Question  : Is it mandatory to select atleast one value...

Chris Hays has explained a similar scenario if you are using multi-value as a property. You can find it here : http://blogs.msdn.com/chrishays/archive/2004/07/27/AllParameterValue.aspx

Hope this helps..

Use RunningValue() Function.

I hope this helps.