I have a simple report that is being used to create an extract in CSV format. The problem is that all of the columns after the 23rd position are being moved to the front.
So instead of getting
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30
I'm getting
24,25,26,27,28,29,30,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23
This is making me nuts!!!
If I export directly from the CR Designer I don't have any problems.
If I export from InfoView to a different format like Excel, no problems.
So... I figured that there may be a goofy problem with the rpt file itself. So I rebuilt it from scratch. Still doing the same thing.
This only seems to be a problem when scheduling from CRS and exporting to CSV. I'm baffled!
(Yes I tried setting the schedule from the CMS... It does the same thing there too.)
Any help on this would be VERY appreciated.
Thanks in advance,
Jason