The create table main_info
(
Sk_id int the not null,
Number of voucher varchar (20) not null,
Payment date datetime not null,
The amount of money not null,
Hereinafter referred to as varchar (100) not null,
Payment type varchar (20) not null,
The cashier varchar (20) not null
PRIMARY key (sk_id)
);

The create table desc_info
(
Item_id int the not null,
Sk_id int the not null,
The receiving money not null,
Credit amount of money not null,
Business single varchar (20) not null,
License plate number varchar (20) not null
PRIMARY key (item_id)
);
Insert into main_info values (1, 'HZ - 20130608001', '2013-06-08', 320, 'test', 'cash' and 'administrators')
,1,100,0 insert into desc_info values (1, 'HZ - 20139698004', 'yue Y - 0001')
Insert into desc_info values (2,1,120,0, 'HZ - 20139698004', 'yue Y - 0001')
Insert into desc_info values (3,1,100,0, 'HZ - 20139698005', 'yue Y - 0002')

SQL statement
Select payment date, number of voucher, hereinafter referred to as, collection categories, cashier, payment amount, reduction amount, the collection, license plate number, business order from main_info m left join desc_info d on Margaret spellings k_id=d.s k_id order by abbreviation, collection categories, receiving date

CodePudding user response:

Master table cannot do cross statements? I want to achieve as shown in figure format to want what to do?

CodePudding user response:

Demo fastRepport a cross statements, you can download study,
Is the master-slave relationship between two dataset

CodePudding user response:

01 done this

Cost settlement listing report

Forget is how to implement the at that time,

I look for the source code, then use the 2.46 version of the