DataItem by another Table in Section of Report

DarkHawk · 2005-05-23

Hi all,

i have a problem with an report.
The Report has as first DataItem "Salces Cycle" The second DataItem is "Sales Cylce Stage" an it is one level indendet.
As third DataItem a have Opprtunity it is two level indendet.

So the reportlist is great sorted by Customer to Sales Cycle Stage, but i have only the information about the Customer name.
I must print the City about the Customer too.

The City about the Customer are stored in Table 5050.

So what can i do, to print the city in the Opportunity Section?
The City must be print in addition to the Customer Name.

Sorry about my english.
Thanks a lot
Regards
Michael Hofmann

DenSter · 2005-05-23

In the OnAfterGetRecord trigger of the highest level dataitem that has the same customer, you get the customer into a global record variable, and then you can simply enter any customer field as the SourceExpr of any textbox, by referencing it in the property.

So add a global variable called 'Customer', type record, subtype Customer. Let's say you have a Customer number in the Sales Cycle, then you would add the following statement to the OnAfterGetRecord trigger:

Customer.GET("SalesCycle"."Customer No.");

And in the section, you would have a text box, and its SourceExpr would be Customer.City.

DarkHawk · 2005-05-24

@DeSter

wow. It´s work great.

Thanks a lot.

Regards
Michael Hofmann

DenSter · 2005-05-24

You made it work Mike, I just gave you a little tip 8)

DataItem by another Table in Section of Report

Comments

Categories