Wednesday, July 6, 2011

Adding a Dataset value to a TextBox in Header or Footer of the report

Is this possible?
No, it is not. When you do this and try to view the report you get an error stating that cannot add dataset values to report header or footer.

Is there a way to overcome this?.
Fortunately there is. How?.

You can add a textbox to the report body and you can set the expression of that textbox to a dataset value. Then you can assign this text box as a report parameter to the text box in your header. works like a charm.

However if you want the footer or header to be repeating in all the pages of the report you need to add columns to the report table. Then you need to hide them and assign to report header or footer textboxes.

No comments:

Post a Comment

Retrieving Calendar of a Bookable Resource in Dynamics

There are occasions where we need to retrieve working days and working times of a resource in Dynamics grammatically. This is quite possible...