This situation is not know the report with that style-CodePudding

The great god, help me, excuse me this kind of situation do with what kind of report style, hope to be able to point in detail; Explain: the price type, the minimum discount rate, the two are respectively in a table, at, the finance department, the boss, this a few belongs to a list below three fields,
In this case I want to do? Detailed solutions, genuflect is begged for guidance

CodePudding user response:

The grid is ok

CodePudding user response:

reference 1st floor lsh370190322 response:

grid can the

But "at, the finance department, the boss" how several fields that show? Select three of the same field and change a name?

CodePudding user response:

Use SQL statements to build table
Price type, select a. a. discount type, b. at the field, b. finance that field, b. the boss from the field in a, b where a.x xx xx
=b.x
Type of edit with DDDW price, at, the finance department, the boss of the edit using the checkbox. Don't know what is DDDW (drop-down data window) and edit, to turn over a book,

CodePudding user response:

The

reference 3 floor sjlion response:

use SQL statements to build tablePrice type, select a. a. discount type, b. at the field, b. finance that field, b. the boss from the field in a, b where a.x xx xx
=b.x
Type of edit with DDDW price, at, the finance department, the boss of the edit using the checkbox. Don't know what is DDDW (drop-down data window) and edit, to turn over a book,

Those fields in a table has, for example: xf_approvallevel: 1: application; 2: approval (at); 4: check (financial); 8: the examination and approval (the boss), the edit,, I just don't know how to make these three fields show in DW

CodePudding user response:

reference 4 floor chengchengwen response:

Quote: reference sjlion reply: 3/f

Use SQL statements to build table
Price type, select a. a. discount type, b. at the field, b. finance that field, b. the boss from the field in a, b where a.x xx xx
=b.x
Type of edit with DDDW price, at, the finance department, the boss of the edit using the checkbox. Don't know what is DDDW (drop-down data window) and edit, to turn over a book,

Those fields in a table has, for example: xf_approvallevel: 1: application; 2: approval (at); 4: check (financial); 8: the examination and approval (the boss), the edit,, I just don't know how to let these three fields show in DW

Well, the three is a field of content

CodePudding user response:

Know about the case the when

CodePudding user response:

refer to 6th floor lsh370190322 response:

to know about the case when

Wrong, at the Treasury, the boss this several content in fields, such as: xf_approvallevel: 1: application; 2: approval (at); 4: check (financial); 8: the examination and approval (the boss)

CodePudding user response:

Crosstab style data window can be achieved,

CodePudding user response:

This is more troublesome, if use crosstab, seems not update,

CodePudding user response:

Dynamic with static SQL statement instead, modify the create, someone and you asked about the problem, you can achieve this in the grid,

CodePudding user response:

refer to 6th floor lsh370190322 response:

to know about the case when

Top of this, I think is coarser, not equal to the professional, case the when is better,