No fields allowed in header/footer?!?

I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
designer friendly interface. So please be patient & simplistic with your
responses.
If you can't place fields in page headers or footers how can you get fields
to repeat on multi-page forms, like shop travelers and packing lists, which
repeat customer and order info on every page but changes line item data?Two ways:
Rather than using a page header/footer for these section breaks, use a group
header and/or footer in a table. You can set group headers to to force a
page break or to repeat on a new page.
If you must show data in a page header or footer, add a hidden field-bound
textbox to the main report and then reference it from an item in the header
or footer (ReportItems!SalesTotal.Value). This isn't elegant but it works
for most things.
Paul Turley, MCSD, MCDBA, MSF, MCT
nospam at scout-master.com
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||You can reference the fields in the reports to do so.
HTH,, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"rs_newbie" <rsnewbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||That is right; you cannot place fields in a page header or footer. To get
round this, put a textbox in the header and use a formula that references a
textbox with the field in the body of the report. For example:
=ReportItems!OrderNumber.Value
The above expression can be placed in the page header or footer. It is
referencing a textbox called OrderNumber. If the textbox displays the field
you want, then the value is also displayed in the textbox that has the above
formula.
Charles Kangai, MCDBA, MCT
"rs_newbie" wrote:
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get fields
> to repeat on multi-page forms, like shop travelers and packing lists, which
> repeat customer and order info on every page but changes line item data?|||Thanks everyone. That works great for a few fields. How about whole tables?
"Charles Kangai" wrote:
> That is right; you cannot place fields in a page header or footer. To get
> round this, put a textbox in the header and use a formula that references a
> textbox with the field in the body of the report. For example:
> =ReportItems!OrderNumber.Value
> The above expression can be placed in the page header or footer. It is
> referencing a textbox called OrderNumber. If the textbox displays the field
> you want, then the value is also displayed in the textbox that has the above
> formula.
> Charles Kangai, MCDBA, MCT
> "rs_newbie" wrote:
> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> > designer friendly interface. So please be patient & simplistic with your
> > responses.
> >
> > If you can't place fields in page headers or footers how can you get fields
> > to repeat on multi-page forms, like shop travelers and packing lists, which
> > repeat customer and order info on every page but changes line item data?|||Generally speaking, you don't need to do this as you can have as many tables
as you want in the body of the report. What is the specific scenario?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> Thanks everyone. That works great for a few fields. How about whole
> tables?
> "Charles Kangai" wrote:
>> That is right; you cannot place fields in a page header or footer. To get
>> round this, put a textbox in the header and use a formula that references
>> a
>> textbox with the field in the body of the report. For example:
>> =ReportItems!OrderNumber.Value
>> The above expression can be placed in the page header or footer. It is
>> referencing a textbox called OrderNumber. If the textbox displays the
>> field
>> you want, then the value is also displayed in the textbox that has the
>> above
>> formula.
>> Charles Kangai, MCDBA, MCT
>> "rs_newbie" wrote:
>> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
>> > designer friendly interface. So please be patient & simplistic with
>> > your
>> > responses.
>> >
>> > If you can't place fields in page headers or footers how can you get
>> > fields
>> > to repeat on multi-page forms, like shop travelers and packing lists,
>> > which
>> > repeat customer and order info on every page but changes line item
>> > data?|||Why the reference doesnt function after a pagebreak?
scenario:
You put the hidden field at the top of the body.
Then you insert a header-field that refere to the hidden field.
Cause the report has a lot of data there will be 2 pages and also 2 header.
The reportItem!Name.Value on the SECOND page has no Value.
Why?
thy, Michele
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Because there is no instance of the textbox on the second page. The
ReportItems collection in the page header / footer refer to the items on the
page. I understand this is a limitation. Instead of using the header, could
you use an outer list that repeats on new pages?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michele" <Michele@.discussions.microsoft.com> wrote in message
news:EB1F86BB-A2C6-4487-9C25-DC9ADAD69EB3@.microsoft.com...
> Why the reference doesnt function after a pagebreak?
> scenario:
> You put the hidden field at the top of the body.
> Then you insert a header-field that refere to the hidden field.
> Cause the report has a lot of data there will be 2 pages and also 2
> header.
> The reportItem!Name.Value on the SECOND page has no Value.
> Why?
> thy, Michele
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||The problem is that the body has 5 tables and the detail in one of the tables
can span several pages. The other tables don't repeat after page 1. This is a
problem because the information that makes the job traceable is lost . All
you get is a continuation of the detail from the current table with page
header/footer info.
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Can you put the tables in a list and say 'repeat on new page'? If they are
not bound to the same data source, you will need to use a subreport.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> The problem is that the body has 5 tables and the detail in one of the
> tables
> can span several pages. The other tables don't repeat after page 1. This
> is a
> problem because the information that makes the job traceable is lost . All
> you get is a continuation of the detail from the current table with page
> header/footer info.
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||Hello-
Best I can tell this technique (ReportItems!SalesTotal.Value) only
displays data on the first page... fairly worthless for my purposes
anyway...
JCF|||It displays data on every page in which ReportItems!SalesTotal.Value exists.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"CodeFester" <fischerjc@.hotmail.com> wrote in message
news:1114809018.195146.312890@.f14g2000cwb.googlegroups.com...
> Hello-
> Best I can tell this technique (ReportItems!SalesTotal.Value) only
> displays data on the first page... fairly worthless for my purposes
> anyway...
> JCF
>|||Thanks Brian!
The list is working great in Visual Studio. The Preview ,Run and Print
Preview all show a proper rendering of the reports.
However, after deployment, the Report Manager shows several blank data
fields. The print preview is not pulling in the 0.000in margins that I've set
in my report properties. The settings are all 0.500in. If I change them to 0
the preview shows the missing data, and so does the printout. Any ideas?
Is there a way to use the same Preview/Print Preview in Report Manager that
Visual Studio uses?
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>|||Do you have an example of how to get a specific table to repeat on every page
as well as individual fields (that change depending on the group) from a
table?
I'm pretty new to SRS and I need to get up to speed really fast.
Thanks in advance.
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>