0 Replies Latest reply: Nov 13, 2012 10:50 AM by Dirk Groen RSS

    crosstable faillure if header field is nummeric

    Dirk Groen

      I have a prolbem with my flexible crosstable

      If the header is a nummeric value he doesn't work.

      Has anyone a suggestion to fix this problem?

       

      For example

       

      My table looks like

       

      Header 1Header 2Header 3
      01020
      104567
      204689

      The yellow field is my height header

      If it has the value A for example, everything works. But with a nummeric value, he can't make my height dimmension

       

       

      My script for the crosstable is like:

       

       

      Sub SubCrossTable
          
      Directory;
           Temp_CrossTable:
          
      CrossTable(Breedte, Prijs)
          
      LOAD
           *

          
      FROM
          
      $(vExcelDocument)
           (
      biff, embedded labels, table is $(vExcelTab)$, filters(
          
      Remove(Row, RowCnd(Interval, Pos(Top, $(vBovenBegin)), Pos(Top, $(vBovenEind)), Select(1, 0))),
          
      Remove(Row, RowCnd(Interval, Pos(Top, $(vOnderBegin)), Pos(Bottom, $(vOnderEind)), Select(1, 0)))
           ));
          
          
           Prijzen:
          
      load
           '$(vProductGroep)'&'#'&'$(vUitvoering)'&'#'&'$(vCollectie)'&'#'&'$(vPrijsGroep)'
      as SLT_PrijsGroep,
          
      $(vPrijsGroep) as Hoogte,
          
      Breedte,
          
      Prijs
          
      Resident Temp_CrossTable;
          
      drop table Temp_CrossTable;
      End Sub

       

      Who can help me with this question.

       

      Regards,

       

      Dirk