To change the currency format in a report you can change the language of the report to reflect your target language.

I am not sure what the indian currency format would be but there are most major language groups in there so have a look.

As for changing number to print words, you will have to do this manually either through nested replace statements in the query or textboc property, or even better would be to have a cacluated column or view on you source sql that does the conversion,

I saw you've been making the same request for a long time. I had shown you in another thread on the same issue an english number-to-words example that you could edit, but you never followed up on that.

here's a TVF that returns the formatted value via TSQL; dunno about reporting services; i guess you could make a similar vb function:

My advice:INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.