You’re offline. This is a read only version of the page.
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
@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.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (