Hello,
I can see how to add a page header to a report in Reporting Services. But
is there a Report Header section? What I need to do is to display a reoprt
title on the Report Header, then force a new page after the Report Header
section and list my data. How can something like this be accomplished using
Reporting Services?
Thanks,
RichWe use a rectangle on the first page and put our intro page there, then
check the page break after property.
Steve MunLeeuw
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> Hello,
> I can see how to add a page header to a report in Reporting Services. But
> is there a Report Header section? What I need to do is to display a
> reoprt
> title on the Report Header, then force a new page after the Report Header
> section and list my data. How can something like this be accomplished
> using
> Reporting Services?
> Thanks,
> Rich|||Thank you (again). It is starting to make sense.
Rich
"Steve MunLeeuw" wrote:
> We use a rectangle on the first page and put our intro page there, then
> check the page break after property.
> Steve MunLeeuw
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> > Hello,
> >
> > I can see how to add a page header to a report in Reporting Services. But
> > is there a Report Header section? What I need to do is to display a
> > reoprt
> > title on the Report Header, then force a new page after the Report Header
> > section and list my data. How can something like this be accomplished
> > using
> > Reporting Services?
> >
> > Thanks,
> > Rich
>
>|||Forgot to ask -- so I add a rectangle - I am guessing to the detail
section, then I place a page break there. I have placed 5 textboxes in a
list control. This report prints labels (real pain to set the column widths
a row spacings just right). I don't want to upset the spacings of the
textboxes because it took me a long time (and a lot of tree killing and ink
usage) to get the spacings just right in the detail section.
May I ask where I place the rectangle?
And to stretch this inch to a mile, I was just told that the labels have to
be all in uppercase. In my winform app there is a textbox property for
charactercasing. I did not see that in the RDL. I looked at the Globals
collection but nothing caught my attention for forcing upper case. I could
force upper case at the datasource level, but is there a way to specify/force
character casing at the Report Textbox level? How to do that?
Thank you for your help and patience. I really appreciate it.
Thanks,
Rich
"Steve MunLeeuw" wrote:
> We use a rectangle on the first page and put our intro page there, then
> check the page break after property.
> Steve MunLeeuw
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> > Hello,
> >
> > I can see how to add a page header to a report in Reporting Services. But
> > is there a Report Header section? What I need to do is to display a
> > reoprt
> > title on the Report Header, then force a new page after the Report Header
> > section and list my data. How can something like this be accomplished
> > using
> > Reporting Services?
> >
> > Thanks,
> > Rich
>
>|||I think you would want the report header rectangle at the begining of the
report body. I see your point on the layout, nothing comes to mind...you
can have a zero height, but then it would be pretty darn hard to add your
textbox layout.
Here's what I'd try:
Make a backup copy, or use source control
Note the top property of the topmost item in the body
Cut everything in the body
Add two rectangles
Paste everything into the second rectangle
Use the up/down arrows with everything selected in the rectangle so you get
the same top spot noted before
set the page break property on the first rectangle
For the uppercase you have access to quite a bit.
try:
System.String.ToUpper(field!myField.Value)
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> Forgot to ask -- so I add a rectangle - I am guessing to the detail
> section, then I place a page break there. I have placed 5 textboxes in a
> list control. This report prints labels (real pain to set the column
> widths
> a row spacings just right). I don't want to upset the spacings of the
> textboxes because it took me a long time (and a lot of tree killing and
> ink
> usage) to get the spacings just right in the detail section.
> May I ask where I place the rectangle?
> And to stretch this inch to a mile, I was just told that the labels have
> to
> be all in uppercase. In my winform app there is a textbox property for
> charactercasing. I did not see that in the RDL. I looked at the Globals
> collection but nothing caught my attention for forcing upper case. I
> could
> force upper case at the datasource level, but is there a way to
> specify/force
> character casing at the Report Textbox level? How to do that?
> Thank you for your help and patience. I really appreciate it.
> Thanks,
> Rich
> "Steve MunLeeuw" wrote:
>> We use a rectangle on the first page and put our intro page there, then
>> check the page break after property.
>> Steve MunLeeuw
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
>> > Hello,
>> >
>> > I can see how to add a page header to a report in Reporting Services.
>> > But
>> > is there a Report Header section? What I need to do is to display a
>> > reoprt
>> > title on the Report Header, then force a new page after the Report
>> > Header
>> > section and list my data. How can something like this be accomplished
>> > using
>> > Reporting Services?
>> >
>> > Thanks,
>> > Rich
>>|||Cool. You actually gave me another idea (BTW, right after I begged for help
on ucase, I did in search for uppercase and discover ucase
(field!myfld.Value).toupper and your method - well, at least I got
charactercasing covered :).
Anyway, my idea for the title page was to place the rectangle/control
(actually a textbox which will take a param because the title will change
based on selections) on top of the other textboxes. On the first page, the
data textboxes are not visible, then after the first page, the title textbox
is not visible but the data textboxes are visible. Does this sound possible?
I am thinking I could set the pagebreak on the rectangle and have an
expression to control the visibility of the controls. Any comments
appreciated if this is doable or not.
Thanks again,
Rich
"Steve MunLeeuw" wrote:
> I think you would want the report header rectangle at the begining of the
> report body. I see your point on the layout, nothing comes to mind...you
> can have a zero height, but then it would be pretty darn hard to add your
> textbox layout.
> Here's what I'd try:
> Make a backup copy, or use source control
> Note the top property of the topmost item in the body
> Cut everything in the body
> Add two rectangles
> Paste everything into the second rectangle
> Use the up/down arrows with everything selected in the rectangle so you get
> the same top spot noted before
> set the page break property on the first rectangle
> For the uppercase you have access to quite a bit.
> try:
> System.String.ToUpper(field!myField.Value)
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
> > section, then I place a page break there. I have placed 5 textboxes in a
> > list control. This report prints labels (real pain to set the column
> > widths
> > a row spacings just right). I don't want to upset the spacings of the
> > textboxes because it took me a long time (and a lot of tree killing and
> > ink
> > usage) to get the spacings just right in the detail section.
> >
> > May I ask where I place the rectangle?
> >
> > And to stretch this inch to a mile, I was just told that the labels have
> > to
> > be all in uppercase. In my winform app there is a textbox property for
> > charactercasing. I did not see that in the RDL. I looked at the Globals
> > collection but nothing caught my attention for forcing upper case. I
> > could
> > force upper case at the datasource level, but is there a way to
> > specify/force
> > character casing at the Report Textbox level? How to do that?
> >
> > Thank you for your help and patience. I really appreciate it.
> >
> > Thanks,
> > Rich
> >
> > "Steve MunLeeuw" wrote:
> >
> >> We use a rectangle on the first page and put our intro page there, then
> >> check the page break after property.
> >>
> >> Steve MunLeeuw
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> >> > Hello,
> >> >
> >> > I can see how to add a page header to a report in Reporting Services.
> >> > But
> >> > is there a Report Header section? What I need to do is to display a
> >> > reoprt
> >> > title on the Report Header, then force a new page after the Report
> >> > Header
> >> > section and list my data. How can something like this be accomplished
> >> > using
> >> > Reporting Services?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>|||I wouldn't do that, the text overlap will result in a compile warning and
cause layout problems in html format.
Steve MunLeeuw
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:2CC85597-4934-4E07-B5FE-FD3DF1211985@.microsoft.com...
> Cool. You actually gave me another idea (BTW, right after I begged for
> help
> on ucase, I did in search for uppercase and discover ucase
> (field!myfld.Value).toupper and your method - well, at least I got
> charactercasing covered :).
> Anyway, my idea for the title page was to place the rectangle/control
> (actually a textbox which will take a param because the title will change
> based on selections) on top of the other textboxes. On the first page,
> the
> data textboxes are not visible, then after the first page, the title
> textbox
> is not visible but the data textboxes are visible. Does this sound
> possible?
> I am thinking I could set the pagebreak on the rectangle and have an
> expression to control the visibility of the controls. Any comments
> appreciated if this is doable or not.
> Thanks again,
> Rich
> "Steve MunLeeuw" wrote:
>> I think you would want the report header rectangle at the begining of the
>> report body. I see your point on the layout, nothing comes to mind...you
>> can have a zero height, but then it would be pretty darn hard to add your
>> textbox layout.
>> Here's what I'd try:
>> Make a backup copy, or use source control
>> Note the top property of the topmost item in the body
>> Cut everything in the body
>> Add two rectangles
>> Paste everything into the second rectangle
>> Use the up/down arrows with everything selected in the rectangle so you
>> get
>> the same top spot noted before
>> set the page break property on the first rectangle
>> For the uppercase you have access to quite a bit.
>> try:
>> System.String.ToUpper(field!myField.Value)
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
>> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
>> > section, then I place a page break there. I have placed 5 textboxes
>> > in a
>> > list control. This report prints labels (real pain to set the column
>> > widths
>> > a row spacings just right). I don't want to upset the spacings of the
>> > textboxes because it took me a long time (and a lot of tree killing and
>> > ink
>> > usage) to get the spacings just right in the detail section.
>> >
>> > May I ask where I place the rectangle?
>> >
>> > And to stretch this inch to a mile, I was just told that the labels
>> > have
>> > to
>> > be all in uppercase. In my winform app there is a textbox property for
>> > charactercasing. I did not see that in the RDL. I looked at the
>> > Globals
>> > collection but nothing caught my attention for forcing upper case. I
>> > could
>> > force upper case at the datasource level, but is there a way to
>> > specify/force
>> > character casing at the Report Textbox level? How to do that?
>> >
>> > Thank you for your help and patience. I really appreciate it.
>> >
>> > Thanks,
>> > Rich
>> >
>> > "Steve MunLeeuw" wrote:
>> >
>> >> We use a rectangle on the first page and put our intro page there,
>> >> then
>> >> check the page break after property.
>> >>
>> >> Steve MunLeeuw
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I can see how to add a page header to a report in Reporting
>> >> > Services.
>> >> > But
>> >> > is there a Report Header section? What I need to do is to display a
>> >> > reoprt
>> >> > title on the Report Header, then force a new page after the Report
>> >> > Header
>> >> > section and list my data. How can something like this be
>> >> > accomplished
>> >> > using
>> >> > Reporting Services?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >>
>> >>
>> >>
>>|||Back in the office. So I will try your previous suggestion and hope for the
best.
Thank you again for your help.
Rich
"Steve MunLeeuw" wrote:
> I wouldn't do that, the text overlap will result in a compile warning and
> cause layout problems in html format.
> Steve MunLeeuw
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:2CC85597-4934-4E07-B5FE-FD3DF1211985@.microsoft.com...
> > Cool. You actually gave me another idea (BTW, right after I begged for
> > help
> > on ucase, I did in search for uppercase and discover ucase
> > (field!myfld.Value).toupper and your method - well, at least I got
> > charactercasing covered :).
> >
> > Anyway, my idea for the title page was to place the rectangle/control
> > (actually a textbox which will take a param because the title will change
> > based on selections) on top of the other textboxes. On the first page,
> > the
> > data textboxes are not visible, then after the first page, the title
> > textbox
> > is not visible but the data textboxes are visible. Does this sound
> > possible?
> >
> > I am thinking I could set the pagebreak on the rectangle and have an
> > expression to control the visibility of the controls. Any comments
> > appreciated if this is doable or not.
> >
> > Thanks again,
> > Rich
> >
> > "Steve MunLeeuw" wrote:
> >
> >> I think you would want the report header rectangle at the begining of the
> >> report body. I see your point on the layout, nothing comes to mind...you
> >> can have a zero height, but then it would be pretty darn hard to add your
> >> textbox layout.
> >>
> >> Here's what I'd try:
> >> Make a backup copy, or use source control
> >> Note the top property of the topmost item in the body
> >> Cut everything in the body
> >> Add two rectangles
> >> Paste everything into the second rectangle
> >> Use the up/down arrows with everything selected in the rectangle so you
> >> get
> >> the same top spot noted before
> >> set the page break property on the first rectangle
> >>
> >> For the uppercase you have access to quite a bit.
> >> try:
> >> System.String.ToUpper(field!myField.Value)
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> >> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
> >> > section, then I place a page break there. I have placed 5 textboxes
> >> > in a
> >> > list control. This report prints labels (real pain to set the column
> >> > widths
> >> > a row spacings just right). I don't want to upset the spacings of the
> >> > textboxes because it took me a long time (and a lot of tree killing and
> >> > ink
> >> > usage) to get the spacings just right in the detail section.
> >> >
> >> > May I ask where I place the rectangle?
> >> >
> >> > And to stretch this inch to a mile, I was just told that the labels
> >> > have
> >> > to
> >> > be all in uppercase. In my winform app there is a textbox property for
> >> > charactercasing. I did not see that in the RDL. I looked at the
> >> > Globals
> >> > collection but nothing caught my attention for forcing upper case. I
> >> > could
> >> > force upper case at the datasource level, but is there a way to
> >> > specify/force
> >> > character casing at the Report Textbox level? How to do that?
> >> >
> >> > Thank you for your help and patience. I really appreciate it.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Steve MunLeeuw" wrote:
> >> >
> >> >> We use a rectangle on the first page and put our intro page there,
> >> >> then
> >> >> check the page break after property.
> >> >>
> >> >> Steve MunLeeuw
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> >> >> > Hello,
> >> >> >
> >> >> > I can see how to add a page header to a report in Reporting
> >> >> > Services.
> >> >> > But
> >> >> > is there a Report Header section? What I need to do is to display a
> >> >> > reoprt
> >> >> > title on the Report Header, then force a new page after the Report
> >> >> > Header
> >> >> > section and list my data. How can something like this be
> >> >> > accomplished
> >> >> > using
> >> >> > Reporting Services?
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||>Here's what I'd try:
>Make a backup copy, or use source control
>Note the top property of the topmost item in the body
>Cut everything in the body
>Add two rectangles
>Paste everything into the second rectangle
>Use the up/down arrows with everything selected in the rectangle so you get
>the same top spot noted before
>set the page break property on the first rectangle
I am not quite sure what you mean about using the up/down arrows. Do you
mean the up/down arrow keys? The textboxes are located inside a list
control. The list control and the topmost textbox are at the very top of the
body position 0,0.
So I added the 2 rectangles and have copied the contents of the list control
(and all the textboxes inside the list control) to the 2nd rectangle.
Anyway, as I expected, I am having some issues with the layout. The
pagebreak for the first rectangle/title page didn't really break the page.
The data page is starting on the same page as the title page. I guess I will
have to experiment a little bit. Suggestions appreciated.
Thanks,
Rich
"Steve MunLeeuw" wrote:
> I think you would want the report header rectangle at the begining of the
> report body. I see your point on the layout, nothing comes to mind...you
> can have a zero height, but then it would be pretty darn hard to add your
> textbox layout.
> Here's what I'd try:
> Make a backup copy, or use source control
> Note the top property of the topmost item in the body
> Cut everything in the body
> Add two rectangles
> Paste everything into the second rectangle
> Use the up/down arrows with everything selected in the rectangle so you get
> the same top spot noted before
> set the page break property on the first rectangle
> For the uppercase you have access to quite a bit.
> try:
> System.String.ToUpper(field!myField.Value)
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:9B516761-4FB4-4ADF-9417-12904AB2889B@.microsoft.com...
> > Forgot to ask -- so I add a rectangle - I am guessing to the detail
> > section, then I place a page break there. I have placed 5 textboxes in a
> > list control. This report prints labels (real pain to set the column
> > widths
> > a row spacings just right). I don't want to upset the spacings of the
> > textboxes because it took me a long time (and a lot of tree killing and
> > ink
> > usage) to get the spacings just right in the detail section.
> >
> > May I ask where I place the rectangle?
> >
> > And to stretch this inch to a mile, I was just told that the labels have
> > to
> > be all in uppercase. In my winform app there is a textbox property for
> > charactercasing. I did not see that in the RDL. I looked at the Globals
> > collection but nothing caught my attention for forcing upper case. I
> > could
> > force upper case at the datasource level, but is there a way to
> > specify/force
> > character casing at the Report Textbox level? How to do that?
> >
> > Thank you for your help and patience. I really appreciate it.
> >
> > Thanks,
> > Rich
> >
> > "Steve MunLeeuw" wrote:
> >
> >> We use a rectangle on the first page and put our intro page there, then
> >> check the page break after property.
> >>
> >> Steve MunLeeuw
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:4C2F1C6A-60FF-4C27-B742-240B14387F52@.microsoft.com...
> >> > Hello,
> >> >
> >> > I can see how to add a page header to a report in Reporting Services.
> >> > But
> >> > is there a Report Header section? What I need to do is to display a
> >> > reoprt
> >> > title on the Report Header, then force a new page after the Report
> >> > Header
> >> > section and list my data. How can something like this be accomplished
> >> > using
> >> > Reporting Services?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>
