Creating a Crosstab Report in Visual Studio 2005 Using Crystal Reports
page 1 of 6
Published: 19 Oct 2006
Abstract
This tutorial describes the various steps in generating a cross-tab report using the Crystal Report elements that are integrated with the Visual Studio 2005 default installation.
by Jayaram Krishnaswamy
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 119897/ 140

Introduction

Reporting is one of the major tasks in any enterprise and reporting software occupies a prominent position in enterprise software suite.  There are multitudes of reporting software vendors; among them Crystal Reports has a large following with a variety of products designed for size and costs ranging from small business to enterprise.  It is relatively easy to retrieve data from a database and display it using any of the bound controls. This is especially so in ASPNET 2.0 where the amount of code you need to write has been drastically reduced.  However, to present the data in a formal, board-room friendly format and distribute it in hardcopy or for look-up is challenging.

Microsoft has been bundling Crystal reports ever since the VB days and it ships with every version of VS2005 as it did with VS2003.  It is well integrated with VS Studio 2005 and uses the VS enhancements in useful and intelligent ways.  It makes use of themes, smart tags, css styling, reporting source and data source control features, automatic data binding and many other features of ASPNET 2.0.  For highly functional and aesthetically pleasing, web and window based report generation, Crystal Report is ideally suited.  It is very versatile and can use data from a variety of databases and other non-traditional sources.  The version that comes with the default install of VS 2005 needs to be upgraded to Crystal Reports 11 to use even more enhancements.


View Entire Article

User Comments

Title: Show chart of row in cross-tab   
Name: letamuns
Date: 2012-02-20 12:01:53 AM
Comment:
Hi! Thanks for your article. In case: I want to have a link of every row, when I click it, the crystalreportviewer show a chart for that row.
Title: how to print value   
Name: nithya
Date: 2011-10-08 2:58:28 AM
Comment:
how to print the values in between section4 and section5 in crystal report in asp.net
Title: Cross Tab Report   
Name: Bharti
Date: 2011-08-02 10:51:33 AM
Comment:
Hi!

Thanks for a helpful article. I have created a cross tab report and need to modify the order of records. I am sorting a field by specified order and have added another one to the sort field. At this point the records were all sorted correctly and easily. My report is not recognising this new data which I have added. I removed the sort and when I run the report the same sort is still in the report. What am I doing wrong?

Thank you.
Title: thanks   
Name: manisha
Date: 2011-06-06 5:45:03 AM
Comment:
excellent thanksssss
Title: CR   
Name: Engineer
Date: 2011-05-31 1:45:38 AM
Comment:
Thnx..helpful article
Title: Very Good   
Name: Very Good
Date: 2011-05-21 5:33:45 AM
Comment:
Thanks,
This article is very helpful.
Title: Cross tab   
Name: Reda Karim
Date: 2011-05-08 10:35:36 AM
Comment:
Thanks very much it was very helpful for me
Title: Cross tab   
Name: Gaja
Date: 2010-08-11 2:49:20 AM
Comment:
How to remove summarized field in cross tab option
Title: Crystal report cross tab   
Name: Suhail
Date: 2010-05-31 4:30:32 AM
Comment:
Hello Sir,I have the same problem in cross tab that is there is no sum in Summary field of cross tab can u pls help me how to include that
Title: Cross Tab   
Name: das
Date: 2010-04-22 7:06:56 AM
Comment:
Hi,
Is it possible to enable the "Can grow"(Fig 30) propery of a field?
If no,What is the solution?
Title: How to make a cross-tab reprt without summarizing any field?   
Name: Vicky
Date: 2010-02-26 1:31:37 AM
Comment:
Sir i've developed a Time Management System in which emplyees attendance is stored.
I've to make a cross tab report for this project, in which i've to mention Incoming Time, Outgoing etc.
But i dont have to summarize any field.
Please help me out in this regard.

Advance Thanx
Vicky
Title: CrossTab   
Name: ABJ
Date: 2009-10-03 2:13:58 AM
Comment:
Really Great.. 100 points to you.. :-)
Title: Cross Tab Crystal Report   
Name: Jayaram Krishnaswamy
Date: 2009-07-15 12:31:55 PM
Comment:
Hi Deepak,

If you would let me know how you are doing this with some more details I may be able to help you. I replied to your email instead of commenting here.

Cheers,

Jay
Title: crosstab crystal report   
Name: deepak
Date: 2009-06-03 1:23:35 AM
Comment:
sir i am not getting the sum function in the drop down list just below the summary filed in the cross tab .....

can u please help.....
i will be thankful..
regards
deepak

Product Spotlight
Product Spotlight 



Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-04-29 7:31:33 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search