Empty Report

[George_Tarasi1]

Setting up a process to create a report using Hyland Unity Management console.  The report will be saved as a document which will then go through workflow and send a notification.

Do not want an empty report sent.  

Is there any functionality to do a record count in report or not produce a report if empty?

[aboucher]

Hi @George Tarasi,

I apologize for not replying to you sooner.

I am reaching out to our Reporting Dashboards team to provide some advice to answer your question.  We will get back to you as soon as we have information or subsequent questions. 

Thanks, 

~Alan 

[George_Tarasi1]

Hi Alan, did you ever receive a response?

[aboucher]

Yes @George Tarasi, the response was by @Mike Walkuski on Dec 29th.

[Mike_Walkuski]

Hi @George Tarasi 

Unfortunately there is not a native way to determine if the report is empty or not before either sending it to Workflow or working on it in Workflow. 

I think your best bet would be a simple Unity Script to check the file size. Assuming when it's "empty" it will always be close to a certain size and when it's not it will be larger. You can use the Unity Script to either query the database directly for the dochandle to get the size from itemdatapage, or you can pull down the document in the script and read the size that way.

Here are some links for reference:

https://sdk.onbase.com/unitySDK/html/801ab971-de29-4c70-b05e-74c5914a1486.htm

https://community.hyland.com/forum/threads/88157-how-to-determine-document-size-via-sql-query

I would also suggest creating an Idea here on Community with your Business case for this functionality too be native in the software and the Community will be able to vote for it so R&D can gauge interest from our customers.

I hope this helps!