Click here to Skip to main content
11,806,590 members (69,477 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 ppolymorphe 205
1 OriginalGriff 175
2 Richard Deeming 175
3 Sergey Alexandrovich Kryukov 170
4 Abhinav S 120
0 OriginalGriff 3,380
1 Maciej Los 1,990
2 CPallini 1,915
3 KrunalRohit 1,907
4 ppolymorphe 1,317

Advertise | Privacy | Mobile
Web03 | 2.8.151002.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