Skip to Content
0
Former Member
Sep 01, 2008 at 01:29 PM

How to use a query in the Print Layout Designer?

279 Views

I created a query with the query generator:

SELECT T0.[Discount], T0.[NumOfDays], T2.[DocNum] FROM CDC1 T0, OQUT T2 INNER JOIN OCTG T3 ON T2.GroupNum = T3.GroupNum WHERE T2.[GroupNum]=T3.[GroupNum] AND T0.[CdcCode] = T3.[DiscCode]

The result shows the cash discout (the days and the percentage) of every record.

I need this query, because I want to design a sales order report.

To show the payment conditions with cash discount I need to have the table CDC1 but when I create a new database field in the report I can't see that table.

So I queried the table CDC1....

Then I created a new database field and in the list box "table" I made the following steps:

extras\customizing tools\user defined values - definition\search for saved query in user defined values

But the problem is that I don't get the result of the query into my report.

What's the problem? I don't know what I've done wrong...

please help me