How can you edit the sales invoice header / Expression ? (Report Builder 3.0)

Bertie_77 · 2016-11-26

I am still a noob with report builder and trying to edit the sales invoice.

if i print this report it will print "Purchase - Invoice" but it needs to be "Purchase - Order"

Seems like a simple edit, but everything is a expression with get en setdata. Can someone explain how you can edit this !

martinher562 · 2016-11-28

If you want to look at the expressions behind any text boxes. Select the text box/field in report builder / V.S. and right click on it, select "Expression". You should be able to see the code behind that expression. Expressions in the report builder use visual basic syntax.
Or
Like @Sowkarthika check in CAL Globals for any variables and the CAL code behind it. That is where the values are assigned or the field can be in the dataset designer.

Note: One thing that really helps me is to look at the actual data. When you run the report and you are in preview window -> click on the upper left corner ->Help -> about this report. It will ask you to run it again. You can view the data behind the report that way. It helps me, if the data is in the data set then that means the value is coming from CAL Globals or dataset designer.

Sowkarthika · 2016-11-28

Usually report caption will be defined in CAL Globals. Try to update it and check.

martinher562 · 2016-11-28

If you want to look at the expressions behind any text boxes. Select the text box/field in report builder / V.S. and right click on it, select "Expression". You should be able to see the code behind that expression. Expressions in the report builder use visual basic syntax.
Or
Like @Sowkarthika check in CAL Globals for any variables and the CAL code behind it. That is where the values are assigned or the field can be in the dataset designer.

Note: One thing that really helps me is to look at the actual data. When you run the report and you are in preview window -> click on the upper left corner ->Help -> about this report. It will ask you to run it again. You can view the data behind the report that way. It helps me, if the data is in the data set then that means the value is coming from CAL Globals or dataset designer.

How can you edit the sales invoice header / Expression ? (Report Builder 3.0)

Best Answer

Answers

Categories