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).

Question

5.00/5 (1 vote)

See more:

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.

SQL

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]

SQL

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 21:52pm

PATEL RAJEEV

Updated 28-Jun-12 22:23pm

v3

Add a Solution

Comments

dimpledevani 29-Jun-12 3:59am

what do you want exactly ????

PATEL RAJEEV 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 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 29-Jun-12 4:19am

And the issue is?

Vani Kulkarni 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

Add a Solution

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

Tejas Vaishnav · Answer 1 · 2012-06-28T22:50:00

please refer this links to generate rdlc report.

you cant mention which report you are using. please mention it in your tags while asking question.

http://www.c-sharpcorner.com/UploadFile/a72401/rdlc-report-generation-using-dataset/[^]

http://www.ramto.com/blog/post/Using-RDLC-files-and-Microsoft-Report-Viewer-in-ASPNET.aspx[^]

http://beyondrelational.com/modules/24/syndicated/519/posts/12873/sql-server-develop-reports-with-rdlc-aspnet.aspx[^]

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).

1 solution

Solution 1

Add your solution here

Preview 0

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).

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us