创建招聘摘要报告 [英] Create Recruitment Summary Report

问题描述

我需要准备如下所示的报告


查看报告格式


我正在使用sql server 2008 R2和Crystal Report，但我都是这方面的新手

请帮帮我！！！

Hi,

I need to prepare a report as shown in below


VIEW REPORT FORMAT


I''m Using sql server 2008 R2 and Crystal Report but i''m a newbie in both

please help me !!!

推荐答案

hi 我假设它在Windows中，您也可以在Web中做同样的方式
首先创建一个存储过程以获取此数据
您可以按部门查询分组，然后按部门分类，然后根据员工的层次结构对员工进行计数.
请按照给定的步骤进行操作:

hi i m assuming it is in windows u can do the same way in web also
First create one stored procedure for getting this data
you can write group by query with department and then section and then take count of employees according to their hierarchy.
follow this given step:

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm

而不是使用表尝试为Crystal Report Source添加存储过程

或尝试使用数据集
使用其功能组逐步创建Crystal Report，图形，交叉表和子报表 [ ^ ]

and instead of table try to add your stored procedure for crystal report source

or try this with dataset
Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]

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