Posts Tagged ‘XML’

Reporting from the Federal IT Dashboard

May 17, 2012 Leave a comment

The website provides the public with a view on the federal IT budget.   It contains a variety of data sources and in particular provides the ability to download data to XML files.   Go to the Data Feeds tab to select your data.

After you download your selected file, you can choose this file from the Report Designer, using the  “XML Data Path” property of the report.  See the Post about XML Reporting.

If you choose the Exhibit 53 data source from the website and choose all the fields, your Field List window will then look like the following figure.   Here Sunset Reports parses the XML file and selects the fields in the file.   Now you can create your own graphs and reports about the federal IT Budget.   This is just one example of how you can get web data and feed it into a report.

XML Data Reporting

April 29, 2012 Leave a comment

Sunset Reports can connect directly to XML data files.  Using the XML Data Path property, browse to the XML file.   The data contained in the file including the schema is now available as a data source for your report.