Hi I have a textbox in my header which I need to fill data from my dataset. However it does not allow me to fill from dataset in the header or footer. How do I do this ?
you should define a Parameter for your report from Layout section , then ( right click insome empty place in outeside of your report table , you'll see a context menu with 4 Items , select the Report Parameter ) ,then create a Textbox inside your Header
or Footer , then right click onthe textbox and and select Expression , then put the following code in it .
Member
3 Points
8 Posts
Header footer values
Sep 19, 2007 05:26 AM|magik@net|LINK
Hi I have a textbox in my header which I need to fill data from my dataset. However it does not allow me to fill from dataset in the header or footer. How do I do this ?
Member
120 Points
49 Posts
Re: Header footer values
Sep 19, 2007 07:44 AM|anamika_k|LINK
To work around this, place a textbox in your report call it tb_value, set its hidden property to true. Drag and drop the db value in the textbox.
In your header/footer place a textbox go to expression and call the value from tb_value as reportitems!tb_value
..............................................................................................
Remember to Mark as answer on the post that helped you
Member
262 Points
100 Posts
Re: Header footer values
Sep 19, 2007 07:48 AM|Kamarikan|LINK
hey magik ,
you should define a Parameter for your report from Layout section , then ( right click insome empty place in outeside of your report table , you'll see a context menu with 4 Items , select the Report Parameter ) ,then create a Textbox inside your Header or Footer , then right click onthe textbox and and select Expression , then put the following code in it .
=Parameters!ReportFooterParameterName.Value
goodluck ,Tehran , Iran , Middle east
Member
143 Points
423 Posts
Re: Header footer values
Oct 03, 2013 03:25 AM|zubayba|LINK
when i followed your suggestion i got on the runtime report instead of the value #Error