Archive

Posts Tagged ‘Web Queries’

Use the Web as a Data Source

June 19, 2012 Leave a comment

As you have probably already seen, Sunset Reports can use an Excel Workbook as a data source.  Excel has the ability to pull data from a Web Page using what is called a Web Query.   When you are in Excel choose the Data tab on the ribbon bar, and then choose the item “From Web”.   You can pull data from a section of a web page and have it inserted into a worksheet.   If the inserted data is formatted with headers, give it a range name, and now you have a web based data source.   Be sure to setup the options to have the data extracted when Excel is opened so the data is refreshed automatically.

US Census Data

June 9, 2012 Leave a comment

There are a number of datasets you can download and feed into Sunset Reports from the US Census Bureau.   The datasets are numerous and are downloaded as csv files.   Sunset Reports can directly link to these files using the Query Builder and connecting to a CSV Folder.   Each CSV file becomes a table object and you can actually create data sources linking multiple CSV files.   The reporting opportunities are endless.

Include Web Image in Report

May 15, 2012 Leave a comment

Here is a real cool feature of Sunset Reports.   You can easily include an image from a webpage into your report.   Whenever the report is run, the image is grabbed from the web and included in the report.   It is current and up to date.   What kind of images can be included?   There is essentially no limit.   Include stock charts, weather radar, traffic, or whatever is available.

The secret to getting this to work is to add a Picture Box to your report.  Then add the URL of the web image in the property “ImageURL”.  This property supports both absolute and relative paths.  An absolute URL provides the complete path and is what you will use to get a web image.   Note:  You will also want to adjust the “Sizing” property.   “Stretch Image” will probably work best.

Here are some URL’s to try…

http://images.intellicast.com/WxImages/Radar/usa.gif

http://chart.finance.yahoo.com/t?s=%5eDJI&lang=en-US&region=US&width=300&height=180

http://www.google.com/finance/chart?cht=c&q=INDEXDJX:.DJI,INDEXSP:.INX,INDEXNASDAQ:.IXIC&tlf=12h

A sample report is also available for you to download HERE.

Reporting from the Web

July 26, 2011 Leave a comment

If you need the ability to include Web data in a report, here is a great method.  Using Excel gives you the ability to get data from the Web.   The data comes from tables that exist on web pages.   You create a web query in Excel 2010 by going to the Data tab on the ribbon bar, then selecting the icon “From Web”.   Using the New Web Query dialog, select a data table on the web page.   Once you click “Import”, the data is loaded onto the worksheet and the data range is given a name.   You can change the name if you want.   Now, with a named range, Sunset Reports can directly read the data and you have a data source for your report.

We have plans to include Web RSS feeds as a data source for a report as well as capturing an image of a webpage and placing it in a report.   These changes are currently in development.