Linking Fields Question

rbuser

hi there !

I have an SQL:
SELECT B.THE_YEAR,A.MONTH,B.STAFFNAME,
B.SALES_AMOUNT FROM
MONTHSTABLE A LEFT JOIN STAFF_SALES B
ON A.MONTH=B.THE_MONTH
AND
STAFFNO=11 AND THE_YEAR=2006

in ReportBuilder, the closest it came up was:

SELECT B.THE_YEAR,A.MONTH,B.STAFFNAME,
B.SALES_AMOUNT FROM
MONTHSTABLE A LEFT OUTER JOIN STAFF_SALES B
ON A.MONTH=B.THE_MONTH
WHERE <------
STAFFNO=11 AND THE_YEAR=2006

Obviously, the resulting records were different.
Its filtering by "where" clause, rather than the
in linking condition. I can achieve what I want by
separating them into two datapipelines, but I need
it in DBChart so I need them in one pipeline.

Is there anything I can do with the linking by
assigning additional condition without necessarily
linking them by fields?

thanks for the help !

deck

nicocizik

Hi Deck,

ReportBuilder does not allow you to join on static values in the data
workspace. One option would be to manually edit the SQL yourself from
within DADE. Another would be to design and create your chart in Delphi
rather than ReportBuilder and transfer the image of the chart to a TppImage
component on the report.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com