ReportViewer graphics and charts do not display in aspx page

Hi,
I'm trying to display a basic report in an aspx page using the ReportViewer
component. The report displays but a graphic and simple chart are not
displayed. It seems like it has had good try because link regions in the
graph do actually work, but no visual chart.
Any ideas!Update on below
As I said it seems to be giving the display a good go, and I have managed to
intermitently display the chart graphic (I think by viewing the report in
report manager first), but refresh the page and it disapears again. Follow a
link from the report and then use the back button and it displays again. IE
pants or what!
Only hint is that when the chart is not display the properties say Type: Not
Available, when it is displayed it says Type: PNG Image. I have seen the
.gif displayed once, but don't seem to be able to do it again - same
properties - Type: Not Available.
Seems to be some info about on this type of issue, that is - controls,
security and encoding but nothing definitive.
Any assistance greatly appreciated
Thanks
Laurence
"Laurence" <laurence.pull@.silversands.co.uk> wrote in message
news:OmHV2yb4EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm trying to display a basic report in an aspx page using the
> ReportViewer component. The report displays but a graphic and simple chart
> are not displayed. It seems like it has had good try because link regions
> in the graph do actually work, but no visual chart.
> Any ideas!
>|||I am also having the same issue... If I restart IIS( iisreset ) the images
would start diplaying but would disappear after couple of minutes(in most
cases the third refresh would kill the images)
--Sarvan
"Laurence" wrote:
> Update on below
> As I said it seems to be giving the display a good go, and I have managed to
> intermitently display the chart graphic (I think by viewing the report in
> report manager first), but refresh the page and it disapears again. Follow a
> link from the report and then use the back button and it displays again. IE
> pants or what!
> Only hint is that when the chart is not display the properties say Type: Not
> Available, when it is displayed it says Type: PNG Image. I have seen the
> ..gif displayed once, but don't seem to be able to do it again - same
> properties - Type: Not Available.
> Seems to be some info about on this type of issue, that is - controls,
> security and encoding but nothing definitive.
> Any assistance greatly appreciated
> Thanks
> Laurence
> "Laurence" <laurence.pull@.silversands.co.uk> wrote in message
> news:OmHV2yb4EHA.3236@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I'm trying to display a basic report in an aspx page using the
> > ReportViewer component. The report displays but a graphic and simple chart
> > are not displayed. It seems like it has had good try because link regions
> > in the graph do actually work, but no visual chart.
> >
> > Any ideas!
> >
>
>

ReportViewer error with SSRS2005 on a non-default website

