Method Community

I am not able to get calculated fields to print on a report.  Neither formulas nor the mere placement of a copy of data from an actual column into a calculated field will print.  What am I missing?  Thanks.

Hi Robert,

There could be an error in your calculated field code (such as a syntax error), which would prevent any value from being displayed. Can you please post the expression you are using in your calculated field? 

-Russell

I have a linked field in SalesOrderLine to SalesOrder.DueDate and this field is relabeled StartDueDate in the linked Field.  I can see StartDueDate on my reports. If I create a calculated field that is merely a copy of StartDueDate, like [SalesOrderLine.StartDueDate], it will not print.  I eventually need to do date math in calculated fields expressions and display those results but I can't even get DueDate/StartDueDate to print with no formulas at all.    

Again, my Report Design expression for the calc'ed non-printing field = [SalesOrderLine.StartDueDate].

It would seem that relabeled linked fields are not accepted in Report Designer calculated field expressions.  

Thanks.

Hi Robert,

I've tried reproducing this on my end, however the calculated field referencing the linked field prints sucessfully in the report designer. Can you post a screenshot of the expression in your calculated field? (You can use a free image hosting site such as imgur.com)

-Russell

Here are the images to the setup and preview.

setup

preview

and the date format....

Hi Robert,

Thanks for the screenshots. Can you please try changing your
expression to [StartDueDate]?

Unfortunately this is a known bug with the Report Designer, when the
table is referenced the field isn't displayed. When you open up the
Expression Editor the table name can be added automatically, so
remember to delete the table name before saving the Expression Editor.

Please let me know if this solves the issue.

-Russell