I seem to be experiencing some problems in relation to variables that I'm using within a dataset, and also Copying out said information.
The process that I am running is executing an SQL select to generate some data, this data is then 'parsed' through a couple of different substitutes to generate 4 outputs, one for a WebViewer, one for a Browsers (HTML) format, one for a CSV output, and another for a Tab limited copy/paste to Excel task.
Within the system, this has worked flawlessly for well over a year, but I seem to be experiencing some problems with the variables, and what seems to be missing data.
Here is an example of a data set that has generated correcly;
This has run correctly, and produces all 4 of the required outputs perfectly. Please note the items that I've maked, and this is where the problem seems to be happening.
I've Re-run this from an alternative report/dataset and this is what has happened;
Note; the script is the same, I'd just added a step that I disabled to see if I could fix the problem by using a direct write, the same result happened.
If I take the 'Length' function out of the dataviewer, and then try and copy out the data from teh DataViewer, I also end up with the shorter results, (the 9k items).
I've checked the raw data, in search of potential 'bad' characeters that might cause some sort of problem, but I can't seem to find anything suspect.
Has anybody else experienced this type of problem, and know what I might need to do to fixed this?