If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

left outer join always brings back null

Started by danasellers@udayton.edu, 24 Feb 2010 10:11:16 AM

Previous topic - Next topic

danasellers@udayton.edu

Hi gurus,

I don't know if this is a famework manager question or a report studio question.  I have a package that joins two tables as 1..n  0..n  however, when I attempt to show a column from the 0..n table it's always null. I tested the relationship in framework manager and it brings back data and I also copied the code into my sql tool and looked for the specific record I needed and it found it.  What have I done wrong?

Thanks a bunch for any advise!

Dana

danasellers@udayton.edu

ok, never mind - quick fix I found join wasn't showing properly.  Sorry to be a bother.