one sql column shows in multiple columns in one row
Posted: Wed Feb 23, 2022 5:06 pm
Hello,
I have a report with Azure SQL connection. There is a table with branches data, this table has columns like branchId, BranchName,tagName。 and each branch has multiple tags。 when I generate report by Designer, it shows multiple columns of tags if the branch has more than one tag. So is it somehow possible to show only one row with multiple columns of tags for each branch?
for instance, right now the report show like this:
branch tag
branch A tag A
tag B
branch B tag C
and what I need is to show like below
branch tag tag
branch A tag A tag B
branch B tag C
Thanks and kind regards
Wenwei
Lavi Industires
I have a report with Azure SQL connection. There is a table with branches data, this table has columns like branchId, BranchName,tagName。 and each branch has multiple tags。 when I generate report by Designer, it shows multiple columns of tags if the branch has more than one tag. So is it somehow possible to show only one row with multiple columns of tags for each branch?
for instance, right now the report show like this:
branch tag
branch A tag A
tag B
branch B tag C
and what I need is to show like below
branch tag tag
branch A tag A tag B
branch B tag C
Thanks and kind regards
Wenwei
Lavi Industires