Values not Displaying

[UcfMike]

I have a report that was originally created in Improptu, that I've recreated in Report Studio off a FM model.

In Impromptu, if the row didn't have any data, it would still display in the report. In Report Studio, the row doesn't show.

So for instance in Impromptu I would get this

Item Sold
-------------
Milk 4
Tofu
Eggs 3
-------------

But in Report Studio I get this

Item Sold
-------------
Milk 4
Eggs 3
-------------

Is this a Report Studio setting or a FM modeling issue?

 

[pwhp67]

It looks like an outer join was used in Impromptu but not in FM.

I'm not using FM or Report Studio yet. Can you see the SQL? If you can, and there isn't an outer join, I would look at the Impromptu SQL.

 

[UcfMike]

I think you're right. Right now I'm trying some different join strategies to see if I can make the model more efficient.