Anyone done this already that you know of? Is it available somewhere? It is not in the vfptoolkit for .net that I can see... I ask because one option (of course) is to do the crosstab for each report that in vfp called vfpxtab manually in C# or in sql (another option) but I'd like to know if anyone has done an equivalent in C# to the vfpxtab function already. (vfpxtab stored in _genxtab)
I know that Cross tab and pivot tables can be handled:
In C# code
Using linq
In a stored proc (sql)
Using the infragistics grid
In the rdlc itself
but I am trying to determine if it makes sense to do a generic class that behaves similarily like the vfpxtab.prg for rewriting vfp report programs in C#/SSRS (stored procs are the last option).
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"