报告查看器使用2个表 [英] Report Viewer Using 2 tables

问题描述

大家好，



下午好！



有人可以帮帮我吗？我使用报表查看器创建了一个报表，我有两个表，我可以从两个表中获取数据，问题如下所示。



在一个表中购买已保存。 &在其他所有的销售中保存。



现在我想在报告中显示的是这样的。


报告中的
我想要购买表中的所有列以及仅购买帐单号为xyz的销售总额。根据我的购买发票，它会让我查看余额库存。



说发票号码如下： - PPY001我已经购买了6部手机，我从同一个购买发票中卖出3部手机，分为2部分（1-2）。所以报告应该给我看。



购买： - 数量6售出3余额3



i将如果有人可以帮我解决这个问题。

Hello Every One,

Good Afternoon !!

Can someone please Help Me ? I have created a report using Report Viewer, i have 2 tables i am able to get the data from both the tables, problem is something like below.

In one table purchase are saved. & in other all my sales saved.

now what i want to show in the report is something like this.

in a report i want all column from Purchase table & only sum of sales where purchase bill no is xyz. which will give me the over view of balance stock as per my purchase invoice.

say like under invoice no :- PPY001 I have purchased 6 phones & I sold 3 phones from same purchase invoice no in 2 parts(1-2). so the report should show me like.

Purchase :- qty 6 sold 3 balance 3

i will be glade if someone can help me on this.

推荐答案

你好Vinit，



你为什么不做通过在数据库中编写一个查询并从他们的表中返回表。通过这种方式，您可以轻松地将表格绑定到报表并显示数据，操作和维护也很容易。

Hi Vinit,

Why dont you do that by writing a query in your database and returning you table from their. This way you can easily bind your table to report and show the data and manipulation and maintenance will also be easy.

这篇关于报告查看器使用2个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！