Click here to Skip to main content
Rate this: bad
good
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,
 CONSTRAINT [PK_LabourRegistration_1] PRIMARY KEY CLUSTERED
(
    [JobId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
Posted 28-Jun-12 22:52pm
Edited 28-Jun-12 23:23pm
v3
Comments
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

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  

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

  Print Answers RSS
0 OriginalGriff 230
1 PIEBALDconsult 150
2 DamithSL 125
3 Andreas Gieriet 90
4 Jochen Arndt 90
0 OriginalGriff 5,790
1 DamithSL 4,601
2 Maciej Los 4,012
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,195


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