These are the requirements I have to do for my new project.
I have a chart. It is a line chart.
Chart should be grouped by Country.(used the section header)
When I grouped it, charts display by country in a list.
There are too many pages will be displaying(30 countries). I have to create 2 countries in row and 4 countries per page.
Countries should be grouped by defined country. For example, in a page India, china, Australia, and UK should display.
I don't think the grouping should be working here.
A bit of a lazy solution would be to give each country its own query, then use a table 2 by 3 and drop charts in the table grid:
1st report page : table1: charts 1-6
2nd report page: table2: charts 7-12
etc
I'm sure there is a more sophisticated solution though..
You could try to use a repeater to show multiple chart in a row.
Furthermore if you want to section them place a repeater in a list
Thanks all for your hint.
How can I show what country do I want in each page or row?
Lets say if country in a column is showing in an alphabetical order but I want to show country in my way(user's way).
Can you please help in a detail step by step?
Continue from the same requirement,
4 countries(by category1: India, china, Japan, ...) should display in a page and the 2 page from group shoul display in a second page.
4 countries(by category2: USA, Canada, ........) should display in a page and the 2 page from group shoul display in a second page.
Do I have create a mutliple pages in a report to view countries by category?
Add a page set
Define a query to the page set and group it with your category (Grouping & Sorting property)
Add the two pages pages under this page set and define the master detail relationship of the objects in the pages.
If you want your pages to be sorted in a differently way create a data item which will give your desire sort and add it to the sort list under the data item that you group you page set.