根据标准创建水晶报告 [英] Create crystal report based on criteria

问题描述

我有一份报告，我需要从Crystal Reports版本11.5生成。我需要在2015年1月1日至2016年1月1日期间显示销售价格低于50美元的所有记录



我是Crystal Reports的新手，但我知道它足以知道在哪里添加公式。我只是不确定我需要为此起诉的公式。任何帮助将不胜感激。



谢谢！



我尝试过：



我还没有尝试过任何东西，过去我做过一些查询，但我不是那么经验。

解决方案

50



我是Crystal Reports的新手，但知道它足以知道在哪里添加公式。我只是不确定我需要为此起诉的公式。任何帮助将不胜感激。



谢谢！



我尝试过：



我还没有尝试过任何东西，我过去曾做过一些疑问，但我不是那么经验。

1。为此，您需要将字段放在报告的详细信息部分中，其中必填字段值将显示在报告中。



2.现在单击详细信息部分，右键单击并转到属性。



3.在属性窗口中单击抑制复选框按钮，然后单击禁止旁边的公式按钮复选框并在其中提供公式公式窗口如

 if（（date> ='01-01-2001'和date< ='31-01- 2000'）和金额<50）然后
返回false 
 else 
返回true 

I have a report that I need to generate from Crystal Reports version 11.5. I need to show the records between January 1st 2015 through January 1st 2016 for all records that the sale price is under $50

I am very new to Crystal Reports, but know it good enough to know where to add the formula. I'm just not sure about the formula that I need to sue for this. Any help would be greatly appreciated.

Thank you!

What I have tried:

I have not tried anything yet, I've done some queries in the past, but I'm not that experienced.

解决方案

50

I am very new to Crystal Reports, but know it good enough to know where to add the formula. I'm just not sure about the formula that I need to sue for this. Any help would be greatly appreciated.

Thank you!

What I have tried:

I have not tried anything yet, I've done some queries in the past, but I'm not that experienced.

1. For this You need to place the fields in the details section of the reports where required field value will be shown in the report.

2. Now Click on Detail section and right click and go to properties.

3. In the property window click on Suppress Checkbox Button and then click on the Formula button beside suppress check box and provide the formula within the formula window like

if ((date >='01-01-2001' and date <='31-01-2000') and amount<50) then 
  return false
else
  return true

这篇关于根据标准创建水晶报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！