http://smsug.ca/blogs/garth_jones/archive/2007/05/11/342.aspx1) Follow the KISS principal 2) Always use the views not the tables for your SQL queries 3) Keep report to a 4-5 columns 4) Try to limit the number of views used within each SQL query 5) Keep the drill through column as the first column 6) Try to linkenCommunityServer 2007.1 (Build: 20917.1142)http://smsug.ca/blogs/garth_jones/archive/2007/05/11/342.aspx#1590Sun, 18 Jan 2009 16:44:03 GMT14e2e6c5-d9ae-44b8-b26c-f91197d8b563:1590Report of HW Inventory to include IP Address | keyongtech<p>Pingback from &nbsp;Report of HW Inventory to include IP Address | keyongtech</p> <img src="http://smsug.ca/aggbug.aspx?PostID=1590" width="1" height="1">http://smsug.ca/blogs/garth_jones/archive/2007/05/11/342.aspx#1438Thu, 14 Aug 2008 14:59:41 GMT14e2e6c5-d9ae-44b8-b26c-f91197d8b563:1438Garth's Blog<p>During a discussion on the myITforum ConfigMgr /SMS mailing this statement was made “ It’s never bad</p> <img src="http://smsug.ca/aggbug.aspx?PostID=1438" width="1" height="1">http://smsug.ca/blogs/garth_jones/archive/2007/05/11/342.aspx#1435Thu, 14 Aug 2008 14:22:29 GMT14e2e6c5-d9ae-44b8-b26c-f91197d8b563:1435Garth Jones<p>During a discussion on the myITforum ConfigMgr /SMS mailing this statement was made “ It’s never bad</p> <img src="http://smsug.ca/aggbug.aspx?PostID=1435" width="1" height="1">http://smsug.ca/blogs/garth_jones/archive/2007/05/11/342.aspx#864Sun, 30 Dec 2007 20:07:06 GMT14e2e6c5-d9ae-44b8-b26c-f91197d8b563:864Garth Jones <br> <br> <br> <br> <br> <br> <br> <br> <br>&amp;amp;nbsp;&amp;amp;nbsp; <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> &nbsp;Total <br> &nbsp; <br> &nbsp;Title...<img src="http://smsug.ca/aggbug.aspx?PostID=864" width="1" height="1">http://smsug.ca/blogs/garth_jones/archive/2007/05/11/342.aspx#596Thu, 06 Sep 2007 14:04:00 GMT14e2e6c5-d9ae-44b8-b26c-f91197d8b563:596Garth JonesIt has been a while since I did my top 25 post. There are some interesting results. <br>&amp;amp;nbsp; <br> <br> <br> <br>...<img src="http://smsug.ca/aggbug.aspx?PostID=596" width="1" height="1">http://smsug.ca/blogs/garth_jones/archive/2007/05/11/342.aspx#343Fri, 11 May 2007 17:24:24 GMT14e2e6c5-d9ae-44b8-b26c-f91197d8b563:343Rod Trent at myITforum.comGarth&amp;amp;rsquo;s guideline for creating web reports<img src="http://smsug.ca/aggbug.aspx?PostID=343" width="1" height="1">