Hello,
Please I want to design a report on SSRS.
The columns are; Item number Doc type Transaction qty
Hace1 POP 5
Hace1 SLS -5
But I want the qty for SLS to show in another column like this;
Item number Doc type Transaction qty Qty Sold
Hace1 POP 5
Hace1 SLS -5
Please how can I create such column when I have just one field containing the transaction qty.
Please I need your help.
Thank you
*This post is locked for comments
You are welcome.
If my suggestion solved your problem, mark as a verified. Because this will helps to some others who having the same problem.
@Soma
Thank you it worked.
Use CASE statement on your query as below to achieve the same.
select [Item number],
[Doc type],
CASE WHEN [Doc type] = 'POP' THEN [Transaction qty] ELSE 0.00 END 'Transaction qty',
CASE WHEN [Doc type] = 'SLS' THEN [Transaction qty] ELSE 0.00 END 'Qty Sold'
from [Tabel Name]
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156