ReportItems data value displays in first page header only

I am using ReportItems in the header of a report to reference the data field
for the id of the report (based on a request in our application that
represents the value of the call_id field). This value only displays on the
first page of the report - no subsequent pages. Often the data in other
fields can be quite large (20 to 100 pages when rendered in PDF).
It is because the header is "looking" for that field value on every page -
and it only appears towards the top of the report. I verified this by moving
the data field to the bottom of the report - and then the value only appears
on the last page of the report.
I want this data to appear in the header of every page.
I have tried the following in the header:
=First(ReportItems!callid.value)
=ReportItems!callid.value
Any ideas?
Thanks for your help.
CoryMove the item into the body of the report and it should work...using First()
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Cory" <Cory@.discussions.microsoft.com> wrote in message
news:BD7AD9E4-F18D-4136-AFBC-CBB37FD221CF@.microsoft.com...
>I am using ReportItems in the header of a report to reference the data
>field
> for the id of the report (based on a request in our application that
> represents the value of the call_id field). This value only displays on
> the
> first page of the report - no subsequent pages. Often the data in other
> fields can be quite large (20 to 100 pages when rendered in PDF).
> It is because the header is "looking" for that field value on every page -
> and it only appears towards the top of the report. I verified this by
> moving
> the data field to the bottom of the report - and then the value only
> appears
> on the last page of the report.
> I want this data to appear in the header of every page.
> I have tried the following in the header:
> =First(ReportItems!callid.value)
> =ReportItems!callid.value
> Any ideas?
> Thanks for your help.
> Cory
>|||Wayne, just sent you an email. Not sure how often you check your email.
Check it out when you have a chance.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:e5GNpSvjFHA.3144@.TK2MSFTNGP12.phx.gbl...
> Move the item into the body of the report and it should work...using
> First()
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Cory" <Cory@.discussions.microsoft.com> wrote in message
> news:BD7AD9E4-F18D-4136-AFBC-CBB37FD221CF@.microsoft.com...
>>I am using ReportItems in the header of a report to reference the data
>>field
>> for the id of the report (based on a request in our application that
>> represents the value of the call_id field). This value only displays on
>> the
>> first page of the report - no subsequent pages. Often the data in other
>> fields can be quite large (20 to 100 pages when rendered in PDF).
>> It is because the header is "looking" for that field value on every
>> page -
>> and it only appears towards the top of the report. I verified this by
>> moving
>> the data field to the bottom of the report - and then the value only
>> appears
>> on the last page of the report.
>> I want this data to appear in the header of every page.
>> I have tried the following in the header:
>> =First(ReportItems!callid.value)
>> =ReportItems!callid.value
>> Any ideas?
>> Thanks for your help.
>> Cory
>|||Hi Wayne,
That is what I have - The item that is being referenced is in the body of
the report - and uses first to retrieve the data from the database... and the
reportitems reference in the header I've tried both first and no prefix...
But the reportitems reference in the header only appears on the same page
that the item being referenced appears.
So, if I have the body item on the 5th page then the header displays the
value on the 5th page. If on the 20th page then it will appear there and so
on.
Thanks again for your help.
--Cory
"Wayne Snyder" wrote:
> Move the item into the body of the report and it should work...using First()
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Cory" <Cory@.discussions.microsoft.com> wrote in message
> news:BD7AD9E4-F18D-4136-AFBC-CBB37FD221CF@.microsoft.com...
> >I am using ReportItems in the header of a report to reference the data
> >field
> > for the id of the report (based on a request in our application that
> > represents the value of the call_id field). This value only displays on
> > the
> > first page of the report - no subsequent pages. Often the data in other
> > fields can be quite large (20 to 100 pages when rendered in PDF).
> >
> > It is because the header is "looking" for that field value on every page -
> > and it only appears towards the top of the report. I verified this by
> > moving
> > the data field to the bottom of the report - and then the value only
> > appears
> > on the last page of the report.
> >
> > I want this data to appear in the header of every page.
> >
> > I have tried the following in the header:
> > =First(ReportItems!callid.value)
> > =ReportItems!callid.value
> >
> > Any ideas?
> >
> > Thanks for your help.
> >
> > Cory
> >
>
>|||Hi Cory,
I have the same problem, can you please help me if you got the solution.
Thanks in advance.
"Cory" wrote:
> I am using ReportItems in the header of a report to reference the data field
> for the id of the report (based on a request in our application that
> represents the value of the call_id field). This value only displays on the
> first page of the report - no subsequent pages. Often the data in other
> fields can be quite large (20 to 100 pages when rendered in PDF).
> It is because the header is "looking" for that field value on every page -
> and it only appears towards the top of the report. I verified this by moving
> the data field to the bottom of the report - and then the value only appears
> on the last page of the report.
> I want this data to appear in the header of every page.
> I have tried the following in the header:
> =First(ReportItems!callid.value)
> =ReportItems!callid.value
> Any ideas?
> Thanks for your help.
> Cory
>|||Hi. No unfortunately nobody did respond with a really helpful suggestion.
However, I did find something elsewhere where someone suggested grabbing the
value and then setting it as a report parameter which supposedly can be
displayed on every page.
I haven't yet had time to test it though... as I've been pulled in a
different direction.
If you should happen to find something - or if someone else has a good
suggestion I'd love to hear it!
Thanks.
--Cory
"Anitha Naidu" wrote:
> Hi Cory,
> I have the same problem, can you please help me if you got the solution.
> Thanks in advance.
>
>
> "Cory" wrote:
> > I am using ReportItems in the header of a report to reference the data field
> > for the id of the report (based on a request in our application that
> > represents the value of the call_id field). This value only displays on the
> > first page of the report - no subsequent pages. Often the data in other
> > fields can be quite large (20 to 100 pages when rendered in PDF).
> >
> > It is because the header is "looking" for that field value on every page -
> > and it only appears towards the top of the report. I verified this by moving
> > the data field to the bottom of the report - and then the value only appears
> > on the last page of the report.
> >
> > I want this data to appear in the header of every page.
> >
> > I have tried the following in the header:
> > =First(ReportItems!callid.value)
> > =ReportItems!callid.value
> >
> > Any ideas?
> >
> > Thanks for your help.
> >
> > Cory
> >