• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Report Logic

ka4niv

Active Member
Greetings All ...

In the absence of formal training, I am trying to figure out how JDE =
reports work, especially:
1. the logic behind each of the sections and their events
2. the relationship of data selected from the business view to =
that section

I have the following resources: (none of which have what I am looking =
for)
1. J.D.Edwards OneWorld - A Developer's Guide (Hester/Enyeart)
2. One World XE Enterprise Report Writing (eaor1xe.pdf and =
eaor2xe.pdf)
3. Basic and Advanced Report Writing classes

Are there any other resources available?


Thanks
Maurice Rice
Delta Woodside Industries

XE sp:14 ES:AS/400 Citrix, NT, 2000
 

Zoltan_Gyimesi

Legendary Poster
Hi Maurice,

Yes, there are other resources available. First of all JDEList /Forums where we are :)))

On the other hand the JDE Knowledge Garden also could be usefull on the internet: "https://knowledge.jdedwards.com/" but you should have a User ID and a password from JDE to acccess it. Do you have it already?

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Christian Audet

Moderator
Staff member
Hi Maurice,

I think that you already have a lot of ressource. Do tou have more specific question ?

Look at this document from the knowledge Garden (attached in the forum) I think that can give you some answer, it's a old document but it still have relevent information.

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

Zoltan_Gyimesi

Legendary Poster
Hi Maurice again,

I forgot to mention an other available resource.
You can also find some usefull information on-line in OneWorld. Please, follow the instruction to access it:

* Sign-on OneWorld as a user with language preference: Domestic (blank in the user profile).
* select Help/Contents from OneWorld Explorer
* Two new window will pop up. Close the second which has the input focus with title: "Help Topics: OneWorld Help"
* Select on the first: "Tools, Technical and Foundation"
* Select from the list: "OneWorld Tools API Reference" or "Published APIs". The title depends on your OW release level, the first is on XE and the second is in prior XE.

You can find here brief but valuable informations amoung others about Events and System Functions which aren't available elsewhere.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

ka4niv

Active Member
Been there - that is how I found the JDE report manuals.
Christian's attachment looks promising - will read it more closely.
Also the OWExplorer Help - API Reference.
Just a matter of knowing where to look!

I will come back to the forum as soon as I know what I want to ask.


Many Thanks!

Maurice
 

Zoltan_Gyimesi

Legendary Poster
Hi Maurice again,

You have mentioned what is your interest with regard to Report UBEs.
Can I advise you to check the 9th chapter and Appendix B in the Enterprise Report Writer manual? Hope, you will find it useful.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Christian Audet

Moderator
Staff member
Maurice,

I have the same king of document for One World Application. Do you think that can help?

Christian

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

ka4niv

Active Member
Zoltan & Christian ...


Here is my problem -- we are running R10411 (Variance report) for various
locations, but do not want the users at those locations to change the data
selection and view variances for other locations.

I have used "Set User Selection" (remember that thread?) in the Initialize
Section to combine the user's requirements and the standard data selection
for the report. The report currently prints all columns and rows, including
all level breaks, but no data. I am missing something.

(It just occured to me that this is a Tabular report, and I have been
treating it as thought it were Columnar.)

Report Writer manual? Hope, you will find it useful.

I have already read throuth Chapter 9 and Appendix B. I understand some
things better, but have more questions that they do not address.
Christian's web page also helps my understanding. I am not ready to take on
applications *yet*, but please send it, and I will look at it when I am
ready.

Again, Thanks for all the help.

Maurice

XE sp:14 ES:AS/400 Citrix, NT, 2000
 

Christian Audet

Moderator
Staff member
Maurice,

see attachement for the latest version of UBE Process Flow as well as Application Process Flow.

For you issue where you have no data but the header and footer, it's a common issue for me when I try to suppress some info from the detail into a tabular (I hate tabular, they are terribly NOT FLEXIBLE !). Can you provide us with the USER selection in this report as well as the NEW SELECTION that you added in the tabular section.