I am facing a problem when trying to access a report using ReportViewer
ASP.NET 2.0 WebForms control. The reportviewer displays an error "The attempt
to connect to the report server failed. Check your connection information and
that the report server is a compatible version. The request failed with HTTP
status 404: Not Found". When I try to access any of the SSRS2005 Web Service
method (For example: ListChildren) with a proxy, I get an error "The request
failed with HTTP status 404: Not Found."
Here are the exception details:
-----
{"The request failed with HTTP status 404: Not Found."}
[System.Net.WebException]: {"The request failed with HTTP status 404:
Not Found."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: null
Message: "The request failed with HTTP status 404: Not Found."
Source: "Test.MDC.CRI.SSRS2005.Helper"
StackTrace: " at
Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
Boolean recursive, CatalogItem[]& items) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
SortedList& childItems) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
at BrowseFolders.Page_Load(Object sender, EventArgs e) in
c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e)\r\n at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)"
TargetSite: {Boolean GetChildren(System.String, Boolean,
Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
-----
Response object of System.Net.WebException:
-----
{System.Net.HttpWebResponse}
[System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
ContentLength: 629
ContentType: "text/html"
Headers: {Pragma: no-cache
Proxy-Connection: Keep-Alive
Connection: Keep-Alive
Content-Length: 629
Cache-Control: no-cache
Content-Type: text/html
}
IsFromCache: false
IsMutuallyAuthenticated: false
ResponseUri:
{http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
-----
My Report Server configuration:
Web Server: Windows 2003 Standard SP1
SQL Server: SQL Enterprise 2005 SP1
Report Server Web Site: Installed on a non-default web site, running under
ASP.NET 2.0, part of app pool with identity NetWork Service
Reporting Services Windows Service running under Local System account
Identity of the web site: Anonymous access disabled, Windows Authentication
checked
Reports virtual directory - Integrated Windows Authentication, Anonymous
disabled
ReportServer virtual directory - Integrated Windows Authentication,
Anonymous disabled
Patches:
1. Disable loopback entry set as per MSKB article:
http://support.microsoft.com/kb/896861/
2. RSWebApplication.config changed as below:
Before:
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
After:
<UI>
<ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
The following sites runs OK.
- http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
to this using VS2005 designer. Currently displays the version Microsoft SQL
Server Reporting Services Version 9.00.2047.00)
- http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
able to browse folders)
If you can help me to fix the issue, it would be of great help. Struggling
for few days already with this issue.
Thanks,
Live_Love_LaughOne more thing to mention:
After playing with SSRS2005 for few days, I figured out that if the
WebApplication is running of file system(ASP.NET 2.0 feature), rather than on
a website I could able to see the results through report viewer control but
as soon as I put it on IIS, I am getting the error "The attempt to connect to
the report server failed. Check your connection information and that the
report server is a compatible version. The request failed with HTTP status
404: Not Found."
Any ideas?
Thanks,
Live_Love_Laugh
"Live_Love_Laugh" wrote:
> I am facing a problem when trying to access a report using ReportViewer
> ASP.NET 2.0 WebForms control. The reportviewer displays an error "The attempt
> to connect to the report server failed. Check your connection information and
> that the report server is a compatible version. The request failed with HTTP
> status 404: Not Found". When I try to access any of the SSRS2005 Web Service
> method (For example: ListChildren) with a proxy, I get an error "The request
> failed with HTTP status 404: Not Found."
> Here are the exception details:
> -----
> {"The request failed with HTTP status 404: Not Found."}
> [System.Net.WebException]: {"The request failed with HTTP status 404:
> Not Found."}
> Data: {System.Collections.ListDictionaryInternal}
> HelpLink: null
> InnerException: null
> Message: "The request failed with HTTP status 404: Not Found."
> Source: "Test.MDC.CRI.SSRS2005.Helper"
> StackTrace: " at
> Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
> Boolean recursive, CatalogItem[]& items) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
> parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
> SortedList& childItems) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
> parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
> at BrowseFolders.Page_Load(Object sender, EventArgs e) in
> c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
> 33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
> Object o, Object t, EventArgs e)\r\n at
> System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
> EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
> Boolean includeStagesAfterAsyncPoint)"
> TargetSite: {Boolean GetChildren(System.String, Boolean,
> Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
> -----
> Response object of System.Net.WebException:
> -----
> {System.Net.HttpWebResponse}
> [System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
> base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
> ContentLength: 629
> ContentType: "text/html"
> Headers: {Pragma: no-cache
> Proxy-Connection: Keep-Alive
> Connection: Keep-Alive
> Content-Length: 629
> Cache-Control: no-cache
> Content-Type: text/html
> }
> IsFromCache: false
> IsMutuallyAuthenticated: false
> ResponseUri:
> {http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
> -----
> My Report Server configuration:
> Web Server: Windows 2003 Standard SP1
> SQL Server: SQL Enterprise 2005 SP1
> Report Server Web Site: Installed on a non-default web site, running under
> ASP.NET 2.0, part of app pool with identity NetWork Service
> Reporting Services Windows Service running under Local System account
> Identity of the web site: Anonymous access disabled, Windows Authentication
> checked
> Reports virtual directory - Integrated Windows Authentication, Anonymous
> disabled
> ReportServer virtual directory - Integrated Windows Authentication,
> Anonymous disabled
> Patches:
> 1. Disable loopback entry set as per MSKB article:
> http://support.microsoft.com/kb/896861/
> 2. RSWebApplication.config changed as below:
> Before:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> After:
> <UI>
> <ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> The following sites runs OK.
> - http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
> to this using VS2005 designer. Currently displays the version Microsoft SQL
> Server Reporting Services Version 9.00.2047.00)
> - http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
> able to browse folders)
>
> If you can help me to fix the issue, it would be of great help. Struggling
> for few days already with this issue.
> Thanks,
> Live_Love_Laugh

ReportViewer - Drill through reports not displaying completely

Hi,
I am developing a web page that used the ReportViewer Control for displaying
reports from our report Server. The Initial Report Displays just fine but
when there is a link on a report that drillsthrough to another report the new
report does not completely display correctly. Tables of Text appear find but
the graph images don't appear. If I look at the source for the report with
the broken images I notice that the ReportSession is different. Not sure if
it should be or if all reports in the report viewer should use the same
Reportsession' If I Click on the View Report button I receive an error
referencing yet another ReportSession. These reports all work just fine in
Report Manager so I'm thinking I need to set a parameter in the control'
I have tried setting the executionID but this seems to make no difference..
Can you help? Is there a Working sample of using the Control available'
Thanks
JasonHello Jason,
It seems to be a known issue caused by that combination of the Report
server and viewer default settings conflicting with rendering drill-through
reports. You may try the following methods to see if it helps:
1. Change the configuration information in the ReportServer database to not
use session cookies (Set the UseSessionCookies record value to false in
ReportServer.dbo.ConfigurationInfo).
2. Set the AsyncRendering property of the ReportViewer control to false (on
ReportViewer.aspx.cs).
If you have any further updates or comments, please feel free to let's
know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Peter,
Is there a fix in the works? or is this something to look for in SQL 08
Reporting Server'
""Peter Yang[MSFT]"" wrote:
> Hello Jason,
> It seems to be a known issue caused by that combination of the Report
> server and viewer default settings conflicting with rendering drill-through
> reports. You may try the following methods to see if it helps:
> 1. Change the configuration information in the ReportServer database to not
> use session cookies (Set the UseSessionCookies record value to false in
> ReportServer.dbo.ConfigurationInfo).
> 2. Set the AsyncRendering property of the ReportViewer control to false (on
> ReportViewer.aspx.cs).
> If you have any further updates or comments, please feel free to let's
> know. Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Jason,
Since the issue is actually a reportviewer related issue you may want to
check if the workarounds I mentioned might work.
I have forwarded your feedback to the proper channel but product team may
evaluate the impact and consider fix this issue on client or server side.
Also, I encourage you submit via the link below and our product team would
like to hear your voice directly:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
======================================================PLEASE NOTE:
This newsgroup service currently provides a one business day response time,
Monday through Friday, excluding holidays.
======================================================When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Reportng Services #Error in IIF

I have this very weird problem arising when I try to use the following
function in Reporting Services 2000:
IIf ( 4=4 , 0 , 4/0) - Displays #Error
IIf ( 4=4 , 0 , 4/1) - Displays 0
Can somone please explain why this occurs and any work around for it.
In the Actual scenario I'm doing something like this:
IIf ( x=0, 0, y/x)
When x is 0 it gives #Error
When it is not it displays the value of y/x
Thanks a lotHi,
Actually the reporting services evaluates all values irrespective of whether
that value is reached or not. Even i found this weird.
In your case, it tries to evaluate 4/0 which produces an error and hence the
result.
Bye
Sumit Pilankar
<gogulaa@.gmail.com> wrote in message
news:1133251786.777196.173580@.z14g2000cwz.googlegroups.com...
>I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot
>|||You are receiving this error because the 4/0 is an illegal math function.
Cannot divide by zero.
"gogulaa@.gmail.com" wrote:
> I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot
>|||The way we get around it is to create a function in the report and call that
passing the X and Y parameters.
Dale
<gogulaa@.gmail.com> wrote in message
news:1133251786.777196.173580@.z14g2000cwz.googlegroups.com...
>I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot
>|||Not the first time I've seen this with SQLRS and don't know why it
happens as your logic is sound.
Try something like
=IIF( x != 0, y/x, 0) or maybe
=IIF( x= 0, x, y/x) or even
=IIF( (x=0) = "True", 0, y/x)
and see if one of those helps.
Or for some adventure, try inserting this custom code under report
properties then just use the custom function populated with your x and
y values. "=DivideBy(y,x)" This has never failed me.
Public function DivideBy (exp1,exp2)
If exp2 = 0
DivideBy = 0
else
DivideBy = exp1/exp2
end if
end function
gogulaa@.gmail.com wrote:
> I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot

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