Hi,
I am facing a very strange error.

In my report I have 4 prompts (first 2 are cascading, the last 2 are cascading)
For the first cascading prompt I populate it from table A, for the second cascading prompts I populate it from table B.

Based on these prompt selection I have to generate graphs (to build these graph I use data from Table A only).

I have also implemented a Drill down from this graph (to build this standard tabular report I use data from both Table A and Table B)

Now my problem is when I select ALL option in all the 4 prompts or in the Last 2 prompt alone and click on the run button
Case1. Prompt1: ALL Case 2. Prompt1: Value
Prompt2: ALL Prompt2: Value
Prompt3: ALL Prompt3: ALL
Prompt4: ALL Prompt4: ALL


The graph displayed is incorrect (i.e. it does not join the Table A and Table B), for e.g. at the footer it displays the total count as “300”

But when I drill down from the graph to the standard report, the output is displayed correctly, for e.g. in the footer the total count is 100.

To verify this I queried my database in oracle, and when I queried Table A I get 300 rows, when I queried Table B I get 100 rows, when I joined Table A and Table B I get 100rows.

The Graph as well as the drill down report works fine if I don’t select all in the Last cascading prompt. (i.e. Prompt3: Value, Prompt4: All or Prompt3: All, Prompt4: value)

Can any one tell me as to why I am facing such a strange situation and also provide me a solution?

Thanks

Regards

Sengot

My guess is that when you select ALL, the FOC_NONE value is passed to the graph, therefore there is no filter and if you're not referring to any other fields in Table B, the join is not done, hence the 300 rows. Possible solutions: Add a BY field NOPRINT statement or a WHERE TABLEB.FIELD1 NE '' statement to force WebFOCUS to generate SQL to refer to TABLE B.