1. 

   JimTer, Member

   I have a problem with a crosstab.

   I can order de vertical values, but the horizontal ones do not react on my commands.

   Select Domein1start as Startmeting, Domein1eind as Eindmeting,
   (case when (Count(Domein1start) = 1 or Count(Domein1eind) = 1) and (Domein1start is null or Domein1eind is null) then '' else Count(Domein1start) end) as ''
   from tmp_verschillen_crosstab_conclusie tv
   group by Domein1start, Domein1eind
   order by 1 asc, 2 asc;
2. 

   JimTer, Member

   i forgot this one:

   select 'dbr.crosstab', 'Eindmeting';
3. 

   myDBR Team, Key Master

   See documentation about the crosstabs and predefining the data column order.

   --
   myDBR Team
4. 

   JimTer, Member

   Thank you. That helps me.

Reply

You must log in to post.