Information

Version: CR XI R2
DB: Oracle 10gR2

Background

I have multiple detail lines (a-e), which I conditionally suppress based on the formula's below (each formula is in the Suppress (No Drill-Down) section, in the section expert):

Details a

IF ({XXGL_DISTRIBUTION_DETAIL_V.JE_SOURCE_NAME} <> 'Payables')
THEN  
    TRUE

Details b

IF ({XXGL_DISTRIBUTION_DETAIL_V.JE_SOURCE_NAME} <> 'Inventory')
THEN  
    TRUE

Details c (contains everything else AND removes "duplicates" from section a and b)

IF  (({XXGL_DISTRIBUTION_DETAIL_V.JE_SOURCE_NAME}    =   'Payables')  
    OR
    ({XXGL_DISTRIBUTION_DETAIL_V.JE_SOURCE_NAME}    =   'Inventory')
THEN  
    TRUE


PROBLEM

I was recently informed that section b can be one of two things, (Inventory, WIP) or (Inventory, MTL), thus, I proceeded to create the following suppression formula, and created an extra section:

(Inventory, WIP) details b

IF( {XXGL_DISTRIBUTION_DETAIL_V.JE_SOURCE_NAME} <> 'Inventory'
    AND
    {XXGL_DISTRIBUTION_DETAIL_V.JE_CATEGORY_NAME} <> 'WIP')
THEN
    TRUE

(Inventory, MTL)  details e (new)

IF( {XXGL_DISTRIBUTION_DETAIL_V.JE_SOURCE_NAME} <> 'Inventory'
    AND
    {XXGL_DISTRIBUTION_DETAIL_V.JE_CATEGORY_NAME} <> 'MTL')
THEN
    TRUE



My problem is that details b is still showing in cases where the record being displayed is clearly a details e record.

I'm being led to believe that you can't conditionally suppress based on two columns. Is this correct? Or does someone know of a way I can get around this issue?

Hey DBlank,

I understand, and I'm ok with that. However, I cant seem to suppress the records which meet (Inventory, WIP) or (Inventory, MTL) conditions, in their respective detail sections.

I know one work around is grouping the records by JE_SOURCE (ie. Inventory), which would then reduce my problem to suppressing by either MTL or WIP; however, it seems that the last two formula's I posted should work, right? Nevertheless, they are not working...


Edited by c16271 - 03 Mar 2011 at 7:16am

No. I NVL() null values in the view. Plus, those fields could never be NULL, considering they are required fields to post into the GL. 

I'll go ahead and try what you suggested. However, there's something I purposely left out:

The reason for all the different detail sections is because I have links to corresponding sub-reports, based on the JE_SOURCE.

Thus, a record with an Inventory source, will see on its' line a link to an Inventory sub-report; in other words, I need those sections separate, so that I can show the corresponding sub-report.

I'll report back in a few.. I'm gonna try your suggestions.