cancel
Showing results for 
Search instead for 
Did you mean: 

EPO4 Builtin Reports - VSE 8.5 compliance report

Hi there,

I have found an issue with a default report on EPO4.
It is the VSE 8.5 compliance report, in the sql code it only checks for hotfix1 not greater than hotfix1 so the report always shows 0 compliance.

Is there any way to edit the sql for the report to make the required change. I looked through the query builder but could not see any way of editing the sql code directly.

best regards,
Bill
Tags (3)
4 Replies

RE: EPO4 Builtin Reports - VSE 8.5 compliance report

Go to > Reporting > Queries > select the query you want to modify > select Edit and make the appropriate modifications.

Hope that helps! happy

RE: EPO4 Builtin Reports - VSE 8.5 compliance report

I have looked though the query builder.
What I need to do is to edit the SQL code directly to make the required change to the report.

Another question would be, does anyone know where the reports are stored in the epo configuration?

Best Regards,
Bill
Johonn
Level 7
Report Inappropriate Content
Message 4 of 5

RE: EPO4 Builtin Reports - VSE 8.5 compliance report

If you are talking about the one i am looking at that is not the case for me.

The one i am looking is the basic RED/GREEN Boolean Pie Chart.

If you edit that query then under the Pie chart you should see "Configure Criteria" That should show you what it is looking for for compliance and can be change to fit your needs.

RE: EPO4 Builtin Reports - VSE 8.5 compliance report

Thanks Johonn,

That worked for me.
the "Configure Criteria" button was so obvious I was not seeing it!

many thanks for your reply.

Best Regards,
Bill