ÿþ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>ASPAlliance Times - - 18th August 2009 </title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <style type="text/css"> <!-- .headingLink { text-decoration: none; font: bold 0.7em Arial, Helvetica, sans-serif; color: #CC0000; } .headingFeatureLink { text-decoration: none; font: bold 0.8em Arial, Helvetica, sans-serif; color: #CC0000; } --> </style> </head> <body bgcolor="#ffffff" link="#cc0000" vlink="#cc0000" text="#333333"> <!-- shell --> <table width="560" cellpadding="1" cellspacing="0" border="0"> <tr> <td align="center" style="font-family: Arial;"> <font size="1">Having trouble reading this e-mail? Read this or any of our past issues in our online <a href="http://aspalliance.com/newsletter">Newsletter Archive</a>. </font></td> </tr> </table> <table width="560" border="0" cellpadding="1" cellspacing="4" bgcolor="#cc0000"> <tr> <td valign="top" bgcolor="#ffffff"> <table width="550" border="0" cellpadding="1" cellspacing="0" bgcolor="#cc0000"> <tr> <td valign="top"> <!-- /shell --> <table width="600" cellpadding="2" cellspacing="0" style="background-color:#CC0000; border-width: 1px; border-color:#FFFFFF; border-top-color:#FFFFFF;"> <tr> <td align="right"> <div style="color: white; font-size: 0.7em; font-family: tahoma"> 18th August 2009 </div> </td> </tr> <tr> <td align="center"> <div style="font-size:3em; color: White; font-family: Georgia,Times New Roman"> ASPAlliance Times</div> </td> </tr> <tr> <td align="center"> <div style="font-size:1em; color: White; font-family: Georgia,Times New Roman; font-weight:bold"> The industry newsletter for Active Software Professionals</div> </td> </tr> <!-- Begin Top Advertisement --> <tr> <td align="right" style="background-color: #CCCCCC"> <div style="color: black; font-size: 0.7em; font-family: Arial"> Sponsor Advertisement</div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE"> <div style="color: black; font-size: 0.9em; font-family: Arial; font-weight:bold"> Scale Out Your Server Farm Applications. </div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> <p> Developing fast, scalable applications for server farms is a big challenge. Your applications must scale seamlessly as the farm grows to handle ever increasing load. </p><p> Today's developers have discovered that distributed caching is the key to reaching their performance goals. By keeping frequently accessed, fast-changing data close to where it's used and globally accessible across the farm, your applications will have the data they need, when they need it. </p><p> ScaleOut StateServer® is the performance leader in distributed caching for .NET applications. Best of all, it is production-proven <em>and</em> easy to use. </p><p><a href="http://www.scaleoutsoftware.com/redirect/aspall_nl001.html">Download a free evaluation copy</a> and get started today! </p> </div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px; padding-top: 5px; padding-bottom: 5px;"> <a href="" style="font-size: 0.7em;color:#CC0000;font-family:Tahoma;text-decoration:none;"> </a> </td> </tr> <!-- End Top Advertisement --> <!-- Featured Article --> <tr> <td align="left"> <div style="font-size: 1em; color: White; font-family: arial; font-weight: bold; padding-top: 5px;"> Featured Article</div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> &nbsp;</td> </tr> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1874_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_4_Dynamic_Grouping" class="headingFeatureLink"> Building Reports Using ASP.NET and Crystal Reports - Part 4: Dynamic Grouping </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> By Vince Varallo , 18th August 2009 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> In this fourth part of the series, Vince Varallo examines the creation of an employee report and demonstrates the usage of Crystal Reports object model to change the grouping fields and manipulate the properties of the group at runtime to show or hide sections, reset the page number, or insert a page break using Visual Studio 2008. He provides a step-by-step analysis of each procedure with the help of relevant screen shots and source code. </div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://aspalliance.com/1874_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_4_Dynamic_Grouping" style="color: #CC0000; text-decoration: none;"> http://aspalliance.com/1874_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_4_Dynamic_Grouping </a> </div> </td> </tr> <!-- End Featured Article --> <!-- Editor's Comments --> <tr> <td align="left"> <div style="font-size: 1em; color: White; font-family: arial; font-weight: bold; padding-top: 5px;"> Editor's Comments</div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> &nbsp;</td> </tr> <tr> <td align="left" style="background-color: #EEEEEE"> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Steven Smith </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> <p>Today the SQL Azure team released their first public community tech preview (CTP). You can read more at the <a href="http://blogs.msdn.com/ssds/archive/2009/08/18/9874133.aspx">official announcement</a>, or <a href="http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx">download it here</a>. More info from the announcement:</p> <p><strong>The SQL Azure</strong> Database CTP includes: </p> <ul> <li>Relational data model supporting <a href="http://msdn.microsoft.com/en-us/library/ms189826.aspx">Transact-SQL (T-SQL)</a>, including T-SQL stored procedures. Access SQL Azure with familiar data access APIs such as ODBC, OLE DB, ADO.Net, PHP, etc. The high degree of compatibility with SQL Server enables easy migration of existing Line of Business (LOB) or Web applications to the cloud.</li> <li>Self-provisioning, auto-healing and disaster recovery, with high availability and no physical database administration. Self service provisioning means you can provision any number of databases and not have to worry about machines, disks, or server configuration.</li> <li>Pay-as-you-grow multi-tenant scalable service model.</li> <li>Efficiencies from an enterprise class data center without the administrative overhead.</li> <li>Support for familiar tools so developers can leverage existing skills to speed time to solution</li></ul> <p>Also, on a different note, our featured article this week is the fourth in a series that teaches how to implement some commonly requested reporting features. Throughout the series, we have shown how to <a href="http://aspalliance.com/1831_Building_an_Invoice_Application_with_ASPNET_and_Crystal_Reports__Part_1">build an invoice application</a>, generate a <a href="http://aspalliance.com/1851_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_2__Quarterly_Sales_Report">quarterly sales report</a>, generate an <a href="http://aspalliance.com/1866_Building_Reports_using_ASPNET_and_Crystal_Reports__Part_3__An_Invoice_Report_Using_Disconnected_Data">invoice report with disconnected data</a>, and today how to <a href="http://aspalliance.com/1874_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_4_Dynamic_Grouping">change a report s grouping without creating a new report file</a>. View these and several other articles that teach how to use <a href="">Crystal reports here</a>.</p> </div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://stevesmithblog.com/" style="color: #CC0000; text-decoration: none;"> Steve's Blog </a> </div> </td> </tr> <!-- End Editor's Comments --> <!-- Begin New Articles Section --> <!-- End New Articles Section --> <!-- Begin Middle Advertisement --> <tr> <td align="right" style="background-color: #CCCCCC"> <div style="color: black; font-size: 0.7em; font-family: Arial"> Sponsor Advertisement</div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE"> <div style="color: black; font-size: 0.9em; font-family: Arial; font-weight:bold"> Stay connected to the experts you trust with DevMavens. </div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> <p> Visit the ALL-NEW community and philanthropic site - <b><a href="http://devmavens.com">DevMavens.com</a></b> to learn what the most trusted community leaders like Scott Guthrie, Rick Strahl, Jeffrey Palermo, Jeff Atwood and more are saying every day. </p><p><a href="http://devmavens.com">http://devmavens.com</a></p> </div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px; padding-top: 5px; padding-bottom: 5px;"> <a href="" style="font-size: 0.7em;color:#CC0000;font-family:Tahoma;text-decoration:none;"> </a> </td> </tr> <!-- End Middle Advertisement --> <!-- Begin Blog Posts Section --> <tr> <td align="left"> <div style="font-size: 1em; color: White; font-family: arial; font-weight: bold; padding-top: 10px;"> ASP Alliance Authors' Recent Blog Entries</div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://aspadvice.com/blogs/" style="color:#CC0000; text-decoration: none; font-size: 0.7.em; font-family: Arial">More Blogs »</a></div> </td> </tr> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://thedatafarm.com/blog/data-access/oslo-data-programmability-ef-ado-net-etc-teams-merge/" class="headingLink"> Oslo + Data Programmability (EF, ADO.NET, etc.) Teams Merge </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Julie </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://bhaidar.net/cs/archive/2009/08/17/columns-rows-silverlight-series-on-datagrid-aspnetpro.aspx" class="headingLink"> Columns &amp; Rows - Silverlight Series on DataGrid - ASPNETPRO </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> BilalHaidar [MVP] </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://www.bizsupportonline.net/blog/2009/08/store-infopath-vsta-projects-source-control-repository/" class="headingLink"> 2 Ways to store InfoPath VSTA projects in a source control repository </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> S.Y.M. Wong-A-Ton </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://community.devexpress.com/blogs/aspnet/archive/2009/08/17/how-to-download-a-beta-from-the-client-center.aspx" class="headingLink"> How To Download A Beta From The Client Center </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Mehul Harry (Developer Express) </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://feedproxy.google.com/~r/radicaldevelopmentnet/~3/qk3gV3OlVKU/" class="headingLink"> ASP.NET Tip: Take Your Application Offline </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Steven </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://weblogs.asp.net/coltk/archive/2009/08/17/best-practices-webcast-by-ineta-apac.aspx" class="headingLink"> Best Practices Webcast by INETA APAC </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Colt </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://weblogs.asp.net/coltk/archive/2009/08/17/powershell-script-with-asp-net-and-console-application.aspx" class="headingLink"> PowerShell Script with ASP.NET and Console Application </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Colt </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://weblogs.asp.net/coltk/archive/2009/08/17/data-refresh-failed-in-excel-services.aspx" class="headingLink"> Data Refresh Failed in Excel Services </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Colt </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://blog.davidyack.com/journal/2009/8/17/windows-7-upgrade-or-repave.html" class="headingLink"> Windows 7 Upgrade or Repave? </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> David Yack </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://feedproxy.google.com/~r/radicaldevelopmentnet/~3/Bg0V-wRjEjA/" class="headingLink"> Understanding SMTP Status Codes </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Steven </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://feedproxy.google.com/~r/radicaldevelopmentnet/~3/1JvkdzQdoaU/" class="headingLink"> Scott Hansleman Provides A Step-By-Step: How To  Upgrade from Windows XP to Windows 7 </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Steven </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://jamescbender.com/bendersblog/archive/2009/08/16/burn-down-your-house.aspx" class="headingLink"> Burn Down Your House </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> James Bender </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://bhaidar.net/cs/archive/2009/08/16/radcontrols-silverlight-3-official-with-q2-2009-sp1.aspx" class="headingLink"> RadControls Silverlight 3 Official with Q2 2009 SP1 </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> BilalHaidar [MVP] </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://weblogs.asp.net/steveschofield/archive/2009/08/15/ftp-7-5-blind-drop-article.aspx" class="headingLink"> FTP 7.5 blind drop article </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> steve schofield </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://www.bizsupportonline.net/blog/2009/08/add-use-data-connections-infopath/" class="headingLink"> InfoPath Training Video: Adding and Using Data Connections in InfoPath </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> S.Y.M. Wong-A-Ton </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://www.codedigest.com/Articles/ASPNET/281_Edit_Update_Delete_and_Insert_data_with_DataList_control_using_LINQ.aspx" class="headingLink"> Edit, Update, Delete and Insert data with DataList control using LINQ </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- Repeat for each blog post --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://stevesmithblog.com/blog/msdn-subscription-installer/" class="headingLink"> MSDN Subscription Installer </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold"> Steven Smith </span> </td> </tr> <!-- End Repeat for each blog post --> <!-- End Blog Posts Section --> <!-- Popular Article --> <tr> <td align="left"> <div style="font-size: 1em; color: White; font-family: arial; font-weight: bold; padding-top: 10px;"> ASP Alliance Most Popular Articles</div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://aspalliance.com/RecentArticles.aspx" style="color:#CC0000; text-decoration: none; font-size: 0.7.em; font-family: Arial"> More Articles »</a></div> </td> </tr> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/475_Make_Reports_Quickly_With_ASPNET_and_XML" class="headingLink">Make Reports Quickly With ASP.NET and XML </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Andrew Mooney , 7th July 2004 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> Sometimes you need to create reports quickly. You might not always have time to format fancy reports containing graphs. Or maybe you have to create reports that do not need graphs. Reusing one ASP.NET web page you can display many reports. </div> </td> </tr> <!-- End Repeat for each article --> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1125_Dynamically_Templated_GridView_with_Edit_Delete_and_Insert_Options" class="headingLink">Dynamically Templated GridView with Edit, Delete and Insert Options </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By G Mohyuddin , 22nd January 2007 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> In this article the author presents a comprehensive solution to build a GridView with template fields generated at run time with in-place Insert, Delete and Edit operations with a full description of an effective implementation and usage of ITemplate interface. </div> </td> </tr> <!-- End Repeat for each article --> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/895_Understanding_the_JavaScript___doPostBack_Function" class="headingLink">Understanding the JavaScript __doPostBack Function </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Mohammad Azam , 20th June 2006 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> In this article we will look into the __doPostBack function of JavaScript. Read the article to find some insights about the function. </div> </td> </tr> <!-- End Repeat for each article --> <!-- End Popular Articles --> <!-- Crystal --> <tr> <td align="left"> <div style="font-size: 1em; color: White; font-family: arial; font-weight: bold; padding-top: 10px;"> Crystal Alliance Recent Articles</div> </td> </tr> <tr> <td align="left" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://businessobjects.com/" style="color:#CC0000; text-decoration: none; font-size: 0.7.em; font-family: Arial">Sponsored by BusinessObjects</a></div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://aspalliance.com/crystal" style="color:#CC0000; text-decoration: none; font-size: 0.7.em; font-family: Arial">More Crystal Reports Resources »</a></div> </td> </tr> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1874_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_4_Dynamic_Grouping" class="headingLink">Building Reports Using ASP.NET and Crystal Reports - Part 4: Dynamic Grouping </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Vince Varallo , 18th August 2009 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> In this fourth part of the series, Vince Varallo examines the creation of an employee report and demonstrates the usage of Crystal Reports object model to change the grouping fields and manipulate the properties of the group at runtime to show or hide sections, reset the page number, or insert a page break using Visual Studio 2008. He provides a step-by-step analysis of each procedure with the help of relevant screen shots and source code. </div> </td> </tr> <!-- End Repeat for each article --> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1866_Building_Reports_using_ASPNET_and_Crystal_Reports__Part_3__An_Invoice_Report_Using_Disconnected_Data" class="headingLink">Building Reports using ASP.NET and Crystal Reports - Part 3 - An Invoice Report Using Disconnected Data </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Vince Varallo , 20th July 2009 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> In this third part of the series, Varallo shows how to rebuild the Invoice created in Part 1 using disconnected datasets instead of connecting directly to the database. This gives the user the flexibility to manipulate the data and implement rules in a c# business class rather than in the report. He provides a detailed overview of each concept in a step-by-step manner supported with screen shots and source code. </div> </td> </tr> <!-- End Repeat for each article --> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1861_How_to_handle_multiple_queries_simultaneously_in_Crystal_reports_connecting_from_Business_object_Universe" class="headingLink">How to handle multiple queries simultaneously in Crystal reports connecting from Business object Universe. </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Umesh Bansal , 24th June 2009 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> We have come across a situation where we have to generate the report from more then 2 queries using crystal reports. All queries are different -- 2 transaction tables with relevant joins from dimension tables. So to make the report we have to create 2 different connections from the universe and it eventually gave performance problems when dealing with a large sets of records. In this case, we have to link each query with the others on the basis of common dimensions. While fetching a report with a large amount of data, it takes a lot of time to complete. </div> </td> </tr> <!-- End Repeat for each article --> <!-- End Crystal --> <!-- SSRS --> <tr> <td align="left"> <div style="font-size: 1em; color: White; font-family: arial; font-weight: bold; padding-top: 10px;"> SQL Server Reporting Services Recent Articles</div> </td> </tr> <tr> <td align="left" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://softartisans.com/" style="color:#CC0000; text-decoration: none; font-size: 0.7.em; font-family: Arial">Sponsored by SoftArtisans</a></div> </td> </tr> <tr> <td align="right" style="background-color: #FFFFFF"> <div style="color: black; font-size: 0.7em; font-family: Arial"> <a href="http://aspalliance.com/sql-reporting" style="color:#CC0000; text-decoration: none; font-size: 0.7.em; font-family: Arial">More SQL Server Reporting Services Resources »</a></div> </td> </tr> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1617_Creating_Agile_Project_Reports_with_TFS_and_Reporting_Services__Part_2" class="headingLink"> Creating Agile Project Reports with TFS and Reporting Services - Part 2 </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Eric Landes , 7th April 2008 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> In this second part of the series, Eric shows the reader how to create a burndown chart using Reporting Services, Visual Studio 2008, and Team Foundation Server (TFS) 2008 for an agile project. After giving a short introduction and the requirements, he examines the creation of burndown reports with the help of relevant SQL statements and screen shots. </div> </td> </tr> <!-- End Repeat for each article --> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1585_Creating_Agile_Project_Reports_with_TFS_and_Reporting_Services__Part_1" class="headingLink"> Creating Agile Project Reports with TFS and Reporting Services - Part 1 </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Eric Landes , 19th February 2008 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> In this first part of the series, Eric shows the reader how to create two reports using Reporting Services, Visual Studio 2008, and Team Foundation Server (TFS) 2008 for an agile project. After giving a short introduction and the requirements, he examines the creation of scenario story report with the help of relevant SQL and screen shots. </div> </td> </tr> <!-- End Repeat for each article --> <!-- Repeat for each article --> <tr> <td align="left" style="background-color: #EEEEEE"> <a href="http://aspalliance.com/1318_Using_Local_Microsoft_SQL_Server_Reporting_Services_in_ASPNET" class="headingLink"> Using Local Microsoft SQL Server Reporting Services in ASP.NET </a> <br /> <span style="font-size: 0.7em; color: black; font-family:Tahoma; font-weight: bold">By Shaun Eutsey , 12th July 2007 </span> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> This article examines the steps the author took to make the local reports work using Microsoft SQL Server Reporting Services in ASP.NET. </div> </td> </tr> <!-- End Repeat for each article --> <!-- End SSRS --> <!-- Bottom Advertisement --> <tr> <td align="right" style="background-color: #CCCCCC"> <div style="color: black; font-size: 0.7em; font-family: Arial"> Sponsor Advertisement</div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE"> <div style="color: black; font-size: 0.9em; font-family: Arial; font-weight:bold"> Filter the noise from the clouds </div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px;"> <div style="color: black; font-size: 0.8em; font-family: Arial"> <p> All things Azure now can be found together on one common site without the noise common on most blogs. Find collections of blogs and other Azure news and content sites with the click of a button. <a href="http://azurefeeds.com">Click here</a>. </p> </div> </td> </tr> <tr> <td align="left" style="background-color: #EEEEEE; padding-left: 25px; padding-top: 5px; padding-bottom: 5px;"> <a href="" style="font-size: 0.7em;color:#CC0000;font-family:Tahoma;text-decoration:none;"> </a> </td> </tr> <!-- End Bottom Advertisement --> </table> <!-- close shell --> </td> </tr> </table> </td> </tr> </table> <!-- /close shell --> </body> </html>