Display Result Row in Query

[Former Member]

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>

[Former Member]

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]

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]

Hi,

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

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

thanks