Hello Ravi,

I got the answer. To calculate running balance, I've used PREVIOUS function.

=IIF(ISNothing(Previous(Fields!GLCrDr.Value+Fields!credit.Value-Fields!debit.Value)),Format(Fields!GLCrDr.Value+Fields!credit.Value-Fields!debit.Value,"N"),Format(Previous(Fields!GLCrDr.Value+Fields!credit.Value-Fields!debit.Value)+Fields!credit.Value-Fields!debit.Value,"N"))

Hope this will help you.

Thanks for the reply

This is the MDX query whose result i want in grid view.

where,

m= {measure name of measure group}

d={dimension name}

a={attribute hierarchy}

String ml_MDXquery = @"SELECT ([Measures].[" + m + "])...