CR8 & Pervasive.SQL 2000i
The query
SELECT
Products."Code", Products."Desc", Products."SalePrice"
FROM
"DEBC"."Products" Products
WHERE
"Products".Code not in (select distinct("BillingDetail".DetailNo) from "DEBC"."BillingDetail"BillingDetail where "BillingDetail".CVNo='619383')
Pulls products that the customer has not ordered. Now I want to add a separate database I created with more product information and use that info to format my report. The problem is when I add the database to the report it give me a box. "Database Warning" "More that one data source or stored procedure has been used in this report. Please make sure that no SQL expression is added and no server-side group-by is performed." the query works with the database added but I cant Change the where "BillingDetail".CVNo='619383' being the customer I want to run the report on.
Is their a way to use the parameter fields in a custom SQL query so when I add the second data source, I can change it even if I can’t edit the query directly?
The query
SELECT
Products."Code", Products."Desc", Products."SalePrice"
FROM
"DEBC"."Products" Products
WHERE
"Products".Code not in (select distinct("BillingDetail".DetailNo) from "DEBC"."BillingDetail"BillingDetail where "BillingDetail".CVNo='619383')
Pulls products that the customer has not ordered. Now I want to add a separate database I created with more product information and use that info to format my report. The problem is when I add the database to the report it give me a box. "Database Warning" "More that one data source or stored procedure has been used in this report. Please make sure that no SQL expression is added and no server-side group-by is performed." the query works with the database added but I cant Change the where "BillingDetail".CVNo='619383' being the customer I want to run the report on.
Is their a way to use the parameter fields in a custom SQL query so when I add the second data source, I can change it even if I can’t edit the query directly?