Pay slip Generation throw Gristle report

Question

0.00/5 (No votes)

See more:

Dear all this is my data table. i need to Get Each and every Employee BasicSalary,Code,Travel,Phone,ESI.PF,... if anybody know ple Help Me...

year	month	EmployeeID	Component	Amount	Remarks
2013	3	2	Basicsal	15000	dsf
2013	3	2	CODE	        2	dsf
2013	3	2	Travel	        0	dsf
2013	3	2	Phone	        1500	dsf
2013	3	2	Internet	500	dsf
2013	3	2	Bus Allo	0	dsf
2013	3	2	BF	        0	dsf
2013	3	2	ESI	        0	dsf
2013	3	2	Medic          -500	dsf
etc..   ..      ..      ....           ....     ...

and i need out put like this

Emp ID	XXX			
				Basic	        XXX	
Allowance		        Allow	        XXX	
A	B	C		Deduction	XXX	
Deductions						
A	B	C				
				Take Home	XXX

Posted 11-Mar-13 22:41pm

DhananjayanP

Updated 12-Mar-13 0:01am

Aarti Meswania

v2

Add a Solution

Comments

Aarti Meswania 12-Mar-13 6:05am

what is A B C ???

DhananjayanP 12-Mar-13 6:46am

it's allowance
Travel
Phone
like that

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)

Mycroft Holmes · Answer 1 · 2013-03-11T23:19:00

Solution 1

You are asking your database to do the work of the presentation layer, wrong tool for the job. Split this into 2 operations, first get the data (use a SQL select query) then format the data in the presentation layer, probably a report tool of some sort.

Posted 11-Mar-13 23:19pm

Mycroft Holmes

Comments

Aarti Meswania 12-Mar-13 6:06am

right 5+! :)