22nd September 2009

ASPAlliance Times

The industry newsletter for Active Software Professionals

Sponsor Advertisement

Database documentation tool

SQL Doc 2.0 is out now. Red Gate SQL Doc lets you create complete database documentation in just a few clicks, with output to HTML and MS Word. "This tool is embarrassingly easy to use." David Hayden. Download your copy here.

Featured Article

Agent XPs option is used to enable the SQL Server Agent extended stored procedures on the server. When this option is disabled, the SQL Server Agent node is not available in SQL Server Management Studio Object Explorer.

http://aspalliance.com/1884_SQL_Server_Agent__Agent_XPs_Disabled

Editor's Comments

Recently Microsoft announced that they will offer hosting of their AJAX JavaScript libraries on their own Content Deliver Network (CDN). In addition to the ASP.NET AJAX libraries, this will include the jQuery libraries that Microsoft supports. There are a few huge benefits to using a CDN for your infrastructure script libraries, and I’m very excited that Microsoft has responded to community feedback (including my own) requesting this feature. If you choose to have Microsoft host these libraries for your site, your first-time users will very likely already have these libraries in their browser cache (from other sites they’ve visited that use them). Thus, they won’t be delayed by having to download these files. Further, since you aren’t hosting these files (which are often referenced by nearly every page in a given web app), you won’t have to pay for the bandwidth required to serve these files, thus saving you bandwidth costs. You can learn more about the CDN (which is already available) here.

Also, today is the last day of the ComponentArt Summer Silverlight Coding Competition (and the last day of summer, too). You can check out the current list of contestants and (if you’re quick) get your submission in as well at: http://www.componentart.com/community/competition2009/

Steve's Blog

New Articles on ASPAlliance.com

View All Recent Articles »

Information should be presented not only in an easy to understand manner but also using the latest techniques and styles. It should not be irritable to the eyes and it is in this scenario Adobe Flash based products such as FusionCharts play a vital role. Will it meet your requirements? Anand puts the product to test to enable you to find out.

Sponsor Advertisement

Get your development team all moving in the same direction

NimblePros is an agile software development shop that provides training and mentoring to companies that wish to achieve greater success by implementing agile processes themselves.

With the help of NimblePros, your team can:

• Adopt agile software development processes
• Ship better code, more frequently
• React quickly to changing requirements

Go to NimblePros.com to learn more.

ASP Alliance Authors' Recent Blog Entries

More Blogs »

ASP Alliance Most Popular Articles

More Articles »

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.

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.

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.

Crystal Alliance Recent Articles

Sponsored by BusinessObjects

More Crystal Reports Resources »

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.

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.

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.

SQL Server Reporting Services Recent Articles

Sponsored by SoftArtisans

More SQL Server Reporting Services Resources »

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.

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.

This article examines the steps the author took to make the local reports work using Microsoft SQL Server Reporting Services in ASP.NET.

Sponsor Advertisement

Kentico Software Plants a Tree for Every Bug

August 28, 2009 – Kentico Software (http://www.kentico.com), the Web content management system vendor, today announced it will plant a tree for every bug found in the latest version of Kentico CMS for ASP.NET. The company also promises to fix all reported bugs within 7 days. It's a part of Kentico’s commitment to deliver a stable platform for managing web sites, on-line stores and social networks.

Clients can report bugs at trees.kentico.com where they can also see the current number of reported bugs. The trees will be planted by company employees at the end of this initiative in November 2009. Each tree will be devoted to the person who reported the bug first.

All information about the initiative is available at trees.kentico.com.