开发者

calculate based on constant field

开发者 https://www.devze.com 2023-03-10 01:55 出处:网络
I\'m fetching a data from the database and with which i need to multiply a entered value and to get an output.

I'm fetching a data from the database and with which i need to multiply a entered value and to get an output. Example, Volume = 200 (fetched from database) Nos = 10 (requires to Enter manually bef开发者_运维技巧ore generating the report) Value = 2000 (Volume * Nos)

How to achieve this in Crystal Reports?


Which database you are using? Database has default arithmetic support.

You could do

select volume, nos, volume * nos as 'result' from mytable

would pick the value and you can just so it on the crystal report.


Create a numeric, parameter field named 'Nos'.

Create a formula field, named 'product', enter the following code in its text:

{table.volume} * {@Nos}

Add formula field to canvas.

0

精彩评论

暂无评论...
验证码 换一张
取 消