I have two tables which match a main table with a side table. There are two fields on both tables which correspond to each other, legal entity and investor. It auto links the tables using an inner join, not enforced, and equal. When I run the report, however, I'm getting a zero value for the side table which isn't possible. I feel like the main table isn't pushing the investor and legal entity values over to the side report. I've tried all of the joins and other options but I'm stumped at this point. Any ideas would be appreciated!

 

Thanks,

Brandon

 

Did you get any data at database side by applying the same innere join in the query?

 

Please check wheather data is comming at database side or not?

 

if it is comming data at database side then copy the query and paste the query in Crystal Add command then you  can get the same data which is getting in Database side.

 

Regards,

Naga.