or
I need to create a report with a data section that appears only at the bottom of the first page of a PDF report. From reading other posts it appears that the only way to do this is to put the fields into the page footer and then add values to the fields in ItemDataBound event of the footer. I've tried doing this, but the data doesn't appear on the first page, only on subsequent pages. Any ideas why this isn't working? Is this the proper way to go about this?
Here's a simplified view of what I'm doing.
private void pageFooter_ItemDataBound(object sender, EventArgs e)
{
barcode1.Value = "123456";
barcode2.Value = "234567";
barcode3.Value = "345678";
barcode4.Value = "456789";
barcode5.Value = "567890";
barcode6.Value = "678901";
barcode7.Value = "789012";
barcode8.Value = "890123";
barcode9.Value = "901234";
}
I also want to suppress the display on pages other than page one. Can I toggle the visibility with conditional formatting based on PageNumber or is there a better way?
Thanks,
John
CREATE
PROCEDURE
GetSalesValue
AS
SELECT
DATENAME(mm, Sales.SaleOrderDate)
AS
MonthOfSale ,
SUM
(Quotes.NETPrice)
AS
SalesValue ,
Source.Source
FROM
Quotes
INNER
JOIN
Sales
ON
Quotes.QuoteId = Sales.QuoteId
INNER
JOIN
Enquiry
ON
Quotes.EnquiryId = Enquiry.EnquiryId
INNER
JOIN
Source
ON
Enquiry.SourceId = Source.SourceId
GROUP
BY
Sales.SaleOrderDate,
Year
(Sales.SaleOrderDate),
Source.Source