Creating Crystal Report

Question

3.00/5 (2 votes)

See more:

Hai,

I would like to create a attendance report.For that I need to find how many days the employee present,absent and half days he taken.I have table with fields employee name,attendancedate,Attendnce. The attendance field must filled 'P' if the employee is present likewise 'H' for halfday,'A' for absent.I need a report like this

EmployeeName Present HalfDay Absent
AAA 26 2 0
BBB 24 3 2

Please give an idea to create such a report in C#.

Thanks and Regards
Ananya

Posted 8-Nov-11 6:37am

Ananya Ffrom Kerala

Add a Solution

Comments

[no name] 8-Nov-11 12:48pm

What have yuo tried so far?

Menon Santosh 8-Nov-11 13:18pm

Do U want Query for this purpose ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prashant Srivastava LKO · Answer 1 · 2011-11-09T18:38:00

To make crystal report first u have to go to the solution explorer select crystal Report option after adding add one dataset where u have to call ur stored procedure to pass paramters firstly when u will see the design u will get some dummy values but when u will generate crytal report in PDF format or excel format u will get ur paramters same as u saved in Backend.

According to MNC Company Standard's the font used in heading should be 34 use Arial don't go with Verdana or any other font Arial gives best display for hindi title use CDAC fonts only the subtitle should be 20 if ur passing date the it should be 12 the columns field should be 12 use small letters and Bold every field if it is heading subtitle date of Columns field ..

amsainju · Answer 2 · 2011-11-08T07:02:00

Solution 1

search on google u will find many similar ways to create a crystal report... i have not much idea on crystal report but its not so hard to find the tutorials on net.. if u use microsoft report viewer then it is very simple to make a report..

Posted 8-Nov-11 7:02am

amsainju

Jyoti Choudhury · Answer 3 · 2011-11-08T14:19:00

Solution 2

First you have to create Stored Procedure. then create report with report source set with command type as Crystal Report.

Posted 8-Nov-11 14:19pm

Jyoti Choudhury