请问一个报表里怎么调两个查询的数据

[nu9i]

我想在一个报表中调用两个查询的数据，一个是在主体显示具体数据，一个是在页脚显示统计数据。现在报表的数据源为查询A，怎么才能在页脚里调用到查询B的统计数据呢？

[wwwwb]

两表是否有相同的KEY字段

[ACMAIN_CHM]

你可以在报表中把两个查询都添加到数据源中，在两个查询中创建连接。

[nu9i]

能不能单独引用A B查询呢？不做左连或右连

[wwwwb]

两表是否有相同的KEY字段，是单独的查询？
select *,(select count(*) from b where ...) from a

[nu9i]

[Quote=引用 4 楼 wwwwb 的回复:]
两表是否有相同的KEY字段，是单独的查询？
select *,(select count(*) from b where ...) from a
[/Quote]

查询A
SELECT
[1].ras_users.din,
[1].username,
CDate(FormatDateTime(Clock,2)) AS onlydate,
Min([1].Clock) AS indoor, Max([1].Clock) AS outdoor,
IIf((format(indoor,'hh:mm')<format(#12/30/1899 10:1:0#,'hh:mm')) and (format(indoor,'hh:mm')>format(#12/30/1899 9:30:0#,'hh:mm')),'√','') AS later,
IIf((format(indoor,'hh:mm')>format(#12/30/1899 10:1:0#,'hh:mm')) or (format(outdoor,'hh:mm')<format(#12/30/1899 18:30:0#,'hh:mm')),'??','') AS others
FROM 1
WHERE
((([1].Clock)>=DateSerial(Year(Date()),Month(Date())-1,1) And ([1].Clock)<=DateSerial(Year(Date()),Month(Date()),1)))
GROUP BY [1].ras_users.din, [1].username, FormatDateTime(Clock,2)
ORDER BY [1].ras_users.din, CDate(FormatDateTime(Clock,2));

查询B 里面的[2]就是查询A
SELECT
[2].username,
sum(IIf((format(indoor,'hh:mm')<format(#12/30/1899 9:41:0#,'hh:mm')) and (format(indoor,'hh:mm')>=format(#12/30/1899 9:31:0#,'hh:mm')),1,0)) AS in10mins,
sum(IIf((format(indoor,'hh:mm')<format(#12/30/1899 10:1:0#,'hh:mm')) And (format(indoor,'hh:mm')>=format(#12/30/1899 9:41:0#,'hh:mm')),1,0)) AS out10mins
FROM 2
GROUP BY [2].username;

能不能只对一个text控件单独指定一个数据源呢

[wwwwb]

SELECT A.*,B.* FROM 查询A A INNER JOIN 查询B B ON A.username=B.username

[nu9i]

[Quote=引用 6 楼 wwwwb 的回复:]
SELECT A.*,B.* FROM 查询A A INNER JOIN 查询B B ON A.username=B.username
[/Quote]

增加了查询3
SELECT [2].*, laters.*
FROM 2 LEFT JOIN laters ON [2].username=laters.username
ORDER BY [2].ras_users.din, CDate(FormatDateTime(onlydate,2));

将报表数据源设置为3 出现错误

该特定字段‘[2].username’可以参考sql语句中from 子句列表中的多个表。

这是什么意思，怎么决定？