Repeating Field in SSRS report.
-
Hi Everyone, I'm writing a report and there is a requirement to have repeating fields appearing inline. So rather than a table displaying say, user names, the final report should look like this: Static text Static text Static text: Person Name 1, Person Name 2, Person Name 3 I've had a long look, I've tried changing the properties of the table, I've tried playing with expressions. Does anyone have any ideas? Many thanks, Larry
-
Hi Everyone, I'm writing a report and there is a requirement to have repeating fields appearing inline. So rather than a table displaying say, user names, the final report should look like this: Static text Static text Static text: Person Name 1, Person Name 2, Person Name 3 I've had a long look, I've tried changing the properties of the table, I've tried playing with expressions. Does anyone have any ideas? Many thanks, Larry
Sounds like you may need a Pivot table. Search for PIVOT[^]
-
Sounds like you may need a Pivot table. Search for PIVOT[^]
Thanks I'll have a look. I actually got round the problem by writing a stored procedure and putting my output into a string.