RDLC中的生成报告 [英] Genrating Report in RDLC

问题描述

我对这个概念很新，任何人都可以建议我如何在RDLC中绑定报告。



我有一个包含一个下拉列表的表单客户列表。

从下拉列表中选择客户后，当我点击生成报告按钮，然后客户数据需要绑定到报告。



我创建的程序在第一个表中返回客户详细信息，在第二个表中它给了我所有客户订单。



现在当我添加RDLC时到我的解决方案，并将表添加到RDLC。

在选择表时它会询问我存储过程名称。

我选择了程序名称，但之后它只显示了存储过程的第一个表，即关于客户的基本信息，而不是第二个表详细列，即该客户的所有订单。



任何人都可以告诉我如何实现这个目标吗？



Tha nks提前

I am very new for this concept, Can any one advice me how to bind a report in RDLC.

I have one form which contains of one drop down list of customers.
after selecting customer from drop down when i click genrate report button then that customers data need to get bind to the report.

I have created procedure which returns me customer details in the first table and in the second table it gives me all the customers order.

Now when i am adding RDLC to my solution, and adding the table to the RDLC.
at the time of selecting table it asks for me stored procedure name.
I have selected the name of procedure, but after that it only shows me the first table of the Stored procedure i.e the basic information about the Customer but not the second tables details columns i.e. all the orders of that customer.

Can any one tell me how to achieve this??

Thanks in advance

推荐答案

你可以这样做，至少不能用当前的配置。 Reporting Services仅适用于存储过程的第一个结果集。



您可以选择将proc中的查询分解为不同的表在数据集/多个数据集中或将proc分解为多个过程。

you can;t do it, at least not with the current configuration. Reporting Services will only work with the first result set from a stored procedure.

You're left with the option of either breaking the queries out of the proc into different tables in the dataset/multiple datasets or breaking the proc into multiple procs.

这篇关于RDLC中的生成报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！