Skip to Content
author's profile photo Aditi Shripuram
0
Aditi Shripuram

Analysis for Office reports header prompts are showing values as #NA in scheduled report.

Posted on Jun 05, 2020 at 03:48 PM 223 Views Last edit Jun 05, 2020 at 03:55 PM 2 rev.

Working on AO 2.8.1 Version.

After upgradation of AO version to 2.8.1, Scheduled AFO reports headers, started giving value as #NA.

Tried to remove @ from report header formulas still issue remains same.

Anyone experienced similar issue with AO 2.8.1 version?

Thank you!

Add a comment
10|10000 characters needed characters exceeded

Comment on This Question

Assigned Tags

Related questions

2 Answers

  • author's profile photo Kiran Bonam
    Kiran Bonam
    Posted on Jun 08, 2020 at 03:50 PM
    0

    Hi Aditi,

    You mean Info fields ? any screenshot please...

    We had similar issue for Info fields displaying #NA with AO 2.7 schedule but the issue was resolved after updating AO to 2.7.8. Now we are on 2.8 and no such issues observed.

    Regards,

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Nick Wilson
    Nick Wilson
    Posted on Jul 28, 2020 at 08:55 AM
    0

    Hi Aditi,

    We have the same issue on 2.8.1. From investigation of the logs I found that the formula values are being retrieved but are lost when opening Excel with Automatic calculation activated. If you open the scheduled workbook with Excel calculation set to manual you will probably see the formulas are returning the correct value.

    We are considering upgrading to SP04 or SP05 when it's out but the above workaround may help with your requirement.

    Nick

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.