New Topic

Category Report Builder

Product Version 7.4

Calculated field error: For input string: ""

Siim Neljandik shared this problem ago

Resolved

Hello,

In one report I am getting the For input string: "" error when I try to create a calculated field. I am not getting that error in other reports with the same or different view.

Application Version:7.4.10

Build:20190510

All the best

Siim N

Files:

The same problem 0

Replies (5)

Jared Holtgrewe ●

Hello Siim,

Thanks for reaching out with this issue.

Does this issue persist with other SQL queries? Or is this only present with the shown example?

Please let me know.

Thanks,

Jared

Reply URL

Siim Neljandik ●

Hello, the issue was with all calculated fields. I used this as an example because this eliminates the possibility of the problem being in the fields/calculations used.

URL

Jared Holtgrewe ●

Hello Siim,

Does this issue remain if you re-create this single report?

If so, it should be helpful to my replication of this if you provided screenshots of your entire report builder.

Thanks,

Jared

Reply URL

Siim Neljandik ●

Hello,

Sorry for the long response. The issue seemed to be because of another calculated field. This report was exported/imported between client organisations without errors, but one of the calculated fields broke during that process. It was a leftover days between predefined calculated field and one of the fields used in the calculation was missing. Because of that the report itself worked fine, but for some reason it was stopping any other calculated field editing without giving a meaningful error message.

All the best

Siim N

URL

Jared Holtgrewe ●

Hello Siim,

Thanks for the update.

Glad to hear that you found the root cause of this issue. With that information, were you able to resolve this issue?

Please let me know. If this issue is resolved please let me know if you think its appropriate to mark this ticket as complete.

Thanks,

Jared

URL

Jared Holtgrewe ●

Hello Siim,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Regards,

Jared

Reply URL

Jared Holtgrewe ●

Hello Siim,

I wanted to check-in and see if you have had a chance to review my message.

Thanks,

Jared

Reply URL

Jared Holtgrewe ●

Hello Siim,

I hope things are going well over there.

Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.

Regards,

Jared

Reply URL