Skip to Content
0
Apr 21, 2009 at 04:31 PM

Problem with Query-Infoset

55 Views

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