Rdlc使用存储过程报告 [英] Rdlc Reports using stored procedure

问题描述

海友....



i我是新来的报道这是我的第一份报告请帮助我，如果有人知道



i需要rdlc报告为员工palyslip /工资凭证我创建了一个存储过程，因为我得到了所有的支票

这里我需要的是当我运行每个应用程序时页面它将显示两个表一个是员工月薪详细信息和另一个扣除每个员工ID中的每个员工ID只有一个员工详细信息将在存储过程中显示我将获得此报告生成的所有详细信息如何在此创建rdlc报告我没有传递任何像employeeid这样的参数，而且我没有传递任何东西，但是当我在每个页面中运行tha应用程序时，它会显示一个员工detali 就像我说的那样。



紧急删除 - OriginalGriff [/ edit]

Hai friends....

i am new to reports this is my first report please help me if any one knows

i need a rdlc report for employee palyslip/salary voucher for that i created a stored procedure in that i am getting all vlaues
here what i need is when i run thae application each page it will show two table one is employee monthly salary details and another one deduction detalis for every employee id in each page only one employee details will be diplayed in stored procedure i am getting all the details for this report generation how to create rdlc report here i am not passing any parameters like employeeid and all i am not passing anything but when i run tha application in every page it will show one employee detalis like what i said how to do..

[edit]Urgency deleted - OriginalGriff[/edit]

推荐答案

首先通过右键单击解决方案添加创建数据集新项目 - &g t; Data->数据集然后从您的连接拖放您的存储过程到数据集设计。



然后创建一个rdlc报告（希望你知道）。然后在rdlc报告的工具箱上方会出现一个新按钮，单击该按钮并单击数据集并给出一个名称，然后从下拉列表中选择数据集并单击保存。现在，数据集将被引用到您的rdlc报告中。来rdlc报告拖放你的控件，并假设它是一个文本框右键单击它会有像Expression这样的选项，你可以看到很多选项。当您需要绑定到数据集时，您可以在左侧面板中看到数据集，然后单击它，然后引用数据集中的所有可用字段将显示在右侧面板上，双击它现在表达式将位于最顶部的框中请注意，如果它是一个int字段，那么表达式将类似于SUM（字段......），因此如果您想显示值而不是sum，请将其设置为FIRST。为剩余的田地做同样的事情



来吧。创建新表单并从工具箱中拖放reportviewer。在reportviewer的右上角，您可以看到一个小箭头，在那里您可以选择您的rdlc报告。它将自动创建soome函数，例如

First create a Dataset by right clicking solution add new item->Data->Dataset then from your connection drag and drop your stored procedure into the Dataset design.

Then create a rdlc report(hope you know that). Then there will be New button above the toolbox of rdlc report click on that and click on dataset and give a name and choose the dataset from the dropdown list and click save. Now the dataset is referred to your rdlc report. Come to rdlc report drag and drop your controls and suppose it is a textbox right click on it there will be a option like Expression there you can see plenty of option. As you need to bind to a dataset you can see dataset in left side panel click on it then all field available in the referred dataset will be displayed on right side panel there double click on it now a expression will be in the top most box and note that if it is an int field then the expression will be like SUM(Field......) so if you wanna display the value instead of sum make it as FIRST. Do same for remaining fields

Come to form. Create new form and drag and drop reportviewer from the toolbox. In the top right corner of the reportviewer you can see a small arrow click on it there you can select your rdlc reports. It will automatically create soome function like

some....TableAdapter.fille(this.datasetname....)
...RefreshReport();

页面加载表格

如果你想在页面加载时显示报告，或者按照你的需要进行显示

in page load of form
if you wanna display the report when page loads keep it in page load or make it as you need

这篇关于Rdlc使用存储过程报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！