Joined: 15 Oct 2007
Online Status: Offline
Posts: 10
Topic: Linking Cross-tabs Posted: 15 Oct 2007 at 1:07pm
I cannot create one cross-tab report that contains the data I need so I’ve created 3 cross-tabs and placed them side by side. The problem is because the rows with null values are suppressed my reports do not line up. Is it possible to link the cross-tabs reports?Thanks
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 15 Oct 2007 at 3:52pm
That's a bit tricky. I would try doing a left-outer join with the Country table being the left-most field. That way all the countries would be listed even if there wasn't data in the right-side table. If that doesn't work, you could insert a couple rows of dummy data with zeros in it to get each country listed in the cross-tab.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 15 Oct 2007
Online Status: Offline
Posts: 10
Posted: 16 Oct 2007 at 7:20am
Thanks Brian,
I tried doing a left-outer join with the Country table being the left-most field but i get an error stating that the "joint expression not supported" and it's not really possible for me to add any dummy data to the database.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
