Is it possible????? One to many relationship.

building reports desktopintelligence
1

I am not sure if it is possible. :evil: I think I did try everythink.(sections,breaks,alerts)
On report I have to have two feilds:
Vendor Address ***** Business Type

101 Boss Aven Room1 … BS
101 Boss Aven Room1 … MNRT
1 Riva Rd … BS
1 Riva Rd … OUTS
25 Sqr.Crt … BS
25 Sqr.Crt … INST
1100 Fred.Blv … WMNO
1100 Fred.Blv … INST
…
Now…Users want to see Vendor Address and Business Type=‘MNRT’,
they still want to see VendorAddress even if Business Type<>‘MNRT’, but
if it is the same address if it was for ‘MNRT’ they want report to skip it without putting even spases.Something like that:

101 Boss Aven Room1 … MNRT
1 Riva Rd
25 Sqr.Crt
1100 Fred.Blv

Any ideas??? :reallymad:
Any help would be appreciated!

hardworker (BOB member since 2004-04-30)

2

I think a simple If statement should do the trick. Simply state that if the business type = “MNRT” then “MNRT” else " ". Let me know if you can figure it out. If not, I’ll spell out the equation.

:smiley:

indy (BOB member since 2004-04-08)

3

I did it try. It works some how, but there is duplicates of Vendor Address. (some vendors have two Bussiness Type) :confused:
What they want to see is:
if Vendor Address= previous(Vendor Address) and Business Type<>MNRT then skip it without leaving spaces…if Business Type<>MNRT but Vendor Address<>previous(Vendor Address)show Vendor Address and for Business type put “”.
If Business Type=MNRT and Vendor Address<>previous(Vendor Address) then show it.

hardworker (BOB member since 2004-04-30)

4

I think you and user22 are working on the same report.
See the following link for probable solution.

mkumar (BOB member since 2002-08-26)

5

I already saw it. There is no solution.

hardworker (BOB member since 2004-04-30)

6

You may want to create a new field in your universe that will only bring back “MNFT” or " " values. Then you want to run this field with your address field in a new query. Make sure that the ‘avoid aggregate duplication’ is turned on and you should have your report.

indy (BOB member since 2004-04-08)

7

Somebody got solution! It is done with breaks!
Thanks everybody!

hardworker (BOB member since 2004-04-30)