Creating Sub-Reports Using Crystal Reports
page 1 of 4
Published: 11 Jul 2008
Abstract
This article demonstrates the creation of sub-reports using Crystal Reports. After providing a short overview of the database design, the author delves deeper into the report building process in a series of steps with associated screenshots. Towards the end of the article, he shows us how to display the report on a web page.
by Mohammad Azam
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 99018/ 136

Introduction

Reports allow the user to view the complex data in a readable format. The data can be stored in a variety of places and can be pulled out by the reporting tool to generate a user friendly report. In this article we will demonstrate how to create sub reports using Crystal Reports.


View Entire Article

User Comments

Title: 2012 NFL jerseys   
Name: NIKE NFL jerseys
Date: 2012-05-20 11:39:12 PM
Comment:
[/pre]Cheap NFL,NBA,MLB,NHL
[url=http://www.jersey2shop.com/]Jerseys From China[/url]
[url=http://www.jersey2shop.com/]2012 nike nfl Jerseys[/url]
[url=http://www.jersey2shop.com/]cheap China Jerseys[/url]
[url=http://www.jersey2shop.com/]Sports Jerseys China[/url]
[url=http://www.jersey2shop.com/NFL-Jerseys-c68/]NFL Jerseys China[/url]
[url=http://www.jersey2shop.com/NBA-Jerseys-c77/]NBA Jerseys China[/url]
NHL Jerseys China
[url=http://www.jersey2shop.com/MLB-Jerseys-c94/]MLB Jerseys China[/url]NFL jerseys For Sale online.All Our Jerseys Are Sewn On and Directly From Chinese Jerseys Factory
[/pre]
[pre]We Are Professional China jerseys Wholesaler
[url=http://www.cheapjersey2store.com/]Wholesale cheap jerseys[/url]Cheap mlb jerseys
[url= http://www.cheapjersey2store.com/]2012 mlb all atar jerseys[/url]
[url= http://www.cheapjersey2store.com/ [/url]Cheap China Wholesael[/url]
[url= http://www.cheapjersey2store.com/]Wholesale jerseys From China[/url]
[url=http://www.cheapjersey2store.com/]2012 nike nfl Jerseys[/url]Free Shipping,Cheap Price,7 Days Deliver
[/pre]
[/pre]
We are professional jerseys manufacturer from china,wholesal
sports [url= http://www.cheapjersey2store.com/]Jerseys From China[/url]
[url=http://www.cheapjersey2store.com/NFL-Jerseys-c68]NFL jerseys China[/url]
[url=http://www.cheapjersey2store.com/NHL-Jerseys-c96/]NHL Jerseys China[/url]
[url=http://www.cheapjersey2store.com/NBA-Jerseys-c77/]NBA Jerseys China[/url]
[url=http://www.cheapjersey2store.com/MLB-Jerseys-c94/]MLB Jerseys China[/url]
[url= http://www.cheapjersey2store.com/]China Jerseys[/url],Free Shipping
[/pre]
[/pre]
We are professional jerseys manufacturer from china,wholesal
sports [url= http://www.jerseycaptain.com/]cheap jerseys sale online [/url]
[url= http://www.jerseycaptain.com/]2012 nike nfl Jerseys[/url]
[url=http://www.jerseycaptain.com/NFL-Jerseys-c68]cheap NFL jerseys China[/url]
[url=http://www.jerseycaptain.com/NHL-Jerseys-c96/]NHL Jerseys C
Title: Picture not displayed   
Name: pppp
Date: 2012-03-15 9:07:37 AM
Comment:
please make the pictures to be opened in any environment...
Title: subreports in crystal report?   
Name: Rajan
Date: 2012-02-23 7:26:21 AM
Comment:
I have created a Report and i want to add one to one subreport ,and in subreport i want another subreport
upto what extend i can keep calling the sub reports in reports

Please suggest some idea and if possible provide some articles..

Thanks in advance
Title: Nice one   
Name: H.Bilal Tariq
Date: 2011-02-11 1:34:09 AM
Comment:
This article is very useful like your other one. May you please explain a bit more that if we use dataset as data source then how can we handle subreport in CS file?

Please respond me on aspsage@yahoo.com
Title: VERY GOOD   
Name: BHUP
Date: 2010-09-28 5:55:01 AM
Comment:
Nice work
Title: Very Nice   
Name: keerthi
Date: 2010-09-02 7:52:38 AM
Comment:
Hi Mr Mohammad Azam,I am keerthi, i read ur article, its very help full to me.... because i am a beginer for crystal reports..............
Title: Mr.   
Name: Raghavendra
Date: 2010-08-19 5:36:23 AM
Comment:
Hi, this is what i am following to generate the reports and subreport. but still i have a problem with ub report, i am using ondemand subreport but when i click on the field sub report is not generated, can someone help me on this. how to make it work
Title: Great Work   
Name: Atif Shah
Date: 2010-07-31 10:10:51 AM
Comment:
Thanks a lot for such a nice post.
Title: Thank You   
Name: Lakshmi
Date: 2010-04-19 4:10:31 PM
Comment:
Thanks for detail information
Title: Gr8 work   
Name: Ashish
Date: 2009-12-31 12:53:46 AM
Comment:
You hv done a great work..!!
Title: Very Good   
Name: MG
Date: 2009-12-08 12:02:18 PM
Comment:
Very neatly explained...Very easy to understand the steps and reasons. Thanks!!
Title: Thank you!   
Name: Lisa
Date: 2009-11-23 11:31:19 AM
Comment:
I have been looking for help with this for a while - your steps were so easy to understand. Thanks!!
Title: Impressed   
Name: Salil
Date: 2009-10-27 12:55:04 PM
Comment:
you rock..thanks a lot..
Title: Thanks   
Name: Krishna
Date: 2009-10-05 4:00:37 AM
Comment:
Amazing....Thanks a lot for your help in understanding sub reporting in crystal reports.

Can you let me know how we are supposed to do the same withput using "ReportSource" and by using code in the Script..

My EMail ID is kkumar181286@gmail.com

Thanks a million...
Title: Subreport Printing   
Name: Pankaj Rai
Date: 2009-09-24 2:35:18 AM
Comment:
Hi,
I am creating subreport using dataset .It's working fine but.When I click on print page will went to main report.
What I have to do .Please reply ASAP.


Thanks in Advance
Title: SUBREPORTS   
Name: Steve
Date: 2009-09-01 9:53:30 AM
Comment:
Hi I am creating a wrapper to house 9 sub-reports (because they have to print in order and the sql code is copywritted), problem is that i will be passing parameters to the rpt,from a user-interface and I am having issues figuring out how to code it in crystal. Could you please help??
Title: As usual Great article for guyz like me   
Name: Jay
Date: 2009-06-07 2:29:35 PM
Comment:
One nice thing about Azam is, just follow his doc you will become good developer. i like his comments and screen shots. Thans a lot Azam.
Title: subreport   
Name: Thanasekaran
Date: 2009-05-04 5:45:24 AM
Comment:
Hi
I am creating a sub report and it's working fine
the problem is in run time the curser move to sub report it's show the hand Symbol and if it's click that time main report are hiden
how to control this problem
pls help
Title: Dr   
Name: Desouki
Date: 2009-05-02 6:14:55 AM
Comment:
very useful article, thanks
Title: Crystal SubReport   
Name: madhu
Date: 2009-04-20 5:01:59 AM
Comment:
Sir

I am using crystal 11 and i hv created a main report and want to insert 2-3 sub reports but data is not comming in sub reports, pl help me.
Title: Crystal SubReport   
Name: Ravi
Date: 2009-03-20 9:02:29 PM
Comment:
Sir

I am using crystal 11 and i hv created a main report and want to insert 2-3 sub reports but data is not comming in sub reports, pl help me.
Title: Sub Reportimg   
Name: Prashanth A
Date: 2009-02-03 1:13:55 AM
Comment:
This article is great!!!!!!!!! and gives all the information in a very understandable format thanks for such a great article .
keep up the good work
Title: Subreporting   
Name: Gunjan Singh
Date: 2008-12-31 5:21:35 AM
Comment:
This aricle is very useful sir.
I got good concept from this
Thanks
Title: subreport   
Name: jaipalreddy
Date: 2008-11-18 5:50:12 AM
Comment:
this artical is super......and gives all the information in a very understandable format thanks for such a great article .keep up the good work.
Title: Sub reports article on CR   
Name: prashanti t
Date: 2008-10-21 1:30:26 PM
Comment:
this article is great!!!!!!!!! and gives all the information in a very understandable format thanks for such a great article .keep up the good work.
Title: Sub reports article on CR   
Name: Colin Gray
Date: 2008-08-12 5:50:43 PM
Comment:
Hi Mohammad,

Thanks for the article on sub reports. They're often great to use and can get report developers out of sticky positions. I would be careful about showing subreports for situations that can be address with groupings though... Sub Reports, especially dropped into detailed sections, can have a significant impact on performance. Many developers use them to mash data together where links in the database don't exist or to position the data more with more flexibility. Just thought I would comment.

cheers

Colin Gray
Developer Marketing Manager
Business Objects, an SAP company.
Title: nice information   
Name: anver
Date: 2008-07-25 6:20:26 AM
Comment:
thnx azam to share such avaluable stuff of ctystal report with us.
continue ur sharing and expand knowledge for us in future.
have a nice future

Product Spotlight
Product Spotlight 



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


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-10-17 6:20:05 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search