Method:Classic General Q&A

Re: Calculated fields not printing in Report Designer

Method_Russell — Fri, 23 May 2014 15:15:06 GMT

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

Re: Calculated fields not printing in Report Designer

robert.cowart — Wed, 21 May 2014 16:26:37 GMT

and the date format....

Re: Calculated fields not printing in Report Designer

robert.cowart — Wed, 21 May 2014 16:22:43 GMT

Here are the images to the setup and preview.

setup

preview

Re: Calculated fields not printing in Report Designer

Method_Russell — Fri, 16 May 2014 13:25:39 GMT

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

Re: Calculated fields not printing in Report Designer

robert.cowart — Thu, 15 May 2014 16:04:27 GMT

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.

Re: Calculated fields not printing in Report Designer

Method_Russell — Thu, 15 May 2014 14:27:08 GMT

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

Calculated fields not printing in Report Designer

robert.cowart — Tue, 13 May 2014 20:43:01 GMT

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.