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

Overlay lines on x axis

I need to overlay the bar lines on a chart in reporting services. I
have actual and budget numbers that need to be displayed, but they
need to be overlayed, not side by side as the column chart does by
default. Any ideas on how to do this?
Thanks,
JoshDid you look at this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c229b25c-b2dc-41ac-923d-decbb253dc6e&sloc=en-us
It is possible to combine column and line charts. However, this is not
possible for bar and line charts.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Josh Harris" <joshua_c_harris@.hotmail.com> wrote in message
news:eda768cf.0411241126.4e25fb10@.posting.google.com...
> I need to overlay the bar lines on a chart in reporting services. I
> have actual and budget numbers that need to be displayed, but they
> need to be overlayed, not side by side as the column chart does by
> default. Any ideas on how to do this?
> Thanks,
> Josh