No HTML page breaks and slow expanding rows

I have a report with a single table, single grouping level, single data set and no sub-reports. It has 3 rows for a grouping header and 3 rows per dataset row of detail. The detail rows are initially hidden and can be expanded by clicking on the header +. Its a fairly standard master-detail report.

Regardless of data size, I get NO page breaks in HTML. I have the Interactive size set to 8.5x11, KeepTogether is set to False, and PageBreakAtEnd is set to False. I would like it to break based on the visible grouping rows.

As it is now, everytime you expand any section, it takes forever to reload for a larger recordset.

I know that "HTML renderer and Preview (which are soft page break renderers) will ignore page breaks of conditionally hidden items and their children.", but how do I get this report to page break? I've seen a lot of posts on this, but none that seem to have an answer.

Anyone? Can I programmatically add the soft page breaks? The report is useless as it is now.|||

Thanks to others, I found a solution. Use the query to calculate the count of headers using the dense_rank() function:

select ...

dense_rank() over ( order by cl.last_name, cl.first_name, cl.client_id ) AS ClientRank

Then add a top level grouping on the table set to "Page Break at End" with the formula:

=Ceiling(Fields!ClientRank.Value/15)

replace 15 with how many group headers you want per page.

-Dave

sql

No Fields in Page Header (and Footers)??

