 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / January 2005Use a field in Page footers
Hi all, I need to be able to get data from a query with parameters and use one of the fields returned in the Page Footer of a report. Any ideas, I know it is probably fairly simple but I am new to this. TIA Andy In the page footer section, just reference Fields!columnName.Value > Hi all, > [quoted text clipped - 6 lines] > > Andy Hi I tried that but get error: Fields cannot be used in page headers or footers. Am I doing something wrong "G" <brian.grant@si-intl-kc.com> wrote in news:#LhfsiSiEHA.1652 @TK2MSFTNGP09.phx.gbl: > Fields!columnName.Value Aha, you cannot directly reference Fields in a footer. Found this in the online help: You cannot refer directly to a field in 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 the LastName text box on the page: =First(ReportItems!LastName.Value)That should get you what you want. > Hi > [quoted text clipped - 8 lines] > > > Fields!columnName.Value Aha, I see this now produces the correct data but for some reason it only appears on the page where the textbox appears, does that mean I have to put 3 testbox's all invisible in different positions in the body of the report to appear of each page footer, because the report body is 59cm long so it spans 3 pages. But if I did this I could not use =First(ReportItems!LastName.Value) as the subsequent textbox's would not be called LastName!! Help!!! TIA Andy "G" <brian.grant@si-intl-kc.com> wrote in news:ea4hztSiEHA.1356 @TK2MSFTNGP09.phx.gbl: > =First(ReportItems!LastName.Value) Not sure if you ever fixed this but I managed it by : - Set up a new Parameter named : PageFooterText - Set it's default value "From query" and to the dataset and field that you want. - Set it's prompt to an empty string i.e. "". This supresses the reporting engine from asking the user for it's value. - use it in the footer in the usual Parameters!PageFooter.Value fashion Good luck R. > Aha, I see this now produces the correct data but for some reason it only > appears on the page where the textbox appears, does that mean I have to put [quoted text clipped - 17 lines] > > > =First(ReportItems!LastName.Value) This solution works pefectly fine for String and Integer datatypes. But I have a report in which I need to display an Image coming from Database. Is there any way of achieving this? Please help ... Sreejith Found a solution here. http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?& query=image+field+in+footer&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.s qlserver.reportingsvcs&p=1&tid=b4325c33-826b-4329-8f6e-2fde154a1e6a&mid=644ccf05 -c3cf-40f6-8949-7311fc4b9892 Sorry for bothering. Sreejith > This solution works pefectly fine for String and Integer datatypes. But I > have a report in which I need to display an Image coming from Database. Is > there any way of achieving this? Please help ... > > Sreejith |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.