Page break

Hi All,

I have created one report. When I click on view report information about different countries will be displayed.

By default, reporting services breaks pages of report on some criteria.

I want to break the pages of report on country basis.

For example: Australia: page should include only rows belonging to Australia.

Please teach me how to do this.

Regards

Abdul

Hi Abdul,

Have a read on my article below

http://www.koffeekoder.com/ArticleDetails.aspx?id=339

|||

Hi,

I hope you already have a group created in your report based on Country field. If yes you just need to select the table, right click properties, select groups tab, from the group list select the desired group in your case it will be country and click edit.

you are now on Grouping & Sorting properties dialog box. Just check Page break at end check box and that should resolve your issue.

Cheers,

...

Dont forget to click "mark as answered" on the post that helped you.

...

sql

P

Let's imagine I have a list of countries and the number of people for each of them. I would like to create a matrix representing the bigger countries which contain 50% of the mondial population.

The "top N" and "top %" function won't do the trick. If I had to create this matrix manually I would just order the country list by the number of people, and add each line in the matrix until the total amount of people represent 50% of the mondial population.

I just can't find a way to do that with Reporting Services 2005. Does anyone has an idea ?

Thanks

Well, I don't know if that's posible with Reporting Services. I would use a cursor and a temporary table.