Any clarification needed !!!!
if the need is to show the srvc_chrg only when the slocation value matches the value in all_locs, then setting field srvc_chrg to this would work:
decode( slocation, all_locs, srvc_chrg, null)
the result will be that if the value in slocation equals the value in all_locs, show the srvc_chrg, otherwise use null So in your example, the last row, where slocation = 1253, would show the value and the other two would not.
If this isn't what you want, please clarify and I'll be glad to discuss it further.
Yeah it's working perfectly , thanks alot
I'm glad it worked.
By the way, if your report doesn't like a null value in the field, you can replace null with ' ' (a space between two apostrophes) to put a space in the field or replace the null with 0 to show 0 as the value.
If you get a chance, why don't you mark the answer correct; future readers with the same question are more likely to read questions that are marked as answered when they do searches.