cancel
Showing results for 
Search instead for 
Did you mean: 

链接两张表,一张表有数字,但是另外一张表没有数据,如何使这张报表显示

Former Member
0 Kudos
142

一张表为余额表,一张表为明细发生表。

如果做一张报表时,余额在表头出现,明细在中间出现,按照期间作为选择条件。如果当期没有发生额,现在的状态是:没有此张报表出现。

目标:显示此张报表,期初为年初数加上此期间以前的余额,发生额为0,或者空,期末余额等于起初余额。

请问哪位高手可以帮忙一下啊!!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

left join

Former Member
0 Kudos

分清主从关系 使用外连接

Former Member
0 Kudos

多谢!!