Condition Check in Crystal Report

Hi Ramco Ramco,

Yes, it is indeed possible to check for a condition in a Crystal Report that is based on a stored procedure. You can achieve this by using the "Suppress" feature or by creating a formula field that evaluates your condition.

For instance, if you want to display data only when a certain field meets a specific criterion, you can create a formula field like this:

If {YourField} = "YourCondition" Then
    True
Else
    False

Then, you can use this formula in the "Suppress" option of the report section. Simply right-click on the section (e.g., Details), select "Section Expert," and enter your formula in the "Suppress" formula box. This way, the section will only display data when the condition is true, effectively controlling the visibility of your report data based on the stored procedure's output.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaimin Shethiya1y ago
Hello,

Yes that is possible, you need to create formula and used that formula in your crystal report.

Please refer below link for more detail.

https://kb.blackbaud.com/knowledgebase/Article/52447

Thanks
0
Jayraj Chhaya1y ago
Hi Ramco Ramco,

Yes, it is indeed possible to check for a condition in a Crystal Report that is based on a stored procedure. You can achieve this by using the "Suppress" feature or by creating a formula field that evaluates your condition.

For instance, if you want to display data only when a certain field meets a specific criterion, you can create a formula field like this:
```
If {YourField} = "YourCondition" Then
    True
Else
    False
```
Then, you can use this formula in the "Suppress" option of the report section. Simply right-click on the section (e.g., Details), select "Section Expert," and enter your formula in the "Suppress" formula box. This way, the section will only display data when the condition is true, effectively controlling the visibility of your report data based on the stored procedure's output.
0