Page Footer Expression Problem

[Adeel]

I am creating a report programmitically and all of the things working properly, but I have a textbox which has a expression like below:

txtBox.Value = "=Sum(mydatafield)";

The report accepts the expression but didn't show the expression result. More clearly, it is not showing the sum at page level. Although the field is visible = true, every thing is correctly implemented. However I apply the same thing at group level it is working properly and also showing the group sum. Kindly give me the hint to resolve this problem. This is urgent requirement.

Thanks,

Adeel Ahmed

[Svetoslav]

Hello Adeel,

Currently it is not possible to use the data source fields in the page sections. For more information please see Report Life Cycle and Understanding Report Sections topics in the Telerik Reporting documentation.

Best wishes,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Adeel]

What should I do if I need to show the sum of a specific field on every page of the report?
Is it possible in Telerik Reporting or not?

[Svetoslav]

Hello Adeel,

You may consider using an unbound group (without any grouping criteria) with group sections with print on every page turned on.

Another option is to use a subreport for the main data while the master report contains only one detail section as high as the page (paper height - top margin - bottom margin). On top of the detail section put all items you want to appear in the page header; at bottom - for the page footer; and the subreport in between.

All the best,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Raido Valgeväli]

I would suggest the trick:
* place the grand total field (say textBox3) to Report Footer and set .Visible=false
* place an empty text to Page Footer (say textBox4)
* for the textBox3 attach the ItemDataBound event in which you can set the Text value to textBox4
3 lines of code, see below :)

One thing that might create confusion here is that (of course) you can't get the Text value from Reporting.TextBox that you use while designing but you have to use Reporting.Processing.TextBox that is nicely handed to you through ItemDataBound event's "sender".
http://www.telerik.com/help/reporting/understanding-events.html

I agree it's sad that without tricking you can't place totals (or any aggregate or anything databound) to page header / page footer.
Sometimes you need the grand total on top or bottom of every page. Or even more often - your report is on one page only and you need the total in certain position at the bottom of the page (not where the outrolled detail rows happen to end).

	public partial class Report1 : Report
	{
	public Report1()
	{
	InitializeComponent();
	textBox3.ItemDataBound += tb3_ItemDataBound;
	}
	private void tb3_ItemDataBound(object sender, System.EventArgs e)
	{
	Telerik.Reporting.Processing.TextBox tb3p = (Telerik.Reporting.Processing.TextBox)sender;
	textBox4.Value = tb3p.Text;
	}
	}

[Steve]

Hello Raido,

It is possible to add data items to page sections for quite some time now (Q2 2008 if we need to be exact). Note however that all data fields must be aggregated, even if the data source returns only one row i.e. their usage is similar to the report header/footer now.

Regards,
Steve
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[amit]

Hi friend try this way

LastName is the databound field

=First(ReportItems("LastName").Value)

for using data fields in Report Header and Report Footer

Thanks
Amit