>>It seems you need it for a report, isn't it. If this is the case, the easiest way is to do it directly in the report.
>>
>>Vlad
>
>I am generating the reports from program itself, not by report designer thats why I'm trying to find the sql or any other method, but not report.

Why don't you want to use the report designer??

Vlad