Reports - ProcessingOnly property

norseny · 2017-03-24

Hi!

I have about 300 new reports in my nav database and I need to write down the names of only those that are not ProcessingOnly. Do you know any smart way how to do this quick? Can I filter my new reports somehow? It'll take some time to check every single new report.
I'll appreciate any clues!

TadasNAV · 2017-03-24

Hi,

Function to get the list:
LOCAL PROCEDURE GetReportsWithoutLyout@1000000005();
VAR
Object@1000000000 : Record 2000000001;
StandardTextTEMP@1000000001 : TEMPORARY Record 7;
BEGIN
Object.SETRANGE(Type, Object.Type::Report);
IF Object.FINDSET THEN REPEAT
IF FORMAT(REPORT.DEFAULTLAYOUT(Object.ID)) = 'None' THEN BEGIN
StandardTextTEMP.Code := FORMAT(Object.ID);
StandardTextTEMP.Description := Object.Name;
StandardTextTEMP.INSERT(FALSE);
END;
UNTIL Object.NEXT = 0;
PAGE.RUNMODAL(0,StandardTextTEMP);
END;

You can add ID filter on object record if you want to loop not through all reports.

vaprog · 2017-03-27

export your Reports as a text file.
split the file into single object files
use a text search utility (e.g. findstr) to identify files which contain the string 'ProcessingOnly=Yes;' and delete those.
use a text search utility again to compose a list of the remaining objects name

With something like perl or awk, you can even compile the list directly from the exported object file in one go with a one-liner.

Wisa123 · 2017-03-24

I can't really think of a nice way to do this on the spot in 2009R2.
Objects are stored as BLOB's so theres no fast easy way IMO.

Maybe you can make something happen by exporting them as text and look for the layout part.
However if I was in your position I would probably just go through them one by one.

TadasNAV · 2017-03-24

Hi,

Function to get the list:
LOCAL PROCEDURE GetReportsWithoutLyout@1000000005();
VAR
Object@1000000000 : Record 2000000001;
StandardTextTEMP@1000000001 : TEMPORARY Record 7;
BEGIN
Object.SETRANGE(Type, Object.Type::Report);
IF Object.FINDSET THEN REPEAT
IF FORMAT(REPORT.DEFAULTLAYOUT(Object.ID)) = 'None' THEN BEGIN
StandardTextTEMP.Code := FORMAT(Object.ID);
StandardTextTEMP.Description := Object.Name;
StandardTextTEMP.INSERT(FALSE);
END;
UNTIL Object.NEXT = 0;
PAGE.RUNMODAL(0,StandardTextTEMP);
END;

You can add ID filter on object record if you want to loop not through all reports.

norseny · 2017-03-24

Thanks, it seems great!
I have one problem though, with the REPORT.DEFAULTLAYOUT(...) part - i'm using 2009r2 and I'm afraid that's the case - I cannot compile the object: "You have specified unknown variable DEFAULTLAYOUT". I think it's only possible to use this function in version >=2015, am I right?

TadasNAV · 2017-03-24

Yes, you are right.

NavNab · 2017-03-26

Hello norseny,

you may like my blog post

https://wordpress.com/post/navnab.wordpress.com/417

vaprog · 2017-03-27

export your Reports as a text file.
split the file into single object files
use a text search utility (e.g. findstr) to identify files which contain the string 'ProcessingOnly=Yes;' and delete those.
use a text search utility again to compose a list of the remaining objects name

With something like perl or awk, you can even compile the list directly from the exported object file in one go with a one-liner.

BernardJ · 2017-03-29

In 2009R2 it is possible to export all reports in xml format. In the resulting xml document you can filter on the 'ProcessingOnly' element.

norseny · 2017-03-31

Thanks for all the answers!

Reports - ProcessingOnly property

Best Answers

Answers

Categories