UNION JOIN - PLACING DATA ON REPORT

[GaryWilsonCPA]

this is my union join, it works in designer sql, I have placed this in a report under "show sql" and there is no adverse reaction. How do i place the fields on the report?




SELECT
appointment_scheduling.PATID as PATID,
appointment_scheduling.appointment_date as DATE,
appointment_scheduling.service_code as SERVICECODE,
appointment_scheduling.client_name as NAME


FROM SYSTEM.appointment_scheduling

UNION ALL

SELECT
staff_tx_history_all.PATID as PATID,
staff_tx_history_all.date_of_service as DATE,
staff_tx_history_all.SERVICE_CODE as SERVICECODE,
staff_tx_history_all.PATID as NAME


FROM
SYSTEM.staff_tx_history_all

 

[synapsevampire]

What's designer SQL?

What version of Crystal, and what database?

To place fields select Inert->Field Object->Database Fields

You can't replace all of the SQL within the Database->Show SQL Query, check the blurb in the Database->Show SQL Query on what can be modified (From, Where and Order BY)

-k

 

[GaryWilsonCPA]

Designer sql is a query design tool that runs outside of crystal. It came with my developer version. You can write queries in it and view the results on a grid. You can also save the results, use in a report.

The problem with saved results is that they are always stale. These reports will be run by users who would not have access to refreshing the query in SQL design.

I copied my query from sql designer into the report under the show sql function. The only problem is that I don't see the data anywhere o place fields select Inert->Field Object->Database Fields.

I need to know how to link my query to the wizard that does the "select Inert->Field Object->Database Fields"