在Crystal Reports中进行计算? [英] Calculation in Crystal Reports?

问题描述

你好，
下午好
我已经创建了用于产品结算的水晶报表，现在我要计算产品数量*产品费率可以说产品数量为5，产品费率为20，那么我想计算该值的乘积，即5 * 20 = 100
如何在水晶报表中实现这一目标?请帮助我

(Windows应用程序)
感谢您的提前帮助.

Hello there,
Good Afternoon
I have created crystal reports for billing of products,Now I want to calculate product quantity * Rate of product lets say Product quantity is 5 and product rate is 20 then I want to calculate multiplication of this i.e 5*20 =100
How can I Achieve this in crystal reports? please help me

(Windows Application)
Thanks for the help in advance.

推荐答案

您可以使用公式字段.使用公式编辑器创建公式字段.在公式编辑器中，数据库字段，函数和运算符可用.您可以使用Crystal语法或VB语法.对于您的情况，假设数量和费率来自产品"数据表，则可以创建一个公式字段 ProductAmount ，如下所示
(产品数量)*(产品*费率)
然后将此公式字段添加到水晶报表中.
它会适当地获取每个记录的数量和费率，并计算该记录的数量.

如果您的问题得到解决，则可以接受该解决方案并对其进行表决，否则，请发布您的查询

PES

You can use formula field. Use formula editor to create the formula field. In the formula editor the database fields, functions and operators are available. You can use Crystal syntax or VB syntax. For your case, assuming that the quantity and rate are from Products datatable, you can create a formula field ProductAmount as follows
(Products.Quantity)*(Products*Rate)
Then add this formula field to the crystal report.
It appropriately takes the quantity and rate for each record and calculates the amount for that record.

If your problem is solved, you may accept and vote the solution otherwise please post your queries

PES

您可以阅读以下CodeProject文章
在.Net中使用Crystal Reports [

You may review the following CodeProject article
Working with Crystal Reports in .Net[^]

If your problem is solved, you may accept and vote the solution otherwise please post your queries

PES

这篇关于在Crystal Reports中进行计算?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！