< Blog

SCCM 2007 Conversion Tool for ASP Report, Chart – Hourly advertisement completion status

When converting native Microsoft SCCM 2007 ASP reports to SSRS reports a few of them don’t convert correctly. Enhansoft has corrected this issue in reports where we know this problem exists.

The latest free conversion tool that you can download from our website is for Chart – Hourly advertisement completion status.

What we did:

 

  • Added Chart
  • Centered Table
  • Fixed Prompt
  • Fixed Prompt Text
  • Very minimal changes to SQL to allow for it to work within SQL BI tool
  • Filtered out “0” results within SQL
  • Updated Footer
  • Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation.
  • Some SQL formatting to allow for readability

Here is a sample output:

Chart - Hourly advertisement completion status