|
|
You're in the
sql server reporting services
group:value displays in one page of header only - repost
sql server reporting services:
out) an answer. Thanks for reading. I am using ReportItems in the header of a report to reference a data field in the body of the report. Often the data in other fields can be quite large (20 to 100 pages when rendered in PDF). The header value only displays on the same page that data appears in the body of the report (for example, if the field appears on pg 20 then the value in the header appears on pg 20 - but no others). 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 And of course in the body I have =First(Fields!callid.Value, "CallQuery") Any ideas? Thanks for your help. (again) Cory
Could you explain some more?
Your report is a matrix/table? You wan't the same value in the header of every page, and this is just a culumn from the matrix/table, that has the same value for every row? Do you have fixed page breaks? [quoted text, click to view] "Cory" wrote:
> Hi. I'm resposting the question because I haven't been able to get (or figure > out) an answer. Thanks for reading. > > I am using ReportItems in the header of a report to reference a data field > in the body of the report. Often the data in other > fields can be quite large (20 to 100 pages when rendered in PDF). > > The header value only displays on the same page that data appears in the > body of the report (for example, if the field appears on pg 20 then the value > in the header appears on pg 20 - but no others). > > 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 > > And of course in the body I have =First(Fields!callid.Value, "CallQuery") > > Any ideas? > > Thanks for your help. (again) > > Cory >
There are not a lot of options for data in page header. After a lot of
searching, I found that the easiest was to use a report parameter with its default value set to the desired field of a dataset and set the parameter for no prompt. In my case I had several values I needed, so I created a dataset that returned a single row for that info. -- Alphonse Giambrone Email: discuss at customdatasolutions dot us [quoted text, click to view] "Cory" <Cory@discussions.microsoft.com> wrote in message news:050D3885-F528-43EA-AC43-C8E5E6711D78@microsoft.com... > Hi. I'm resposting the question because I haven't been able to get (or > figure > out) an answer. Thanks for reading. > > I am using ReportItems in the header of a report to reference a data field > in the body of the report. Often the data in other > fields can be quite large (20 to 100 pages when rendered in PDF). > > The header value only displays on the same page that data appears in the > body of the report (for example, if the field appears on pg 20 then the > value > in the header appears on pg 20 - but no others). > > 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 > > And of course in the body I have =First(Fields!callid.Value, "CallQuery") > > Any ideas? > > Thanks for your help. (again) > > Cory > >
Thanx AVG for this tip, it was a grat help for me ... I thought I would get
mad with this basic problem
I apologize for the delay - I never received a notice that someone had
answered... The report is actually text fields in rectangles. I want the same value (one field value) on every page. Essentially this report is a one record report - that covers many pages when extracted to .pdf. The page breaks are not fixed. Essentially 95% of the fields appear on the first page and the next 5% of fields cover the next 20 pages (more or less depending on what was entered for details for the record). Any help would be great. Thanks. --Cory [quoted text, click to view] "Antoon" wrote:
> Could you explain some more? > Your report is a matrix/table? > You wan't the same value in the header of every page, and this is just a > culumn from the matrix/table, that has the same value for every row? > Do you have fixed page breaks? > > "Cory" wrote: > > > Hi. I'm resposting the question because I haven't been able to get (or figure > > out) an answer. Thanks for reading. > > > > I am using ReportItems in the header of a report to reference a data field > > in the body of the report. Often the data in other > > fields can be quite large (20 to 100 pages when rendered in PDF). > > > > The header value only displays on the same page that data appears in the > > body of the report (for example, if the field appears on pg 20 then the value > > in the header appears on pg 20 - but no others). > > > > 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 > > > > And of course in the body I have =First(Fields!callid.Value, "CallQuery") > > > > Any ideas? > > > > Thanks for your help. (again) > > > > Cory > >
That's a great idea. I'll try that as soon as I get a chance. It sounds like
exactly what I'm looking for. Thanks. --Cory [quoted text, click to view] "AVG" wrote:
> There are not a lot of options for data in page header. After a lot of > searching, I found that the easiest was to use a report parameter with its > default value set to the desired field of a dataset and set the parameter > for no prompt. In my case I had several values I needed, so I created a > dataset that returned a single row for that info. > > -- > > Alphonse Giambrone > Email: discuss at customdatasolutions dot us > > > "Cory" <Cory@discussions.microsoft.com> wrote in message > news:050D3885-F528-43EA-AC43-C8E5E6711D78@microsoft.com... > > Hi. I'm resposting the question because I haven't been able to get (or > > figure > > out) an answer. Thanks for reading. > > > > I am using ReportItems in the header of a report to reference a data field > > in the body of the report. Often the data in other > > fields can be quite large (20 to 100 pages when rendered in PDF). > > > > The header value only displays on the same page that data appears in the > > body of the report (for example, if the field appears on pg 20 then the > > value > > in the header appears on pg 20 - but no others). > > > > 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 > > > > And of course in the body I have =First(Fields!callid.Value, "CallQuery") > > > > Any ideas? > > > > Thanks for your help. (again) > > > > Cory > > > > > >
thank you, thank you, thank you for this wonderful solution...I was at my
wit's end for repeating headers, and you saved me. [quoted text, click to view] "AVG" wrote:
> There are not a lot of options for data in page header. After a lot of > searching, I found that the easiest was to use a report parameter with its > default value set to the desired field of a dataset and set the parameter > for no prompt. In my case I had several values I needed, so I created a > dataset that returned a single row for that info. > > -- > > Alphonse Giambrone > Email: discuss at customdatasolutions dot us > > > "Cory" <Cory@discussions.microsoft.com> wrote in message > news:050D3885-F528-43EA-AC43-C8E5E6711D78@microsoft.com... > > Hi. I'm resposting the question because I haven't been able to get (or > > figure > > out) an answer. Thanks for reading. > > > > I am using ReportItems in the header of a report to reference a data field > > in the body of the report. Often the data in other > > fields can be quite large (20 to 100 pages when rendered in PDF). > > > > The header value only displays on the same page that data appears in the > > body of the report (for example, if the field appears on pg 20 then the > > value > > in the header appears on pg 20 - but no others). > > > > 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 > > > > And of course in the body I have =First(Fields!callid.Value, "CallQuery") > > > > Any ideas? > > > > Thanks for your help. (again) > > > > Cory > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |