Blank page?

In my report I have 4 lists. In the each list I have textbox (Company Name)
And matrix. Each list shows in separate page. So basically if I view report
I have 4 pages.
The problem is.
For example, If in my report parameter, which is â'Group Nameâ'
(A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
still 4 pages and 2 pages is blank. How can I remove that blank pages?
I used matrix in the list to able to view each matrix in separate pages.
Thank you.On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> In my report I have 4 lists. In the each list I have textbox (Company Name)
> And matrix. Each list shows in separate page. So basically if I view report
> I have 4 pages.
> The problem is.
> For example, If in my report parameter, which is 'Group Name'
> (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> still 4 pages and 2 pages is blank. How can I remove that blank pages?
> I used matrix in the list to able to view each matrix in separate pages.
> Thank you.
I don't work with lists often but if I were trying to do here is where
I'd start.
Try conditioning the visibility properties of your lists.
Insert an expression into the Visibility>Hidden property of the
individual lists. For the Group Name A list, try something like:
=IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
You may need to fiddle with the syntax some but what you're trying to
get at is
"If A is found in the Group Name param
then show the List
otherwise hide the List"
If needed, the namespace is Microsoft.VisualBasic.
If lists work like tables and other report items, the non-hidden ones
should move up and fill the white space left by the hidden ones.
HTH
toolman|||I do not have problem to hide my lists. If i unselect 2 groups it will hide
the lists but leaves the 2 blank pages. I need to remove these blank pages.
"toolman" wrote:
> On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > And matrix. Each list shows in separate page. So basically if I view report
> > I have 4 pages.
> > The problem is.
> > For example, If in my report parameter, which is 'Group Name'
> > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > I used matrix in the list to able to view each matrix in separate pages.
> >
> > Thank you.
> I don't work with lists often but if I were trying to do here is where
> I'd start.
> Try conditioning the visibility properties of your lists.
> Insert an expression into the Visibility>Hidden property of the
> individual lists. For the Group Name A list, try something like:
> =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> You may need to fiddle with the syntax some but what you're trying to
> get at is
> "If A is found in the Group Name param
> then show the List
> otherwise hide the List"
> If needed, the namespace is Microsoft.VisualBasic.
> If lists work like tables and other report items, the non-hidden ones
> should move up and fill the white space left by the hidden ones.
> HTH
> toolman
>|||Try to adjust the canvas size in layout to match the report width and height
in Report Properties.
Thanks,
"JT" wrote:
> I do not have problem to hide my lists. If i unselect 2 groups it will hide
> the lists but leaves the 2 blank pages. I need to remove these blank pages.
>
> "toolman" wrote:
> > On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > > And matrix. Each list shows in separate page. So basically if I view report
> > > I have 4 pages.
> > > The problem is.
> > > For example, If in my report parameter, which is 'Group Name'
> > > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > > I used matrix in the list to able to view each matrix in separate pages.
> > >
> > > Thank you.
> >
> > I don't work with lists often but if I were trying to do here is where
> > I'd start.
> >
> > Try conditioning the visibility properties of your lists.
> >
> > Insert an expression into the Visibility>Hidden property of the
> > individual lists. For the Group Name A list, try something like:
> > =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> > You may need to fiddle with the syntax some but what you're trying to
> > get at is
> > "If A is found in the Group Name param
> > then show the List
> > otherwise hide the List"
> > If needed, the namespace is Microsoft.VisualBasic.
> >
> > If lists work like tables and other report items, the non-hidden ones
> > should move up and fill the white space left by the hidden ones.
> >
> > HTH
> > toolman
> >|||Each list shows in separate pages but if is one list unselected (For exmp:
group A - from report parameter) then it should not show the 1 page. Instead
of that I do have the blank page. How to remove the blank page?
"naren" wrote:
> Try to adjust the canvas size in layout to match the report width and height
> in Report Properties.
> Thanks,
> "JT" wrote:
> > I do not have problem to hide my lists. If i unselect 2 groups it will hide
> > the lists but leaves the 2 blank pages. I need to remove these blank pages.
> >
> >
> > "toolman" wrote:
> >
> > > On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > > > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > > > And matrix. Each list shows in separate page. So basically if I view report
> > > > I have 4 pages.
> > > > The problem is.
> > > > For example, If in my report parameter, which is 'Group Name'
> > > > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > > > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > > > I used matrix in the list to able to view each matrix in separate pages.
> > > >
> > > > Thank you.
> > >
> > > I don't work with lists often but if I were trying to do here is where
> > > I'd start.
> > >
> > > Try conditioning the visibility properties of your lists.
> > >
> > > Insert an expression into the Visibility>Hidden property of the
> > > individual lists. For the Group Name A list, try something like:
> > > =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> > > You may need to fiddle with the syntax some but what you're trying to
> > > get at is
> > > "If A is found in the Group Name param
> > > then show the List
> > > otherwise hide the List"
> > > If needed, the namespace is Microsoft.VisualBasic.
> > >
> > > If lists work like tables and other report items, the non-hidden ones
> > > should move up and fill the white space left by the hidden ones.
> > >
> > > HTH
> > > toolman
> > >

Blank page for hidden table

Hello,
I have three tables all on separate pages, with a PageBreakAtEnd = true for
all of them to force the page breaks. However, if I hide the middle table, I
still get a blank page where it would be when I export to PDF. How can I not
get the blank page where the hidden table would normally be?
I need to have the page breaks at the end of all tables because sometimes
the middle table will not be hidden. The visibility of the middle table is an
expression toggled by a parameter value.
ThanksTry to play with the "list" or "Rectangle".here is my suggestion not
solution
On Apr 2, 9:08=A0pm, Lucky Horseshoe
<LuckyHorses...@.discussions.microsoft.com> wrote:
> Hello,
> I have three tables all on separate pages, with a PageBreakAtEnd =3D true =for
> all of them to force the page breaks. However, if I hide the middle table,= I
> still get a blank page where it would be when I export to PDF. How can I n=ot
> get the blank page where the hidden table would normally be?
> I need to have the page breaks at the end of all tables because sometimes
> the middle table will not be hidden. The visibility of the middle table is= an
> expression toggled by a parameter value.
> Thanks|||I tried putting the table to be hidden inside a list and then a rectangle but
I still get empty space on the page for it when I export to a PDF. Any other
ideas out there?
Thanks.
"RajDeep" wrote:
> Try to play with the "list" or "Rectangle".here is my suggestion not
> solution
> On Apr 2, 9:08 pm, Lucky Horseshoe
> <LuckyHorses...@.discussions.microsoft.com> wrote:
> > Hello,
> > I have three tables all on separate pages, with a PageBreakAtEnd = true for
> > all of them to force the page breaks. However, if I hide the middle table, I
> > still get a blank page where it would be when I export to PDF. How can I not
> > get the blank page where the hidden table would normally be?
> >
> > I need to have the page breaks at the end of all tables because sometimes
> > the middle table will not be hidden. The visibility of the middle table is an
> > expression toggled by a parameter value.
> >
> > Thanks
>|||I have same issue but the thing is i have blank page showing in the report it
self.
Seems like you do have only when you export but not in the report. Could you
please explain how to hide blank page in the Report manager?
Thank you.
"Lucky Horseshoe" wrote:
> I tried putting the table to be hidden inside a list and then a rectangle but
> I still get empty space on the page for it when I export to a PDF. Any other
> ideas out there?
> Thanks.
> "RajDeep" wrote:
> > Try to play with the "list" or "Rectangle".here is my suggestion not
> > solution
> >
> > On Apr 2, 9:08 pm, Lucky Horseshoe
> > <LuckyHorses...@.discussions.microsoft.com> wrote:
> > > Hello,
> > > I have three tables all on separate pages, with a PageBreakAtEnd = true for
> > > all of them to force the page breaks. However, if I hide the middle table, I
> > > still get a blank page where it would be when I export to PDF. How can I not
> > > get the blank page where the hidden table would normally be?
> > >
> > > I need to have the page breaks at the end of all tables because sometimes
> > > the middle table will not be hidden. The visibility of the middle table is an
> > > expression toggled by a parameter value.
> > >
> > > Thanks
> >
> >