I'm a newbie with SSRS and I'd like to place a customer's name in the Page
Header section so that the customer's name (and ID number, and addresss)
appear at the top of every page in the right upper corner. But when I try to
put a field in the Page Header I get "Fields cannot be used in page headers
or footers."
Is MS kidding? Or am I just missing something?
So, how can I get a customer's info to appear at the top of every page?
(this is a regulated requirement).
Thanks for any help.Found this in BOL, but it seems ugly because I don't want the customer name
anywhere else in the body of the report, JUST in the Page Header. Is there
another workaround? (I still believe this is fundamental, core functionality
that should have been included)
In the expression, include references to report items on the page (for
example, you can reference a text box that contains data from a particular
field). Do not include a direct reference to fields in a data set.
You cannot refer directly to a field from a text box in a page header or
footer. (For example, you cannot use the expression =Fields!LastName.Value.)
To display field information in a page header or footer, place the field
expression in a text box in the body of the report, and then refer to that
text box in the page header or footer. The following expression displays the
contents of the first instance of a text box named TXT_LastName:
=First(ReportItems!TXT_LastName.Value)
"Don Miller" <nospam@.nospam.com> wrote in message
news:esBHBnQAIHA.1208@.TK2MSFTNGP03.phx.gbl...
> I'm a newbie with SSRS and I'd like to place a customer's name in the Page
> Header section so that the customer's name (and ID number, and addresss)
> appear at the top of every page in the right upper corner. But when I try
> to put a field in the Page Header I get "Fields cannot be used in page
> headers or footers."
> Is MS kidding? Or am I just missing something?
> So, how can I get a customer's info to appear at the top of every page?
> (this is a regulated requirement).
> Thanks for any help.
>|||Brian Welcker just had a blog post on this very subject:
http://blogs.msdn.com/bwelcker/archive/2007/06/19/marquee-moon-field-references-in-page-headers-and-footers.aspx
"Don Miller" <nospam@.nospam.com> wrote in message
news:esBHBnQAIHA.1208@.TK2MSFTNGP03.phx.gbl...
> I'm a newbie with SSRS and I'd like to place a customer's name in the Page
> Header section so that the customer's name (and ID number, and addresss)
> appear at the top of every page in the right upper corner. But when I try
> to put a field in the Page Header I get "Fields cannot be used in page
> headers or footers."
> Is MS kidding? Or am I just missing something?
> So, how can I get a customer's info to appear at the top of every page?
> (this is a regulated requirement).
> Thanks for any help.
>|||Thanks for the direction to Welcker's blog. I also tried putting the
field-associated textboxes in the report body (even though I didn't want
them there), referenced them in the header, and then hid them (visibility =false) and that seemed to work too.
Welcker's hidden parameters, referencing a field in the body, hiding
textboxes in the body, etc. are all non-obvious and non-intuitive HACKS.
I've spent at least an hour or so researching this issue, probably will go
back to the report later and forgot what all this was about or how I came up
with it. With Crystal Reports, it took all of five minutes to figure out,
was intuitive, and apparently they got around any issues MS encountered
('what happens when it grows?')
Same thing for Report vs. Page Headers. They exist as separate entities in
CR but rely on yet another hack to recreate in SSRS. And this is all in my
first hour with SSRS trying to migrate an existing CR report!
Such simple fundamental things in a report now require "programming" and
programmers. Good thing for MS the price is right :(
"Mike G." <m4053946_noSpam_@.yahoo.com> wrote in message
news:O89Kb3QAIHA.4592@.TK2MSFTNGP03.phx.gbl...
> Brian Welcker just had a blog post on this very subject:
> http://blogs.msdn.com/bwelcker/archive/2007/06/19/marquee-moon-field-references-in-page-headers-and-footers.aspx
> "Don Miller" <nospam@.nospam.com> wrote in message
> news:esBHBnQAIHA.1208@.TK2MSFTNGP03.phx.gbl...
>> I'm a newbie with SSRS and I'd like to place a customer's name in the
>> Page Header section so that the customer's name (and ID number, and
>> addresss) appear at the top of every page in the right upper corner. But
>> when I try to put a field in the Page Header I get "Fields cannot be used
>> in page headers or footers."
>> Is MS kidding? Or am I just missing something?
>> So, how can I get a customer's info to appear at the top of every page?
>> (this is a regulated requirement).
>> Thanks for any help.
>|||:)
Report headers not being a separate entity did take a little getting used
to, but I wouldn't call it a hack to recreate them...
Mike
"Don Miller" <nospam@.nospam.com> wrote in message
news:eRs0UJRAIHA.4584@.TK2MSFTNGP03.phx.gbl...
> Thanks for the direction to Welcker's blog. I also tried putting the
> field-associated textboxes in the report body (even though I didn't want
> them there), referenced them in the header, and then hid them (visibility
> = false) and that seemed to work too.
> Welcker's hidden parameters, referencing a field in the body, hiding
> textboxes in the body, etc. are all non-obvious and non-intuitive HACKS.
> I've spent at least an hour or so researching this issue, probably will go
> back to the report later and forgot what all this was about or how I came
> up with it. With Crystal Reports, it took all of five minutes to figure
> out, was intuitive, and apparently they got around any issues MS
> encountered ('what happens when it grows?')
> Same thing for Report vs. Page Headers. They exist as separate entities in
> CR but rely on yet another hack to recreate in SSRS. And this is all in my
> first hour with SSRS trying to migrate an existing CR report!
> Such simple fundamental things in a report now require "programming" and
> programmers. Good thing for MS the price is right :(
>
> "Mike G." <m4053946_noSpam_@.yahoo.com> wrote in message
> news:O89Kb3QAIHA.4592@.TK2MSFTNGP03.phx.gbl...
>> Brian Welcker just had a blog post on this very subject:
>> http://blogs.msdn.com/bwelcker/archive/2007/06/19/marquee-moon-field-references-in-page-headers-and-footers.aspx
>> "Don Miller" <nospam@.nospam.com> wrote in message
>> news:esBHBnQAIHA.1208@.TK2MSFTNGP03.phx.gbl...
>> I'm a newbie with SSRS and I'd like to place a customer's name in the
>> Page Header section so that the customer's name (and ID number, and
>> addresss) appear at the top of every page in the right upper corner. But
>> when I try to put a field in the Page Header I get "Fields cannot be
>> used in page headers or footers."
>> Is MS kidding? Or am I just missing something?
>> So, how can I get a customer's info to appear at the top of every page?
>> (this is a regulated requirement).
>> Thanks for any help.
>>
>

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?
> >>
> >>
> >>
>
>