April 30, 2010 at 9:19 am
Just a couple of questions really, and a suggestion...
Does the HR system pull the information in automatically directly from the report or does it pull it in from an outputted file (exported from SSRS)?
I must admit I wouldn't use SSRS to do this at all although I haven't had the need. I would look at SSIS (it has an XML Task which might be just what you need) or even an proc which returns XML which your system can connect with.
April 30, 2010 at 9:51 am
There ae files although this process was not written with a great deal of common sense.
I would love to be able to read the file and in fact my first thought was to just display the xml file.
The problem is that the files are named with a key that does not relate to the data in the table in any way. The xml code itself is stored in the table when an error occurs and thus the reason I need to be able to simply display that code. we actually have a process in place now that does this with some limitations. We parse the xml code out inserting a Char(13) after each closeing tag. we can do this since the closing tag always ends with a ">+space" There are a few exceptions and it is not a perfect process but better than displaying on a single line. My hope however was to find a way to display it as a true xml format either by linking to a file or directly in SSRS.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply