my blog RSS 2.0
 Friday, April 02, 2004

In reply to Tom Rizzo's post Bryant Likes questions why you would want to export a report to XML, and Tom provides a useful reply. I'd like to add how I found this feature useful too:

Lets say you have a report where, for the sake of readbility, you have indented some of the text, and you also have quite a bit of grouping going on. Lets also say you have a user who likes playing around with the data in Excel using pivot tables and all that kind of stuff, and to be honest, you would rather leave them to decide how they want to arrange the data rather than trying to get a fixed spec off them which might not then suit somone else's needs. If they export direct to Excel, they get the data arranged in the same grouping and indenting and they can't easily manipulate it. If however they are willing to do this in two steps (ok, you'll need to give them a bit of training) they can export to XML, then import in to Excel 2003 and they can pick and choose the fields they want to display, and where, because Excel can work out the schema all by itself (well, sometimes!).

Friday, April 02, 2004 3:40:00 PM (GMT Standard Time, UTC+00:00)  #    Comments [0] -
Reporting Services
Archive
<April 2004>
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2008
Rohan Cragg
Sign In
Statistics
Total Posts: 24
This Year: 0
This Month: 0
This Week: 0
Comments: 42
Themes
Pick a theme:
All Content © 2008, Rohan Cragg
DasBlog theme 'Business' created by Christoph De Baene (delarou)