Home Datapipelines

Linking Fields Question

edited January 2007 in Datapipelines
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

Comments

  • edited January 2007
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.