Click here to Skip to main content
11,577,143 members (62,447 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: ASP.NET
I would like to generate attendance sheet. The Number of columns in the grid/table will be around 35 columns along with employee empid, Name, Total Attendance (it is just like attendance register).

S.No Name JobId S/O  1  2  3  4..........30 31 Tworkingday NoofAttendance 
1     AB   A1	   B   P  A  P  P..........P  P	    31		30
2     BC   A2	   C   P  A  P  P..........P  A	    31		29
3     CD   A3	   D   P  A  P  P..........P  P	    31		30
4     EF   A3	   E   P  P  P  P..........P  P	    31		31

[edit]Code block added - OriginalGriff[/edit]

i have two table.

CREATE TABLE [dbo].[Attendance](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [JobId] [varchar](50) NULL,
    [Date] [date] NULL,
    [Systemdate] [datetime] NULL,
    [Attendance] [nchar](1) NULL,
    [site] [varchar](50) NULL,
    [update1] [nchar](1) NULL,
    [overtime] [decimal](18, 0) NULL,
    [Attendance1] [nchar](1) NULL,
 CONSTRAINT [PK_Attendance]

CREATE TABLE [dbo].[LabourRegistration](
    [JobId] [varchar](50) NOT NULL,
    [Name] [varchar](50) NULL,
    [FHName] [varchar](50) NULL,
    [Gender] [varchar](50) NULL,
    [Age] [varchar](50) NULL,
    [Category] [varchar](50) NULL,
    [Address] [varchar](50) NULL,
    [UploadPhotograph] [varchar](50) NULL,
    [DateofRegistration] [varchar](50) NULL,
    [ContractorId] [varchar](50) NULL,
    [ContractorName] [varchar](50) NULL,
    [site] [varchar](50) NULL,
    [JobId] ASC
Posted 28-Jun-12 21:52pm
Edited 28-Jun-12 22:23pm
dimpledevani at 29-Jun-12 3:59am
what do you want exactly ????
PATEL RAJEEV at 29-Jun-12 4:34am
I want to generate report(it is just like register) with the help of these two table which is created.
OriginalGriff at 29-Jun-12 4:14am
And what have you tried?
Where are you stuck?
You didn't ask a question...
Use the "Improve question" widget to edit your question and provide better information.
Sandeep Mewara at 29-Jun-12 4:19am
And the issue is?
Vani Kulkarni at 29-Jun-12 5:56am
With what tool you want to generate report? Crystal Reports or SSRS or something else? Where are you facing issue?

1 solution

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

  Print Answers RSS
0 DamithSL 155
1 Sergey Alexandrovich Kryukov 131
2 OriginalGriff 115
3 Afzaal Ahmad Zeeshan 95
4 Abhinav S 90
0 OriginalGriff 820
1 Sergey Alexandrovich Kryukov 631
2 Abhinav S 528
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 365

Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 29 Jun 2012
Copyright © CodeProject, 1999-2015
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