Problem with Query-Infoset

[marcelom_bovo]

Hi People,

Im trying to make a query(infoset), but I'm having a problem,

The user is gone to put the company code and the Financial Transaction(from VTBFHA), and i have to show in the result the last date from the table VTBFHAZU, and if there is no line in the table VTBFHAZU, I won't show the company code and the Financial Transaction.

How can I do that, because IF a link then with a JOIN in the infoset, it will bring me more than 1 line if the VTBFHAZU has more than 1 with the same Financial Transaction, but if I dont JOIN then, the report may bring me results without date.

The question is, how can i delete lines from the display table.

Tks

[Former Member]

Hi,

Please try this..in the infoset you can write additional coding..in the event...RECORD PROCESSING/END-OF-SELECTION (before list)...and filter the data..

Thanks

Naren

[marcelom_bovo]

yes, but, how can I code that?

for example, I could do: DELETE ADJACENTE DUPLICATE ENTRIES FROM,

or Loop at table, and delete the ones wich has the field empty.

but from wich table?

[marcelom_bovo]

I Tried to debug the program to get the tables, but didnt work(the name was %dtab).

for exemplo:

Now, I'm making a query that sums the values of an amount, its working, but the lines are duplicated.

I have to delete the duplicated lines.

Tks.

[marcelom_bovo]

Hi again,

I made it

In SQ01, i changed the output layout rom basic list to statistic, and then it worked like a DISTINCT command.

Thanks guys