Create Recruitment Summary Report

Question

3.00/5 (2 votes)

See more:

Hi,

I need to prepare a report as shown in below

VIEW REPORT FORMAT

I'm Using sql server 2008 R2 and Crystal Report but i'm a newbie in both

please help me !!!

Posted 17-Jul-12 1:45am

Jackson K T

Add a Solution

Comments

Kenneth Haugland 17-Jul-12 7:49am

To little information, all we can provide you with is links, and you could find the yourself by searching google

dimpledevani 17-Jul-12 7:50am

In crystal reports there is an option of making groups, so make a group of department and followed by groups of columns you want.

1 solution

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)

MAU787 · Answer 1 · 2012-07-17T01:56:00

Solution 1

hi i m assuming it is in windows u can do the same way in web also
First create one stored procedure for getting this data
you can write group by query with department and then section and then take count of employees according to their hierarchy.
follow this given step:

SQL

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm

and instead of table try to add your stored procedure for crystal report source

or try this with dataset
Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]

Posted 17-Jul-12 1:56am

MAU787

Comments

Jackson K T 17-Jul-12 8:20am

I Think I need to explain my question more clearly

This report is Showing minimum number of staffs for each designation in a Department

i used PIVOT query to get the result .It's works fine but my problem is some sections are managed by single manager .So it should be displayed as shown in my example

in my example Jeans,Suitings and kids sections are managed by a single manager so i need to merge that cells like in the image

MAU787 17-Jul-12 8:57am

u said
i'm a newbie in both
that's why i was explaining the crystal reports with stored procedure
when u'll put design on crystal report there are many options for displaying data(like calculation,formulas etc) and try to explore group section also
just explore those and try to get it.maybe u'll find the option.