Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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