行数据作为列标题 [英] row data as column header

问题描述

你好



我有一张考勤表数据，栏目如下



日期 - EmployeeID - EmpName - TimeIn - TimeOut - 备注



它的coloumn填充了适当的数据。



现在我想以一些不同的风格报告：



EmployeeNames 作为标题

日期，时间，TimeOut和Remarks列作为数据。



任何人都可以帮助我在c＃或vb.net中获得这种结果或特定风格的水晶报告



谢谢



我已经在这里回复了一个回复时发布了一些示例数据....

进一步的解释如下：

它的出勤报告包含来自生物识别设备的数据。

返回数据为：ID，Name，Date，TimeIn ，TimeOut等等......

但我需要将名称显示为列标题和日期，TimeIn和TimeOut作为数据行下的头。例如：

它可能包含40-50名员工，我们有一个注册表，其中empName为上方标题，日期为左侧行标题。和输入时间作为数据。

Hello

I have a table for attendance Data with columns as follows

Date - EmployeeID - EmpName - TimeIn - TimeOut - Remarks

it has the coloumn filled with appropriate data.

now i would like to have the reports in some differant style as:

EmployeeNames As header
Date,timeIn,TimeOut and Remarks column as data.

can anyone help me out to get this kind of result in c# or vb.net OR crystal reports of particular style

Thanks

I had already posted a little sample data in answer to one reply here....
further explanation is as under:
its an attendance report having data from biometric device.
which returns data as: ID, Name, Date, TimeIn, TimeOut, and more...
but i need to show the name as column header and date, TimeIn and TimeOut as data rows under the headers. for example:
it may contain 40-50 employees, and we are having a register with empName as header at upper side and date as row header at left side. And In-Out time as data.

its simple list showing in a report format,
Am I not able to express my concern/requirements properly...

I need to show the data in the Name/Last name column as headers
database table data is as under:
8Apr13  1   Manpreet Kaur   07:20:26    13:39:52
9Apr13  1   Manpreet Kaur   07:18:48    13:37:55
10Apr13 1   Manpreet Kaur   07:24:30    13:38:20
8Apr13  2   Harpreet Singh  07:26:33    13:40:22
9Apr13  2   Harpreet Singh  07:32:37    13:38:35
10Apr13 2   Harpreet Singh  07:14:52    12:17:01

and so on for multiple employees...

I would like to report it as
Headers:
___________|______________________|_____________________|
___________| Manpreet Kaur        |Harpreet Singh       |
___________|______________________|_____________________|
   8Apr    |07:20:26  |  13:39:52 |07:26:33  | 13:40:22 |
--------------------------------------------------------|
   9Apr    |07:18:48  |  13:37:55 |07:32:37  | 13:38:35 |
--------------------------------------------------------|
   10Apr   |07:24:30  |  13:38:20 |07:14:52  | 12:17:01 |
--------------------------------------------------------|
hope I am clear now...
Pl. suggest me if you have any solution to it

Thanks for your time

[/ Edit]

[/Edit]

推荐答案

看看这里：运行时Crystal报表中的动态列 [ ^ ]。在那里你会找到2个链接。 ;）

Have a look here: dynamic columns in Crystal report at runtime [^]. There you'll find 2 links. ;)

试试这个，如果你需要你的水晶报告结果：





< a href =http://myaspdotnettrainings.blogspot.in/2012/07/rdlc-report-definition-language-client.html> http://myaspdotnettrainings.blogspot.in/2012/07/rdlc-report-definition -language-client.html [ ^ ]

try out this if u need ur result in crystal report:


http://myaspdotnettrainings.blogspot.in/2012/07/rdlc-report-definition-language-client.html[^]

看看，它会解决您的问题。



C＃crystal报告字符串参数。 [ ^ ]



Crystal Report中的自定义字段 [< a href =htt p：//www.codeproject.com/Articles/28413/Custom-Field-in-Crystal-Reporttarget =_ blanktitle =New Window> ^ ]

Have a look, it will solve your problem.

C# crystal reports string parameter.[^]

Custom Field in Crystal Report[^]

这篇关于行数据作为列标题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！