如何实现以下报表,也就是多张表和在一张报表的问题
table1title1 title2 title3 title4 title5
---------------------------------------------
value1 value2 value3 value4 value5
...
count1table2title1 title2 title3 title4 title5
---------------------------------------------
value1 value2 value3 value4 value5
...
count2
table1title1 title2 title3 title4 title5
---------------------------------------------
value1 value2 value3 value4 value5
...
count1table2title1 title2 title3 title4 title5
---------------------------------------------
value1 value2 value3 value4 value5
...
count2
例如Sql语句这样写
Select 'Tabel1' as tablename, title1, title2, title3, title4, title5 from table1
Union
Select 'Tabel2' as tablename, title1, title2, title3, title4, title5 from table2
将记录集赋给报表源,再用这个做出分组报表
sql server2000可以用
Select title1, title2, title3, title4, title5 from table1
Union All
Select title1, title2, title3, title4, title5 from table2
2、沒講明白.
报表该如何设计?
我只知道用ActiveReport报表,这个可以分子报表
Select 'Tabel1' as tablename, title1, title2, title3, title4, null as title5 from table1
Union
Select 'Tabel2' as tablename, title1, title2, title3, title4, title5 from table2
这种是table1中只显示有4个字段,table2中显示5个字段,具体情况就看LZ的举一反三了 :)