Hi
I have a requirement of passing _FOC_NULL to the
drill down report from my main report. I have 2 parameters p1 and p2. doing the main report by p1 and where var2=p2.

This works fine. This is a bargraph. when I clicked on the bar for a p1 , p1 and its related p2 values should be passes as a parameter to the drill down report. here my p2 is ALL/_FOC_NULL most of the time. CAn any one help how to pass this value to my drill down report.

Thanks,

What is the value of p2 you get on the drilled report?

Hi

Thanks for the response. My P2 is passing as NULL('') value. So I am not getting any data in my report.

Hi,

You can compute a new field in the GRAPH request as a NOPRINT and set that value to _FOC_NULL when P2 is null. And pass this new field as a parameter to the drill down.


thanks
Sashanka

Hi,

I tried compute variable like the following
compute p_wh/a60v= if '&p2' ne '_foc_null' then '&p2' else ;
In the else part i want to write the following sql code or
equivalent code in wf.

select p_wh from tab1 where p1='&p1'

because my p1 and p2 are related with each other. p1 is warehouse,
p2 is physical warehouse. for one p1 there may be more than one p2.

I am able to pass p1 correctly, because that is in the graph.
but my p2 is in the dashboard selection.

for ex

p1 p2
all all (represents _FOC_NULL)
1 1a,1b,1c
2 2a
3 3f,3g

main report is a graph report.

it shows bar chart for all (1 2 3).

from this main if choose 3 it should show me only details for 3f and 3g. But in my dashboard p2 is all. So
show it is showing again all values as in the main report, not considering p1.

Is there a way to implement this concept in web focus. Please help to solve this issue.

Thanks,

Hi,

In that case all you need a WHERE on P1 in the drill down report's TABLE request...you need not worry about the P2 value being FOC_NONE/ALL..since the filter on P1 will give you only the required values.

thanks
Sashanka

Hi Shashank,

thanks for the reply. I do have a where condition with p1 in my drill down report. But it is bringing all the values or failing without any values. Not returning any
correct values. As I explained in my prev post if I choose 3 3f and 3g should be there. but it is displaying all the 6(1a,1b,1c,2a,3f,3g).

I don't know to attach files here otherwise I can attach my coding to explain better.
here is part of my coding
TABLE FILE V_PUR_INV_POS_Q1_DR1
PRINT
V_PUR_INV_POS_Q1_DR1.V_PUR_INV_POS_Q1_DR1.ITEM_NUMBER
V_PUR_INV_POS_Q1_DR1.V_PUR_INV_POS_Q1_DR1.ITEM_DESC
V_PUR_INV_POS_Q1_DR1.V_PUR_INV_POS_Q1_DR1.ITEM_STATUS
V_PUR_INV_POS_Q1_DR1.V_PUR_INV_POS_Q1_DR1.ONHAND_QTY
V_PUR_INV_POS_Q1_DR1.V_PUR_INV_POS_Q1_DR1.ONHAND_VAL
WHERE ORG_CODE EQ '&ORG_CODE';
WHERE WAREHOUSE EQ '&WAREHOUSE';
WHERE ITEM_CLASS EQ '&ITEM_CLASS';
WHERE ITEM_CATEGORY EQ '&ITEM_CATEGORY';
WHERE VENDOR_NAME EQ '&VENDOR_NAME';

Thanks,

Sorry forgot to mention . My p1 is '&org_code' and p2 is '&warehouse'