Data Selection in Report Header

We are trying to figure out how to either show the data selections for a JDE report (like a trial balance report) on the report header or on a page preceding the report, like a cover sheet. Any ideas or suggestions? Has anyone already done this?

This can be done in the report properties, on the cover page options tab there is a print cover page checkbox. Once checked there are options on what to print. This is at the report level but I am pretty sure you can do this at the version level as well. Try it out, check all then run a test to deterimine which ones if any work for you.

Hi there and welcome to the list. As far as I'm aware the data selection values are not available within the report designer. The usual way of doing this is to use processing options to create and maintain the report parameters and filters. These are available within the report designer and can be used to drive many display elements.


BTW - If you put the configuration details of the JDE instance you're working with in your signature it will help people give you the best information possible.

Hi cteichert,

This can be done with a bit development.
The solution had been published more times on JDEList.
Here is one:
get data selection

As I see, it is not the most detailed thread, but you can search for the others.

The skeleton of the solution:
#1. two new worktables, to store temporarily the selection of the UBEVER
#2. a new Business Function to fill the table with the selection information
#3. modify the UBE - call the BSFN, print the selection in a new conditional section from the worktables in a fomat as you desire

Regads,

Zoltán

The cover page option can be done at the version level as well. If you turn it on at the report template level, it only affects new versions; existing versions will not change. You will have to go into report design for the existing versions to activate printing the cover page. I don't think you will have to override version specifications, because version overrides are done section by section.

The cover page can be done at the version level as well. When you choose to print the cover page at the report template level, it only affects new versions; existing versions remain the way they are created. I do not think you will need to override version specifications to make this change because version overrides apply to individual sections, not to the entire version. In other words, you can apply a version override to the page header section without applying one to any of the other sections.

In 9.0 there’s a cool feature on WSJ where you can Row Exit and see the Data Selection, Proc Opts and the actual SQL that JDE created. Don't have to do anything special, every UBE just does it automatically. Saw it at my last employer just as I left, am excited to see it again at my current employer later this month!

Steve,

Everyone has been asking for those features - since the beginning of dirt!

Is that a 9.0 feature or related to a tools release? I hadn't heard of it before.

(db)

Dan,

I believe it's a 9.0 thing. But I'm an apps guy, so don't take too much stock in me.

After all these years it finally takes us back to the "good old days" when there was only one JDE (World).

It is a tools 8.98 feature.
It's named Job Execution Detail (had to take an ESU to make it work). See attached Release Notes on 8.98

I can't wait to look into it more in 8.98!

Thanks for bring this new functionality to our attention!

(db)