cancel
Showing results for 
Search instead for 
Did you mean: 

Display Result Row in Query

Former Member
0 Kudos

Hi Gurus

I need to Display Result Row in Query

story is like This

<u>Report 1 with <b>Calculate Result as</b> Nothing Defined</u>

Product--AB--C = ABS(B-A)

-


P01--


10-00---10

P02--


00-50---50

P03--


10-40---30

-


Result---20-90---<b>70</b>

-


Over all result of C = ABS((Over all result of B) - (Over all result of A))

i.e in above Example <b>70</b> = ABS(90-20)

<u>Report 2 with <b>Calculate Result as</b> Summation</u>

Product--AB--C = ABS(B-A)

-


P01--


10-00---10

P02--


00-50---50

P03--


10-40---30

-


Result---20-90---<b>90</b>

-


The Above result is displayed if the Properties of C is set to Summation from <b>Calculate Result as</b>

My requirment here is

Without using Product in Query i want the only over all result in Query output as <b>Calculate Result as</b> Summation

20 90 <b>90</b>

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Pabolu,

Will you talk about the further use of this report. If you are looking for VBA codes then, the result Position can be placed in Top/Right (in Query Properties-->Display)

Then without displaying the product:--- Here you have only the option of "No Diaplay" else the summation according to the products is not possible.

Now I can suggest to keep the Results Position Fixed : Top/Right.

regards

Happy Tony

<b>Points == Thanks</b>

Former Member
0 Kudos

You can try this:

Say ur existing row is "X"

Create a new formula say "Y" and in it use the following :

= X * <b>NOT LEAF (</b>X<b>)</b>

- Hide the row X and

- set Zero suppress on row as active (from Query properties)

Now row Y (with Result row active) will have all its row except the Result row as Blank ( or Zero) and these all zero rows should be suppressed in the output. Only the Result row will be visible with the overall result.

Hope u've understood this & this helps.

-Me

former_member188325
Active Contributor
0 Kudos

Hi,

Try by setting display of Product to 'no display' in Query designer.

from context menu of Product->Properties>display as 'No display'.

thanks