报表服务中的动态列 [英] Dynamic column in reporting services

问题描述

我正在使用asp.net 2005和2010中的报表服务来显示我的报表.但现在有一天，我

面临问题.我需要动态生成列.我将在下面举一个例子.

我需要生成所有员工的工资单，在这种情况下，第一列是员工注册编号，第二列是员工姓名，第三列是员工名称和部门，这些列是固定的.其余的是基本津贴，HRA等津贴和PF，ESI等扣除额.我无法确定这些津贴和扣除额，每个月都有所不同.

在报表服务中动态生成这些列的任何解决方案也是如此.

这些列可见.值是通过存储过程计算的.表示存储过程返回一个表.实际上，我需要显示存储过程返回的表.问题是存储过程返回的表的列是动态的.

I am using reporting services in asp.net 2005 and 2010 for show my reports. But now a days i am

facing a problem. I need to generate columns as dynamically. i will give an example below.

i need to generate a salary slip of all the employee, in this case first column is employee registration number, second is employee name, third is employee designation and department, these columns are fixed. the remaining are allowance like basic, hra etc and deductions like PF, ESI etc. i cant able to fix these allowance and deductions, this are varying for each month.

So is it any solution for generate these columns as dynamic in reporting services.

Those columns as visible. values are calculated by stored procedure. that Stored procedure return a table. actually i need to display exactly the table return by stored procedure. the thing is that the column of the table return by the Stored procedure is dynamic.

推荐答案

您可以在gridview中使用auto generate column选项，并在SQL查询以动态显示列.

You may use the auto generate column option in the gridview and apply intelligence in the SQL Query to show the columns dynamically.

这篇关于报表服务中的动态列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！