locked
SSRS XML rendering a chart inside a rectange inside a tablix RRS feed

  • Question

  • I have a report with a bit more complicated hierarchy logic and I want to export it to XML. But for some reasons it fails to render it to XML.

    I have Have a Tablix that is group by row that inside has a rectangle that and inside of that I have a chart for each row. My XML structure that is render looks like:

    <Tablix>
    	<Tablix_Details_Group_Collection>
    		<Tablix_Details_Group/>
    		<Tablix_Details_Group/>
    		<Tablix_Details_Group/>
    		<Tablix_Details_Group/>
    		<Tablix_Details_Group/>
    		<Tablix_Details_Group/>
    	</Tablix_Details_Group_Collection>
    </Tablix>

    I did expect that in each Tablix_Details_Group to have a chart. I know charts and tablix are supported by XML rendering.

    What can I do to get the charts?

    Is the hierarchy that make the problems here?

    Tuesday, July 11, 2017 8:37 AM

All replies

  • Hi Radu Pop,

    I create a table and right click the detailed row to add [category] in group, then insert a rectangle in table cell next to [category] and insert chart in it.

    Then export to XML, I get the result below

    <?xml version="1.0" encoding="UTF-8"?>
    
    -<Report xmlns="Report17" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Name="Report17" xsi:schemaLocation="Report17 http://reportserver?%2FReport17&rs%3AFormat=XML&rc%3ASchema=True">
    
    
    -<Tablix5>
    
    
    -<Details_Collection>
    
    
    -<Details category="domestic">
    
    
    -<Chart9>
    
    
    -<amount Label="amount">
    
    
    -<Chart9_CategoryGroup_Collection>
    
    
    -<Chart9_CategoryGroup Label="domestic">
    
    <Value Y="0.0037"/>
    
    </Chart9_CategoryGroup>
    
    </Chart9_CategoryGroup_Collection>
    
    </amount>
    
    </Chart9>
    
    </Details>
    
    
    -<Details category="international">
    
    
    -<Chart9>
    
    
    -<amount Label="amount">
    
    
    -<Chart9_CategoryGroup_Collection>
    
    
    -<Chart9_CategoryGroup Label="international">
    
    <Value Y="0.12"/>
    
    </Chart9_CategoryGroup>
    
    </Chart9_CategoryGroup_Collection>
    
    </amount>
    
    </Chart9>
    
    </Details>
    
    </Details_Collection>
    
    </Tablix5>
    
    </Report>

    You could follow above sample to create Tablix with XML.

    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, July 12, 2017 6:15 AM