How to force an empty report to print

Epicor ERP 10
1

I found a very old question on this topic, but could not find a way to re-open it, so I am re-creating it.

We are on 10.2.200.6, but moving to 10.2.700.6 in the very near future.

We are looking for a way to get the system to print something, even if there is no data in the report. The reports in question are:

  1. The Cost Set Group report that is printed after a cost roll but before posting
  2. The Inventory Movement Report

Both are stored sequentially in their respective directories and when one is missing, we have to try and figure out whether it was not run or it was but but no data was returned.

Is there something can be changed in the .rdl query or is that logic held up in Epicor itself?

Thanks.

—sam

Link to old item on same topic:

2

My understanding is that if the RDD doesn’t generate any data, then it doesn’t matter what’s in the RDL.

You my have to recreate the report as a BAQ Report such that the BAQ always returns some records. The easiest way to do this is to make a sub query (with a table that returns 1 row) with the same exact column names (all as calc fields) and make this subquery a UNION type. Then in the RDL, filter the dataset to remove that extra row in the printed output

6 Likes
3

Yeah what Calvin said you need some data to generate the temp tables

4

@ckrusen , @josecgomez

Gentlemen -

Thanks so much for the help. I understand what you are suggesting, but I think it’s a little beyond my capabilities at the moment. Will keep it in mind, though.

5

Yeah, it’s far from a trivial problem