Click here to Skip to main content
Rate this: bad
good
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 3:11am
Comments
ryanb31 at 19-Feb-13 8:51am
   
What do you have so far? What specifically are you stuck on?

1 solution

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

Solution 1

Steps:
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.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 245
1 Jochen Arndt 155
2 PIEBALDconsult 150
3 Afzaal Ahmad Zeeshan 120
4 DamithSL 115
0 OriginalGriff 5,695
1 DamithSL 4,591
2 Maciej Los 4,012
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,190


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 19 Feb 2013
Copyright © CodeProject, 1999-2014
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