Was your new Event Rule inside the initialize event ?

Christian

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

ka4niv

Active Member
Christian ...

Ok, you asked for it. From the "Initialize Section" event ...
o
o
o
Set Selection Append Flag( <No>)
//
// Actual Selection Specs ...
//
Set User Selection(BC Ledger Type (F0902), <Equal To>, VA
sec_szActualLedgerType_LT, <And>)
Set User Selection(BC Business Unit (F0901), <Greater Than or Equal To>, VA
sec_PlantLowValue, <And>)
Set User Selection(BC Business Unit (F0901), <Less Than or Equal To>, VA
sec_PlantHiValue, <And>)
Set User Selection(BC Company (F0901), <Equal To>, "00003", <And>)
Set User Selection(BC Object Account (F0901), <Greater Than or Equal To>,
"5000", <And>)
Set User Selection(BC Object Account (F0901), <Less Than or Equal To>,
"9999", <Or>)
//
// Budget Specs ...
//
Set User Selection(BC Ledger Type (F0902), <Equal To>, VA
sec_szBudgetLedgerType_LT, <And>)
Set User Selection(BC Business Unit (F0901), <Greater Than or Equal To>, VA
sec_PlantLowValue, <And>)
Set User Selection(BC Business Unit (F0901), <Less Than or Equal To>, VA
sec_PlantHiValue, <And>)
Set User Selection(BC Company (F0901), <Equal To>, "00003", <And>)
Set User Selection(BC Object Account (F0901), <Greater Than or Equal To>,
"5000", <And>)
Set User Selection(BC Object Account (F0901), <Less Than or Equal To>,
"9999", <None>)
o
o
o

Append Flag is set to <No> to *hopefully* prevent the user from appending
their own selection specs.
Please tell me that you see something obvously wrong. It is quitting time
here, so will give my brain a rest
and get a fresh start tomorrow.

BTW - the UBE Batch Process Flow is a big help - looking forward to reading
the one on Apps!

Thanks
Maurice
 

Christian Audet

Moderator
Staff member
Maurice,

*** Look in my last post for all the new version of UBE and APPS Process Flow.

For you selection issue, tell me if I'm wrong, it's seems that you are able to run this report WITHOUT YOUR EVENT RULES in the initialize and that you have a result? As soon as you add your event rules it's not giving you any data at all ?


Let's say that your answer is YES. Then give us the data selection from the USER'S selection for when the report is WORKING. I asume that when it's working there is no "SET USER SELECTION" in the Event Rules. (is it true ?)

And then give us the USER'S SELECTION from outside of the report as well as the SET USER SELECTION INSIDE THE REPORT. I know that you already gave us this last one but in your post it was not possible to read ALL parameters of ALL THE FUNCTION CALL.

Maybe you can try to provide us with the "print to file result of this event Rules".

Thank

Christian Audet



Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

ka4niv

Active Member
OK, I surrender.

I ran the program in the test environment and it ran fine. I don't know why. I changed nothing.

I want to thank everyone on the list who took time to help. You have been most kind.

It is time to contemplate my future.

Maurice
 

Zoltan_Gyimesi

Legendary Poster
Hi Maurice,

Although I am not a Report Writer expert but I suppose that the usage of the third "And/Or" parameter of the SetUserSelection could be wrong.
The On-Line help (that I suggested to you earlier) states about this parameter:
>>>>>>>>>>>>>>
And/Or This can be three values: And, Or, or None. I Y ‘None’ is used when this is to be the first line of the selection criteria. The other two values should be used for subsequent lines. The value will specify whether this line should be treated as an ‘AND’ condition or an ‘OR’ condition.
<<<<<<<<<<<<<<<
Try to start with "None". Use the And/Or in the SetUserSelection such a manner, how do you want to concatenate the current criteria to the previous instead of how do you want to concatenate the following criteria (if will be any at all).

