创建水晶报表 [英] Creating Crystal Report

问题描述

海，

我想创建一个出勤报告.为此，我需要找到该员工在场，缺勤和上班半天的信息.我有一个表，其中包含员工姓名，出勤日期，出勤情况.如果员工同样在半天``H''在场，则必须填写``P''，如果缺席则在``A''在场.我需要这样的报告

EmployeeName目前缺席半天
AAA 26 2 0
BBB 24 3 2


请给出一个想法，用C#创建这样的报告.

谢谢与问候
Ananya

Hai,

I would like to create a attendance report.For that I need to find how many days the employee present,absent and half days he taken.I have table with fields employee name,attendancedate,Attendnce. The attendance field must filled ''P'' if the employee is present likewise ''H'' for halfday,''A'' for absent.I need a report like this

EmployeeName Present HalfDay Absent
AAA 26 2 0
BBB 24 3 2


Please give an idea to create such a report in C#.

Thanks and Regards
Ananya

推荐答案

要首先生成水晶报表，您必须在添加后添加一个数据集，然后再调用存储方法才能通过，然后转到解决方案资源管理器，选择crystal Report选项.参数首先，当您看到设计时，您将获得一些虚拟值，但是当您将生成PDF格式或excel格式的晶状报告时，您将获得与保存在后端中的参数相同的参数.


根据MNC公司标准，标题中使用的字体应为34，使用Arial不要与Verdana搭配使用，或者Arial可以最好地显示印地语标题，使用CDAC字体时，Arial只能提供最佳的显示效果.它应该是12，columns字段应该是12，使用小写字母，如果它是Columns字段的标题日期，则将每个字段加粗..

To make crystal report first u have to go to the solution explorer select crystal Report option after adding add one dataset where u have to call ur stored procedure to pass paramters firstly when u will see the design u will get some dummy values but when u will generate crytal report in PDF format or excel format u will get ur paramters same as u saved in Backend.


According to MNC Company Standard''s the font used in heading should be 34 use Arial don''t go with Verdana or any other font Arial gives best display for hindi title use CDAC fonts only the subtitle should be 20 if ur passing date the it should be 12 the columns field should be 12 use small letters and Bold every field if it is heading subtitle date of Columns field ..

在Google上搜索您会发现许多类似的创建方法水晶报表...我对水晶报表没有太多想法，但是在网上找不到教程不是很难.如果您使用Microsoft Report Viewer，则制作报表非常简单.

search on google u will find many similar ways to create a crystal report... i have not much idea on crystal report but its not so hard to find the tutorials on net.. if u use microsoft report viewer then it is very simple to make a report..

首先，您必须创建存储过程.然后使用命令源类型为Crystal Report的报告源创建报告.

First you have to create Stored Procedure. then create report with report source set with command type as Crystal Report.

这篇关于创建水晶报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！