开发者

calculate based on constant field

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