Page break for a category group of a chart - SSRS 2008 R2

Question

Hi,

I need to add a page break for one of two category groups of a my chart. Is it possible, please?

I need to create a chart for this category group to mantain readable the report.

Thanks

Answer 1

Hi There

You can create two graphs and put them inside two separate rectangles and add page break  after first rectangle and add a filter to your chart for first category group for first chart and second category group for second chart.

This is best you can do

If you have any question please let me know.

Many Thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 2

Hi Syed, thanks for your reply.

I explain better the issue, with an example. As category groups I could have ProductCategories and Countries. In the chart, I need to put both these dimensions as a category group (not in the legend). For all product categories I'd like to have a chart for each country on a different page.

Is it possible to have this behaviour?

Thanks

Answer 3

Hi There

I am afraid this would not be possible, you can use the similar approach as I have done above to spilt you data to multiple charts for every country by putting them inside the rectangle and put filter for every chart for one country.

If you have any question please let me know.

Many Thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 4

Hi Syed, do you say that if I should have 20 countries I need to create 20 charts and not only one?

If so, it's absurd?

Thanks

Answer 5

Using the PageBreak --> Between property?

Thanks

Answer 6

Hi There

One thing which I can suggest you please create a table and then create group inside your tablix for country and then try to put your chart inside the group and create a page break between each instance of the group this way you could easily achieve this.

If you have any question please let me know.

Many Thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Answer 7

Hi Syed also I'm thinking to this solution that I'm trying ...

Answer 8

Hi There

I am sure it will work for you  as I have done this many time in SSRS 2005 as well

Many thanks

Syed Qazafi Anjum

Answer 9

In fact, in this way I've a page for each country. But is it possible to hide this category group without delete it?

I've the country as a column in my table and I'd like to hide it in the axis.

Thanks

Answer 10

 

Hi There

I could not understand can you please put a screenshot for me. I think you do not need a have ny column inside table you can just create a group for country without displaying it inside the row group. Is that what you after? Please explain further with a screenshot

If you have any question please let me know.

Many Thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Answer 11

Hi Pscorca,

To achieve your goal, you can place the chart in a List control. Please refer to the following steps:

1. Drag a “List” control to the Design surface. Click the list, right-click on the row handle of the list to open the “Tablix Properties” pane. Set the “DataSet Name” to the same dataset as the chart.
2. Click the list, open the “Group Properties” dialog from the Grouping pane. Click “Add”, and select “[Country]” field in the drop-down list.
3. Drag the chart to the list.

References:
Adding a list

If you have any questions, please feel free to let me know.

Regards,
Mike Yin

Answer 12

Hi Mike, many thanks for your alternative solution.

I'm asking to Syed if it is possible to hide one of the two category groups (country) but not delete it, in order to avoid to repeate this data for the group inside table and for the category group of the chart.

Thanks

Answer 13

 

Hi Pscorca

Can you please put a screenshot what is displaying now and what you don’t want to display. It will help me to understand the issue easily and I might be able to help you quickly

If you have any question please let me know.

Many Thanks

Syed Qazafi Anjum

Answer 14

HI,

 I have to use four category group but in parallel position not in nested form is their any way to do so??