question

Bob Z. avatar image
Bob Z. asked ·

Is there a query I can run to replace all "Top 0" with "100000"

After upgrading NAM to latest version I receive the following message on many reports. "Top must be positive number. Top 0 is replaced by top 100 000". It would take a lot of time to edit all the sections that I have a zero in the top rows setting. Is there a query I can run to replace all "top zeros" with "100000".

reports
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Answer

Erik S. avatar image
Erik S. answered ·

I've done it in the past with exporting the reports, a sed script, and importing the modified reports.


I'm not aware of a supported SQL script to do it.


-- Erik


2 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

I'm testing the process in my non-prod env. I exported the reports.xml and did a search on max rows "0" and replaced it with max roes "100000" . Do I just import the updated file? Will it replace the Sections & reports that are there without creating duplicates? .

0 Likes 0 · ·

Hi Bob,


As long as report names are not changed, existing reports will be overwritten by fixed ones. However, it might happen that you'll need help with importing built in reports. My hint would be to ask Support Team for help in such case.


Best Regards


Jacek

0 Likes 0 · ·