0

I have 5 visualizations in my rdl file. After each visualization I have a ABOUT Textbox which should be filled from a database table and it has html content to render.

Consider a table with 5 rows having visualization name and ABOUT Text.

<table><tr><th>visualization Name</th><th>About Text</th><th></th><th></th><th></th></tr><tr><td>Visualization1</td><td>&lt;B&gt;Table1&lt;/B&gt;</td><td></td><td></td><td></td></tr><tr><td>Visualization2</td><td>&lt;I&gt;Table2&lt;/I&gt;</td><td></td><td></td><td></td></tr><tr><td>Visualization3</td><td>&lt;B&gt;Chart1&lt;/B&gt;</td><td></td><td></td><td></td></tr><tr><td>Visualization4</td><td>&lt;I&gt;Chart2&lt;/I&gt;</td><td></td><td></td><td></td></tr><tr><td>Visualization5</td><td>&lt;B&gt;PieChart1&lt;/B&gt;</td><td></td><td></td><td></td></tr></table>

I have created a DataSet which would pull all 5 rows along with 2 columns. And I want to link each row's AboutText field to each TextBox of individual visualization. Of course I'll have to use filters. But there is no option for adding filters in TextBox expression. And I don't want to create 5 separate DataSets for just rendering purpose.

How would I achieve this in SSRS 2016?

Rameshwar Pawale
  • 632
  • 3
  • 17
  • 35

2 Answers2

0

Create a tablix and put your visualisation in one row and your About Text in the next row as a child group. Set the child groups visibility to be toggled on the parent group and your will be able to expand and collapse the About Text row by clicking on a little + icon that will appear next to your Visualisation.

iamdave
  • 12,023
  • 3
  • 24
  • 53
  • Can't we do it without Tablix? Because we have 2 textboxes around each visualizations i.e. one above & another below. We kind of want to avoid About text in tablix. – Rameshwar Pawale Oct 21 '16 at 11:24
  • @RameshwarPawale What is wrong with a tablix? You can make them look like they aren't even there. Formatting them so that you have text above and below in separate fields is very possible. – iamdave Oct 21 '16 at 11:48
  • then there would be 2 Datasets for a single tablix. One for visualization and one for About Textbox. – Rameshwar Pawale Oct 21 '16 at 13:02
  • @RameshwarPawale Why can that not been in the same dataset? – iamdave Oct 21 '16 at 15:04
0

There are a few ways you could do this. One option is to add an ID column to your dataset. Then in each textbox you can use the Lookup function to get the appropriate label. Another option is to insert a table with one cell next to each visualization. You can use the Filter property on the table to control which label is shown.

StevenWhite
  • 5,907
  • 3
  • 21
  • 46