BO : Sum in Synchronized Request

X-cc: Isabelle JORET ijoret@Camaieu-Homme.com,
Jean-Marc MOREL jmmorel@Camaieu-Homme.com MIME-Version: 1.0

Hi,

I’ve got te following problems.
I have 2 request synchonized, i make a break on an object from the first one and i want to do a sum on an object of the second one. In this case BO sent back the sum of the second object but dont take any care of the break.
What can i do ?

exemple :

This is what i have

Table 1 Table 2
Cl. 1 Cl. 2 Val 1 Cl.2 Val 2
A a 10 a 1500
A a 20 a 2000
B b 30 b 1000
B c 40 b 500
c 2400

This is what I want

Cl. 1 Val 1 Val 2
A 30 3500
B 70 3900

And this is what i obtain

Cl. 1 Val 1 Val 2
A 30 7400
B 70 7400

Laurent DUMONT
Chef de Projet Informatique

TÈl direct : 03 20 99 37 49
Fax : 03 20 99 95 10


Listserv Archives (BOB member since 2002-06-25)

Laurent,

I have run into this before and if I remember correctly I fixed it by breaking on both objects together instead of just the one. For example, instead of my break 1 being on Val 1, it was on Val 1, Val 2. I hope I am remembering my resolution correctly!!! I hope it helps!!

Maria D. Carter :slight_smile:
BusinessObjects Developer
(336) 279-2242
mcarter@gbncmail.ims.att.com

I’ve got te following problems.
I have 2 request synchonized, i make a break on an object from the first
one and i want to do a sum on an object of the second one. In this case BO sent back the sum of the second object but dont take any
care of the break.
What can i do ?

exemple :

This is what i have

Table 1 Table 2
Cl. 1 Cl. 2 Val 1 Cl.2 Val 2
A a 10 a 1500
A a 20 a 2000
B b 30 b 1000
B c 40 b 500
c 2400

This is what I want

Cl. 1 Val 1 Val 2
A 30 3500
B 70 3900

And this is what i obtain

Cl. 1 Val 1 Val 2
A 30 7400
B 70 7400

Laurent DUMONT
Chef de Projet Informatique


Listserv Archives (BOB member since 2002-06-25)

Laurent,

It LOOKS like you don’t have the two queries linked together. Make sure Query 1 (the data provider for Table 1) is linked to Query 2 (the data provider for Table 2) via Cl.2.


Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com

This is what i have

Table 1 Table 2
Cl. 1 Cl. 2 Val 1 Cl.2 Val 2
A a 10 a 1500
A a 20 a 2000
B b 30 b 1000
B c 40 b 500
c 2400

This is what I want

Cl. 1 Val 1 Val 2
A 30 3500
B 70 3900

And this is what i obtain

Cl. 1 Val 1 Val 2
A 30 7400
B 70 7400


Listserv Archives (BOB member since 2002-06-25)

Written Previously:
Laurent,
It LOOKS like you don’t have the two queries linked together. Make sure Query 1 (the data provider for Table 1) is linked to Query 2 (the data provider for Table 2) via Cl.2.


Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com

This is what i have

Table 1 Table 2
Cl. 1 Cl. 2 Val 1 Cl.2 Val 2
A a 10 a 1500
A a 20 a 2000
B b 30 b 1000
B c 40 b 500
c 2400

This is what I want

Cl. 1 Val 1 Val 2
A 30 3500
B 70 3900

And this is what i obtain

Cl. 1 Val 1 Val 2
A 30 7400
B 70 7400


Listserv Archives (BOB member since 2002-06-25)