I want to create a summary report with crystal report

Posted by Asad1605 under ASP.NET on 12/15/2010 | Points: 10 | Views : 3137 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Pls help. I want to create a summary report using crystal report.

I want my report in this form:
ProductName Sale(2009) Sale(2010)
ProdA 250 561
ProdB 360 150
---------------------------------------------
Grand Totral 610 711
------------------------------------------------

I have two table
1. product master
2. Sales

ProductMaster
-------------
ProdName ProdCode
ProdA 01
ProdB 02

Sales
------- ProdCode Sale City Year
01 35 Mumbai 2009
01 60 Delhi 2008
02 150 Delhi 2009

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Karthikanbarasan on: 1/5/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

0	Hi, Hope you know on how to arrange the DB table column contents to the crystal reports view... after adding the contents and use the SUMMATION button to get the results in the footer view.. Thanks Karthik www.f5Debug.net Asad1605, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Prameena on: 1/25/2011 [Member] Starter | Points: 25

0	Hi, You can generate reports using an online reporting tool zoho reports(http://reports.zoho.com). In Zoho Reports you can create databases and tables and then you can generate reports using its chart view(there are lot of graphical views,which give clear understanding on your report),pivot,summary table,query table,tabular view. In this, pivot,summary and tabular views may help you. You can Import your data in following ways 1. First create an account in http://reports.zoho.com . 2. You can import using Zoho Reports UI ( or ) using API ( or ) Upload tool 3. You can upload your local file(.txt/.csv/.tsc/.xls/.html/ and etc..) 4. In case if you are having your tables in a database (mysql,oracle,MS Excel.... ) you can connect your database with zoho reports upload tool . And you can import easily Its a cool tool to analyse your data by creating different reports. You can be helped by subscribing with basic plans,which itself provides large amount of data. If it meets your requirement, you can use this tool. For any clarification get back to me.. Thanks prameena (prameena@zoho.com) Asad1605, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,
You can generate reports using an online reporting tool zoho reports(http://reports.zoho.com). In Zoho Reports you can create databases and tables and then you can generate reports using its chart view(there are lot of graphical views,which give clear understanding on your report),pivot,summary table,query table,tabular view. In this, pivot,summary and tabular views may help you.
You can Import your data in following ways
1. First create an account in http://reports.zoho.com .
2. You can import using Zoho Reports UI ( or ) using API ( or ) Upload tool
3. You can upload your local file(.txt/.csv/.tsc/.xls/.html/ and etc..)
4. In case if you are having your tables in a database (mysql,oracle,MS Excel.... ) you can connect your database with zoho reports upload tool . And you can import easily
Its a cool tool to analyse your data by creating different reports.

You can be helped by subscribing with basic plans,which itself provides large amount of data.

If it meets your requirement, you can use this tool. For any clarification get back to me..

Thanks
prameena
(prameena@zoho.com)

Asad1605, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts