Attendance Reports

Question

I want to create crosstabe report desing bellow type plz...help me. P for Presunt A for Absunt l Leave Normal 0 false false false EN-US X-NONE GU MicrosoftInternetExplorer4 Date Name 1/5/2013 2/5/2013 3/5/2013 4/5/2013 5/5/2013 rahul A P P L P kiran P A P P P /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;}table.MsoTableGrid{mso-style-name:Table Grid;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-priority:59;mso-style-unhide:no;border:solid black 1.0pt;mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:text1;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh:.5pt solid black;mso-border-insideh-themecolor:text1;mso-border-insidev:.5pt solid black;mso-border-insidev-themecolor:text1;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-language:AR-SA;} Create same report in crystal reports

Sivaraman Dhamodaran · Answer

May be you will get help when you show your table struct.. You question has the answer.. CrossTab... So look for forming a cross tab query? You table struct is required to get help..

Date
Name		1/5/2013	2/5/2013	3/5/2013	4/5/2013	5/5/2013
	rahul	A	P	P	L	P
	kiran	P	A	P	P	P