RDLC表达式

Question

我正在使用visual basic创建一个发票报表.rdlc，我想做的是像这样的分组计算，请指导我

示例：

​

​

尝试添加用于增值税计算的数据源，但对于金额列，我在rdlc中没有得到任何结果，而对于VAT，我在rdlc中获得了值

Dim connstring0 As String = String.Format("Server=127.0.0.1;Port=5432;Username=postgres;Password=Maestro;Database=IMS_DB;")
                Dim conn0 As NpgsqlConnection = New NpgsqlConnection(connstring0)
                conn0.Open()
                Dim Command0 As NpgsqlCommand = New NpgsqlCommand("SELECT DISTINCT total_vat_onsales,SUM(amount) From invoice_withvat_table Where invoice_number = 'I20160711165711' GROUP BY total_vat_onsales", conn0) '(Select MAX(CAST(id AS bigint)) from  invoice_withvat_table)
                'MessageBox.Show("SELECT DISTINCT total_vat_onsales,SUM(CAST(amount As numeric(18,2))) From invoice_withvat_table Where invoice_number = '" + vb_inviceno + "' GROUP BY total_vat_onsales")
                Dim reader0 As NpgsqlDataReader = Command0.ExecuteReader()
                Dim data_Table10 As New DataTable
                data_Table10.Load(reader0)
                reader0.Close()
                conn0.Close()
                ReportViewer1.LocalReport.DataSources.Clear()
                ReportViewer1.LocalReport.DisplayName = "Invoice With VAT"
                ReportViewer1.LocalReport.ReportPath = "Invoice_WithVAT.rdlc"
                Dim rds As ReportDataSource
                rds = New ReportDataSource("DataSet1", data_Table1)
                Dim rds0 As ReportDataSource
                rds0 = New ReportDataSource("DataSet2", data_Table10)
                ReportViewer1.LocalReport.DataSources.Add(rds)
                ReportViewer1.LocalReport.DataSources.Add(rds0)
                Me.ReportViewer1.RefreshReport()

After Modification

它进入了rdlc，但是下一步该怎么做才能进一步实现呢？

Answer 1

你必须和ReportItems一起玩。

​

​

根据你的形象，你应该做一些类似下面的事情。

1 - =SUM(Fields!Amount.Value)

2 - =(SUM(Fields!Amount.Value)/10)

3 - =SUM(Fields!Amount.Value)

这里，Sum.Value和Div.Value是来自1个输出和2个输出的值。你可以用同样的方法做进一步的计算。