Showing posts with label footer. Show all posts
Showing posts with label footer. Show all posts

Monday, March 26, 2012

Parameter Display in Report: Display "Select All" rather than all selections

Dear Anyone,

We have reports in RS that includes a display of selected parameter values in the page footer of the report. When "Select All" is selected in the parameter, all parameter values are displayed in our page footer. We would like to rather display the words "Select All" rather than displaying all of the available selections when select all is selected. Is there a way to do this?

Thanks,
Joseph

If you know the number of parameters in the list, you could compare that number with the count of the parameter collection.
Example:

Set up a text box, and in the expression put:

=iif(Parameters!yourParameter.Count = yourCount, "Select All", Join(Parameters!yourParameter,", "))

That is what I have done. There could be a simpler way, I just haven't stumbled upon it yet! Wink

BobP

|||If only theres a way to determine how many rows or records are returned by the dataset in the parameter.

Wednesday, March 7, 2012

PageNumber in XML output??

Hello,
Is there a way to get information (page number) in the Page Footer to appear
as an Element in an XML export?
Thanks
David BowsI tried to set these properties but they seem not to render when they are in
the Page Footer. They work fine in the body, but I cannot use
Globals!PageNumber in the body of a report only the Page Footer. What I
want is to be able to save the report to PDF then export to XML and then
write a quick app that will go through the XML and build a table of
contents. Seems straight forward, but cannot get any XML from the Page
Footer to export.
Any help would be appreciated.
David
"TrussworksLeo" <Leo@.noemail.noemail> wrote in message
news:E1A812C9-C9A0-47A1-BC25-F01AC7CE7C08@.microsoft.com...
> If the advanced properties for the textbox item UnderData Output you can
> render as an Element... You can also name the element.
> Is this what your looking for?
> Leo
> "David Bows" wrote:
> > Hello,
> >
> > Is there a way to get information (page number) in the Page Footer to
appear
> > as an Element in an XML export?
> >
> > Thanks
> > David Bows
> >
> >
> >

PageNumber in the body

There is Globals.PageNumber variable that can be used only in page header
and footer.
How can I get page number in page body?
Ola A.Try creating an object in the header or footer (this can be invisible)
and assign the Globals.PageNumber value to it.
Then create an object on the page body, and reference the value of the
object in the header to provide its value.
This is similar to other workarounds, and I think it will work - should
be easy enough to try, anyway...
Ola A. wrote:
> There is Globals.PageNumber variable that can be used only in page
header
> and footer.
> How can I get page number in page body?
> Ola A.|||I tried but i get this error:
The hidden expression for the rectangle â'rectangle4â' refers to the report
item â'rectangle2â'. Report item expressions can only refer to other report
items within the same grouping scope or a containing grouping scope.
The rectangle2 is the one who is in the head and the rectangle4 is in the
body.
Ola A.
"Parker" wrote:
> Try creating an object in the header or footer (this can be invisible)
> and assign the Globals.PageNumber value to it.
> Then create an object on the page body, and reference the value of the
> object in the header to provide its value.
> This is similar to other workarounds, and I think it will work - should
> be easy enough to try, anyway...
>
> Ola A. wrote:
> > There is Globals.PageNumber variable that can be used only in page
> header
> > and footer.
> > How can I get page number in page body?
> >
> > Ola A.
>

Monday, February 20, 2012

Page Numbers on Subreports?

How can you get the footer section (Page Numbers) of subreports to print when
part of a main report?
Im using RS 2000.
Thanks,
CraigAnswered my own question. Headers and footers of subreports are ignored.
http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx
"CraigZello" wrote:
> How can you get the footer section (Page Numbers) of subreports to print when
> part of a main report?
> Im using RS 2000.
> Thanks,
> Craig

Page Numbers

This may seem a dumb question..but Im adding "=Globals!PageNumber" in the
footer section of a table and I still get an error when the report builds
saying this variable can only be used in the header and footer sections..how
can I use this?
thanksIn case you are still waiting for a reply, try putting the
"=Globals!Pagenumber" in the Report Footer, not the Table Footer. Click
Report at the top of the page and select report footer.
"Jim" wrote:
> This may seem a dumb question..but Im adding "=Globals!PageNumber" in the
> footer section of a table and I still get an error when the report builds
> saying this variable can only be used in the header and footer sections..how
> can I use this?
> thanks

page number outside page header and page footer

how to display page number outside page header and page footer?

Disable paging in the GridView.

In the AJAX library there is a control calledDataPager.

Set it's PagedControlID to the GridView.

This control can be placed anywhere on the Page.

Page Number display problem when using Cross Tab

I have created a cross tab report using Crystal Report 9. I have placed the Cross Tab object in Group Header section and in Page Footer i am displaying Page Number as well as Company Name in Page Header.
Now, the columns in Cross Tab exceeds the page and therefore goes on next page. Everything works fine, the only thing is the next page does not display Page Header and Page Footer.
What may be the problem ? I have tried placing Cross Tab object Report Header,Report Footer,Page Header,Page Footer but din't got solution.

Thanks in advance.
Chandrakant Shindehttp://support.businessobjects.com/library/kbase/articles/c2008113.asp

this explains the process

dave