x

remove blank/white page in SSRS-2008

I have a 3-Lists that I would like to make it shows just one page base on the selection of the drop down Parameter. e.g. If the user select option A then only List 1 is showing and the other 2 list will be invisible/hidden or List 2 then List 1 and List 3 will hidden. I put some Javascript codes in the change event of the dropdown list above and it does not work well. It shows the other pages blank (white pages) when I select an option. e.g if I select option 1 then it show page with pg 2 & 3 blank or if I select page 2 then it shows page 2 between page 1 & 3 blank. My question is how can I make the list just show 1 page only based on the selection without showing any blank/white page. Please advice.

more ▼

asked Nov 11, 2009 at 05:21 AM in Default

Nitin 2 gravatar image

Nitin 2
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort oldest

Confused! Are you saying that you have already set a visibility expression on the list and its not working ?

more ▼

answered Nov 11, 2009 at 06:47 AM

dave ballantyne gravatar image

dave ballantyne
928 1 1 4

(comments are locked)
10|1200 characters needed characters left

Do you have new page before or new page after ticked? Your code may be correctly hiding the objects you want it to and its simply the formatting that is giving you the blank pages.

I must agree with Dave though, the question does not clearly identify your issue, can you explain it differently?

more ▼

answered Nov 13, 2009 at 06:13 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 74 78 108

(comments are locked)
10|1200 characters needed characters left

How to eliminate white spaces for hidden columns in SSRS 2008?

more ▼

answered Feb 20, 2010 at 12:54 PM

Manish gravatar image

Manish
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1832
x546

asked: Nov 11, 2009 at 05:21 AM

Seen: 3076 times

Last Updated: Nov 11, 2009 at 05:21 AM