Please, let us know that does it work or not.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Christian Audet

Moderator
Staff member
Maurice,

Happy ending is always preferable !

At least is't working now.

Have a nice day !

Christian Audet



Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 

Sef

VIP Member
Hi Fellow Forum members,

This thread seems to be finished, but nevertheless I'd like to put in my two bob.
The problem Maurice has, seems very familiar. I have written quite a few UBE's in which I needed to put complicated data selection. When data selection has Processing Option dependency things can get quite hairy.
I also occasionally found unexpected UBE output, where sometimes it seems that the data selection is either completely ignored or data selection causes a blank pdf.
By just returning to RDA and re-confirming each line individually and maybe re-arranging the selection lines, I sometimes got rid of the problem. In short, RDA seems quite sensitive in this area.

Hence I was very pleased with Zoltan's suggestion in the previous thread on data selection, where he suggested to create an invisible section over the same BSVW where you can set the data selection in the "conventional" way and just use the system function "Use Data Sel/Seq from a section" in the "real" section of the report. Works a treat!

Rgds,




Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT
 

Zoltan_Gyimesi

Legendary Poster
Hi Sef and Maurice,

Sef, I am really glad to hear that the mentioned "dummy section" method works fine for you. I also planned to de[censored] it for Maurice, but I was waiting for his update before it.
Maurice, would you be so kind as to answer for us that was the problem with the And/Or parameter usage as I de[censored]d it in a previous post in this thread? Thanks in advance for your update.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Zoltan_Gyimesi

Legendary Poster
Hi Sef and Maurice,

Sef, I am really glad to hear that the mentioned "dummy section" method
works fine for you. I also planned to describe it for Maurice, but I was
waiting for his update before it.
Maurice, would you be so kind as to answer for us that was the problem
with the And/Or parameter usage as I described it in a previous post in
this thread? Thanks in advance for your update.

Regards,
Zoltán



B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

ka4niv

Active Member
Zoltan ...

I am not really sure what the problem was / is. While preparing to answer
Christian's question yesterday, the report began to work perfectly, as if by
magic -- without any changes. My supervisor must have heard my scream of
frustration. He has assigned me a new project back in the old legacy RPG
world -- guaranteed success.

I am interested in the "dummy section" method, but do not yet understand how
sections interact with each other. (And it looks doubtful I will go to
developer's class anytime soon.) Please send your explanation, however. I
may not understand it now, but as I discover the inner workings of the UBE I
am sure it will make sense.

I will keep in touch, since this problem must be addressed soon.

Again, many thanks.

Maurice


----- Original Message -----
From: <Zoltan.Gyimesi@Synergon.hu>
To: <maurice.rice@deltamills.com>
Sent: Friday, September 28, 2001 12:00 PM
Subject: RE: Report Logic
 

Zoltan_Gyimesi

Legendary Poster
Hi Maurice,
Thanks for your update.
It is really strange that your report began to work perfectly without any changes. Something should happened, should changed.

Have you checked the on-line help of SetUserSelection regarding to the usage of the And/Or parameter and the None literal for it. It doesn't seem that you used it correctly in your ER, don't you think?

About dummy section method please check the the thread with subject "Wierd Question Set User Selection Programmatically" on the One World / XE Developers Forum or in the archive of it. I replied there on 9/10/01 07:50 AM, or simply search for "dummy section" in the archives.

I mean "Dummy section" that it hasn't any functionality except its existance with its business view and selection.

Regrads,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

ka4niv

Active Member
Zoltan ...

Yes I remember the "Wierd Question" thread. I will go back and read it
again.

As you suggested, I have reviewed the ER of several reports where Set User
Selection was used, and I am using it incorrectly. It seems that the
*not* the next line as I had assumed. You tried to tell me that, but it did
not make sense at the time. My apologies.

I will fix it and try again.

Maurice

XE sp:14 ES:AS/400 Citrix, NT, 2000
 
Top