Click here to Skip to main content
13,141,637 members (56,728 online)
Rate this:
Please Sign up or sign in to vote.
I am new to Visual Studio 2010 C#. I'm creating an web application with crystal report. I want to create individual production report and consolidated report from sql table.

I have have a two tables i.e.

Employee Master (EmpID, EmpName)

JobCard Master(JobDate,Clientname,jobscope,jobname,jobdoneby,jobqcby)

I want a result like

Report header

EmpId, EmpName, #JobsDone, #JobsQcDone

#JobsDone - Need to count # of jobs done in column
#JobsQcDone - Need to count # of qcjobs done in column

Please help me to get solution for my situation.

Thanks in advance.
Posted 19-Feb-13 2:11am
ryanb31 19-Feb-13 8:51am
What do you have so far? What specifically are you stuck on?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

1. Write query to get the data as per need
2. Design the crystal report such that you can display the query result in tabular form

Now, about query, you need to join the two table data and get it. Based on what you have shared, it's not clear what connects the two table. You need to find that and use as the JOIN condition.

Try out. Post specific issue if you face any.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.170915.1 | Last Updated 19 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100