SQL Server SSRS (SQl server 2008)

[LOuisv1]

I have a report that was created in SSRS (Sql Srv 2008 R2). Once I export the report, even just to preview, it throws a page on the 1st page, just showing the header page. Therafter everything is normal.

I chave come across mentions of this on the net but not one working solution. Hope there is someone out there that can help me

Regards

Louis van Rooyen

 

[xlbo]

This will be to do with page sizing / table sizing and pagination settings (i.e. when to put page breaks in etc)

Please post back with page layout size, margin size, no of columns ,table size and page break settings

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[LOuisv1]

HI
INteractive size is A4: 29.7 x 21 Cm wide. no other pagebreaks on the report, they want the report to be on 1 page only, so font size is 7px at the moment. The physical size of the report is 20 cm tall + 2cm tall for the page header. Width matches the interactive size. The report is layed out in a form layout.

Making use of a rectangle and in there I have placed all my tables

 

[LOuisv1]

Hi everyone.

Thank you for the time and effort you spend to assist me. Found the gremlin. There was a group, that was not supposed to have had any page breaks in it, actually had two breaks. removed it, moved my page break to the bottom of the tablix and now it is working. Spend two weeks on this thing!!!!!!!!!!!!!!!!!!!!