cross tab export to text file

rbuser

have set up d2009 rb11.06
testing a crosstab save to text

cant seem to solve the problem that the out put text is not very usefull

I will try to explain what happens

Report looks Like

grower Date Reference Sum of Bins

1234 12-sep-2009 AB12 100
14-sep-2009 abv13 200
5678 15-sep-2009 bv365 50
bv456 100
9874 cv365 100
cz963 50


csv file looks like

grower ,Date,Reference, Sum of Bins
1234,22-sep-2009,AB12,100
14-sep-2009,abv13,200
5678,15-sep-2009,bv365,50
bv456,100
9874,cv365,100
cz963,50

when open this in xl all the colums are out of line
what we really want is all data items on each output line

something like ppDbText.SuppressRepeated Values = False so the output looks
somethig like

grower ,Date,Reference, Sum of Bins
1234,22-sep-2009,AB12,100
1234,14-sep-2009,abv13,200
5678,15-sep-2009,bv365,50
5678,15-sep-2009,bv456,100
9874,15-sep-2009,cv365,100
9874,15-sep-2009,cz963,50

any hints on how to solve this greatly appreciated

regards
Ian

nicocizik

Hi Ian,

Were you able to apply the patch I sent? The fix should at least insert an
empty string for all empty crosstab cells so the columns line up. If this
does not function correctly, please send a simple example to
support@digital-metaphors.com and I'll take a look at it.

The Textfile Device does not have any knowledge of which components or what
type of data it is exporting. It simply receives a page object containing
DrawText commands, then loops through them and outputs each one to a file.
If the text does not show up in the previewer, it will not be exported.

SuppressRepeated is done by definition in the CrossTab. We will consider
adding it as an option moving forward.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thank you very much for the explanation. Now understand more of what to
expect.

pretty sure we got 11.06 installed correctly and had assumed that
contained the patch so will do some more checking when I get a chance
Regars
Ian