suppress section detail

[ulag]

I am using CR 10

I need to suppress a section(which has values from A), if the value of B.inactive is not 1 and certain other conditions

The table B has records based on
companyId, ruleId and reportId

I try to use like this
{B.Inactive}
and {B.ruleId}=2
and {B.reportId}=1
and {A.CompanyId}= {B.CompanyId)


I am not getting the desired results. Can any one please help?

 

[synapsevampire]

Pretty vague.

Try:

{B.Inactive} <> 1
and
{B.ruleId}=2
and
{B.reportId}=1
and
{A.CompanyId} = {B.CompanyId)

-k

 

[ulag]

Thanks. But, still not working.

 

[synapsevampire]

Yry describing your requirements more fully, as I said, your post was vague.

Database/connectivity used
Example data
Expected output

The following looks suspect, but how can anyone possibly know based on what you've posted:

"and
{A.CompanyId} = {B.CompanyId)
"

This should probably be handled by the joins, not the record selection criteria.

-k

 

[ulag]

I tried like this:

{B.Inactive} <> 1
and
{B.ruleId}=2
and
{B.reportId}=1
and
{B.CompanyId)=10

still have the problem

 

[Madhi]

Hi ulag,
Try the following
if {B.Inactive} <> 1
and
{B.ruleId}=2
and
{B.reportId}=1
and
{B.CompanyId)=10 then True

Madhivanan

 

[ulag]

Hi Madhi,

Thanks for your reply. The above suggested solution did not solve my problem. Let me rewite the problem. I need to supress text or field value or section based on multiple conditions. It is not just multiple conditions alone. The conditions are selected from list of records. CR reads the first record only.

I need to suppress when A.Inactive is 1 and other 2 conditions satisifes
{A.Inactive} <> True
and
{A.ruleid}=2
and
{A.Companyid}=10

Table A, has multiple records of ruleid for a given companyid
For each ruleID only one inactive is there (either 1 or 0)

I am struck with the formula. Any help is appreciated

 

[Madhi]

Hi
What is the datatype of A.Inactive? Try this.

whileprintingrecords;
{A.Inactive} <> True
and
{A.ruleid}=2
and
{A.Companyid}=10

Madhivanan