生成动态rdlc报告 [英] generate dynamic rdlc report
问题描述
iam在asp.net网站上使用vs 2010和sql 2008
我有一些员工报告
但是我注意到,有些日子以后,有些机构要求提供不同的网络报告
例如->代号-出生日期-加入日期
另一个人要求->代号名称-工作部门.......
有时他们会要求不同顺序的列
所以我的想法是制作包含用户可能需要的所有列的页面
然后用户在报告中选择所需目录的列和目录顺序
因此,如果您对此有任何想法,请帮助我
iam working on asp.net website vs 2010 & sql 2008
i have some reports for employees
but i hvae notice that evry afew days some body ask for differnet report
for example --> code-name -birth date -join date
another one ask for -->code- name -job-department .......
& some times they ask for different orders of columns
so my idea was to make page that contain all the column that users may need
then user choose the columns he need to dir in the report & the dir order
so if u have any idea on that please help me
推荐答案
您将需要执行以下操作:
1.向用户提供列列表,让他们选择要查看的列和顺序;
2.使用选定的列构建一个SQL语句;
3.创建一个数据集,其中包含一个包含所需数据的数据表;
4.使用2中的SQL命令填充数据表;
5.将数据集/数据表传递给报表;
6.显示报告
You''re going to need to do the following:
1. provide a list of columns to the user to let them choose which ones they want to see and in which order;
2. Build an SQL statement using the columns selected;
3. Create a dataset containing one datatable to contain the required data;
4. Fill the datatable using the SQL command from 2;
5. Pass the dataset/datatable to the report;
6. Show the report
这篇关于生成动态rdlc报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!