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
one sql column shows in multiple columns in one row
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: one sql column shows in multiple columns in one row
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.