printing report

[sds814]

A report that was designed has about 60 fields. All of these fields have a visibility set to false. If the user selects these fields from the front end then the fields' visibility is set to true so they are shown in the report.

A report was generated that has two fields and 9 rows. The actual report on a 8.5 by 11 page took one tenth of that size. However, when trying to print the report there are 25 pages to print. Even when the report was exported to pdf the report had 25 pages.

Is this because of how the report was designed? To prepopulate the 60 fields.

Thanks.

 

[Jacque]

Hi sds814,
A couple of things you might look at are your margins. I design my portrait reports with width 7.5 and set my margins to 0.5in. Also, make sure that your columns hide when blank/empty.
Jacque

 

[xlbo]

Not sure about SSRS 2005 but if this is 2000, then just setting the visibility to false literally just makes them invisible - it doesn;t move or re-size any other fields so the size of the report is the size of the report when all 60 fields are visible - it doesn;t get any smaller just by making some of the fields invisible - report size will stay as is whether you can see the data or not...

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

 

[bburnell]

2005 makes the report "compress" a row if *all* the fields on that row are set to "invisible." I don't work much with 2000, but I'd go by what Geoff says.

--------------------------
Web/.net Programmer & DBA
Central PA

 

[xlbo]

hopefully, one day soon, I might actually get to work with the "proper" version of SSRS (ie 2005) rather than continually finding "challenges" in what was the beta testing version (2000) !

Good to know that the visibility option does compress in RS2005 - thought that was a weird way of working when I 1st discovered it in RS2000!

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

 

[sds814]

thanks for the help, guys. I apologize for not mentioning that I'm working with 2005.

Jacque: I'll doublecheck the margins and columns are hidden when blank/empty.

 

[bburnell]

Well, like I said, every field on that whole row has to be invisible for it to suppress. Just remember that.

--------------------------
Web/.net Programmer & DBA
Central PA