Body Size

Hi,
I have report which requires a long body. But it seems RS doesnt allow body
size more than 160 inches.
Pz anybody suggests how can we overcome this problem.
ThanksWe already have report which has lists on that and in each list has
respective tables/chart and query. Now we need to add more sections to the
existing report. If I add more lists of a page size, i run out of the body.
The other option is to add sub reports. But there is issue is like We have a
table of contents on first section which verifies if the any of the section's
query doesnt return result, dont print in table of content as the same is not
going to be there in report. So to verify I need to write the same query at 2
different place.. If there is a way to find if the subreport is going to have
data or not OR Sub report can write to one of the text box in main report (
table of content), The it will be done.
Thanks !!!
"Jeff A. Stucker" wrote:
> I should have said XML tranformation instead of style sheet.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> > Why do you need such a long body size? You can get around almost anything
> > on the output side by using XML and then linking it to a style sheet.
> > That takes a bit of programming, though.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "manish" <manish@.discussions.microsoft.com> wrote in message
> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> Hi,
> >>
> >> I have report which requires a long body. But it seems RS doesnt allow
> >> body
> >> size more than 160 inches.
> >> Pz anybody suggests how can we overcome this problem.
> >>
> >> Thanks
> >
> >
>
>|||There is a property you can set on subreports that defines something to
display if the subreport is empty. I wonder if you can play with that...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> We already have report which has lists on that and in each list has
> respective tables/chart and query. Now we need to add more sections to the
> existing report. If I add more lists of a page size, i run out of the
> body.
> The other option is to add sub reports. But there is issue is like We have
> a
> table of contents on first section which verifies if the any of the
> section's
> query doesnt return result, dont print in table of content as the same is
> not
> going to be there in report. So to verify I need to write the same query
> at 2
> different place.. If there is a way to find if the subreport is going to
> have
> data or not OR Sub report can write to one of the text box in main report
> (
> table of content), The it will be done.
> Thanks !!!
> "Jeff A. Stucker" wrote:
>> I should have said XML tranformation instead of style sheet.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> > Why do you need such a long body size? You can get around almost
>> > anything
>> > on the output side by using XML and then linking it to a style sheet.
>> > That takes a bit of programming, though.
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "manish" <manish@.discussions.microsoft.com> wrote in message
>> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> >> Hi,
>> >>
>> >> I have report which requires a long body. But it seems RS doesnt allow
>> >> body
>> >> size more than 160 inches.
>> >> Pz anybody suggests how can we overcome this problem.
>> >>
>> >> Thanks
>> >
>> >
>>|||Yeah! I lef with this choice only in this scenario.. Thanks Jeff !!!
"Jeff A. Stucker" wrote:
> There is a property you can set on subreports that defines something to
> display if the subreport is empty. I wonder if you can play with that...
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> > We already have report which has lists on that and in each list has
> > respective tables/chart and query. Now we need to add more sections to the
> > existing report. If I add more lists of a page size, i run out of the
> > body.
> > The other option is to add sub reports. But there is issue is like We have
> > a
> > table of contents on first section which verifies if the any of the
> > section's
> > query doesnt return result, dont print in table of content as the same is
> > not
> > going to be there in report. So to verify I need to write the same query
> > at 2
> > different place.. If there is a way to find if the subreport is going to
> > have
> > data or not OR Sub report can write to one of the text box in main report
> > (
> > table of content), The it will be done.
> >
> > Thanks !!!
> >
> > "Jeff A. Stucker" wrote:
> >
> >> I should have said XML tranformation instead of style sheet.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> >> > Why do you need such a long body size? You can get around almost
> >> > anything
> >> > on the output side by using XML and then linking it to a style sheet.
> >> > That takes a bit of programming, though.
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "manish" <manish@.discussions.microsoft.com> wrote in message
> >> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> >> Hi,
> >> >>
> >> >> I have report which requires a long body. But it seems RS doesnt allow
> >> >> body
> >> >> size more than 160 inches.
> >> >> Pz anybody suggests how can we overcome this problem.
> >> >>
> >> >> Thanks
> >> >
> >> >
> >>
> >>
> >>
>
>|||Why do you need such a long body size? You can get around almost anything
on the output side by using XML and then linking it to a style sheet. That
takes a bit of programming, though.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> Hi,
> I have report which requires a long body. But it seems RS doesnt allow
> body
> size more than 160 inches.
> Pz anybody suggests how can we overcome this problem.
> Thanks|||I should have said XML tranformation instead of style sheet.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Why do you need such a long body size? You can get around almost anything
> on the output side by using XML and then linking it to a style sheet.
> That takes a bit of programming, though.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> Hi,
>> I have report which requires a long body. But it seems RS doesnt allow
>> body
>> size more than 160 inches.
>> Pz anybody suggests how can we overcome this problem.
>> Thanks
>