Hi,
Using the ideas discussed in some other posts here, I was able to create a calculation on my cross tab, (i.e. using tabular sets).
So, I had a row A and a row B (both dollars). I wanted a row C which is A/B. I have it now using tabular sets but the problem is that C is also displayed as dollars. Can I change the format somehow only for C without affecting A and B? I couldn't find any such feature in report studio...
Could it be done by modifying the xml somehow?
Thanks a lot for any suggestions.
Change the format to what? It is just a data item. You can cast it to be whatever you wish.
I should have been more explicit in my question. All three rows A,B and C are numbers but when I am displaying it on the report, I choose to display it as currency, which is what I want for A and B. But I don't want to display the $ sign for C.
I don't think using cast in the expression for C will solve this issue. If it could, then I am not able to follow.
Thanks a lot for any help.
conditional variable. if row <> c then diplay $?
Maverick,
Any update on this issue? Please post your solution if resolved and close this topic. Thanks.