我正在使用Crystal Reports 2008。我想创建一个报告,在这个报告中,我将从一个SQL获取值,并将该值字段传递给另一个SQL并获取结果。这样做是否可能?
我正在使用Crystal Reports 2008。我想创建一个报告,在这个报告中,我将从一个SQL获取值,并将该值字段传递给另一个SQL并获取结果。这样做是否可能?
SELECT CustomerNum -- Returns number 919
FROM RecentOrder
WHERE OrderNum = 23455;
SELECT FirstName, LastName, EmailAddress
FROM Customer
WHERE CustomerNum = 919
这些可以以多种可能的方式组合:
SELECT FirstName, LastName, EmailAddress
FROM Customer
WHERE CustomerNum = (SELECT CustomerNum
FROM RecentOrder
WHERE OrderNum = 23455
)
SELECT FirstName, LastName, EmailAddress
FROM Customer AS C JOIN RecentOrder AS O
ON C.CustomerNum = O.CustomerNum
WHERE O.OrderNum = 23455
WITH name1 AS ...query1...:
SELECT ...
FROM ...list including name1...
WHERE ...
值得花费一些精力来组合那些让你认为需要子报表的查询。如果你仍然需要子报表,那么你需要比我能提供的更专业的帮助。