As shown in figure will annual press from big to small reverse order

CodePudding user response:

The great spirit under the younger brother

CodePudding user response:

Crosstab report scheduling problems
There are three data, dynamic field in aa 'ordinary' normal, 'quickly', 'experts',' scrape, now seems to be the alphabetical, the order is' quickly ', 'scrape' often 'ordinary', 'experts' please everybody to give directions how to sort by normal

-- -- -- -- -- -- solution -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Will your SQL statements by
The select aa,... The from TB
Change
The select aa,... , case aa 'ordinary' then the when 1 'quickly' then the when 2 'experts' then 3 when' scrape then 4 else may end as aa_sort

Then will aa_sort also dragged into, in the columns and rows on aa, then ok
Header in the dw @ aa_sort [2], some other columns moved to the Header [3], and will be the Header [2] height is set to 0

Refer to this...

CodePudding user response:

The

refer to the original poster qq_23953119 response:

As shown in figure will annual press from big to small reverse order

In SQL directly try in reverse chronological order

CodePudding user response:

Has been solved!!!!!!!!!!!!!!!!!!!!! 1111

CodePudding user response:

reference 4 floor qq_23953119 response:

has been solved!!!!!!!!!!!!!!!!!!!!! 1111

Generally done by SQL, solved the good, helpful hints, please junction post as soon as possible