You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with Grid property - Text Options in MR Reports

in Narrative Reporting 4 comments

Summary:

Issue with Grid property - Text Options in MR Reports - While exporting in Excel

Content (please ensure you mask any confidential information):

Hi All,

In MR Reports we are using the Text options property at Grid level for replacing No data with -(Dash). Now when we export this report to Excel that -(Dash) not getting considered as Zero. Due to this when users link that cell in excel with other sheet it gets #Value error. What's solution for this??

In HFR Reports -Dash was considered as Zero and so that in excel while linking these cells was not giving #Value error.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!