August 1, 2011 at 11:48 am
Hello all,
I have following field in report.
ID RespID balance Mibalance MaBalance code
Group 1
Group 10
2000 1
3000 2
5000 3
10000 4
I want a output like :
ID RespID balance Mibalance MaBalance code
Group 1
Group 10 20,000 2,000 18,000
2000 1
3000 2
5000 3
10000 4
I want a output based on code
if code=1 then Mibalance =2,000
esle if code in(2,3,4) then 18,000(3000+5000+10000).
How can i get Mibalance and Mabalance based on code?[/email]
August 1, 2011 at 11:54 am
You can add a new column either in the dataset or the query with a case statement and then use that to group on.
August 1, 2011 at 11:59 am
Thanks for reply .:-)
can you explain me detail?
August 1, 2011 at 1:05 pm
Please help me..
Thanks
L
August 1, 2011 at 2:24 pm
Please can you explain me in Details?:-)
August 1, 2011 at 2:36 pm
No more details available unless I literally do it for you.
What have you tried in the last few hours and where are you getting stuck?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply