It's possible to use SGSV to create a dynamic "google-o-meter". Here's some sample code:

select '<img src="http://chart.apis.google.com/chart?chs=300x250&cht=gom&chd=t:'+CAST(datediff(d,'1/1/2011',getdate())*100/datediff(d,'1/1/2011','6/19/2011') as VARCHAR)+'&chxt=x,y&chxl=0:|Today+('+CAST(datediff(d,'1/1/2011',getdate())*100/datediff(d,'1/1/2011','6/19/2011')as VARCHAR)+'%)|1:|Started|Complete&chtt=||Completion+Status&chts=0000FF,20">' from portals where portalid = 1

Set the module to decode HTML so the the HTML is presented correctly. In this example, a calculation is performed to determine how much time has elasped between a start and end date. The query returns one record, but in this case it is a dummy return (i.e. no value) however the HTML executes a call to the google charting tool. Normally, this tool wants a single number however by concatenating the calcuation in the HTML string, a dynamic report is possible.

For background on the charting characteristics, refer to the Google Chart API page. Thought this might be of interest to folks.