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 1 | Header 2 | Header 3 |
---|
0 | 10 | 20 |
10 | 45 | 67 |
20 | 46 | 89 |
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