Need solution with crystal report

Yahoo Archive
1
Not knowing the exact details, I would say use an Outerjoin on the Crystal Report Database link that links your extra table to the rest of your data.




________________________________
From: tpaulavicius <tpaulavicius@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 2, 2009 10:40:12 AM
Subject: [Vantage] Need solution with crystal report





Hello,

I added extra table in Report data Definition.
Sometime this table has content and is populated in xml, sometimes it has no content and is'nt populated in xml.

Problem happens when I use field from this table in Crystal Report, but there is no content from this table populated in XML. All report gets blank.

I've tried to use IsNull({ExtraTable. SomeField} ), but that does not help.

How to chech if this table has content and is populated in xml with Crystal report?

Thanks,
Tom







[Non-text portions of this message have been removed]
2
Hello,

I added extra table in Report data Definition.
Sometime this table has content and is populated in xml, sometimes it has no content and is'nt populated in xml.

Problem happens when I use field from this table in Crystal Report, but there is no content from this table populated in XML. All report gets blank.

I've tried to use IsNull({ExtraTable.SomeField}), but that does not help.

How to chech if this table has content and is populated in xml with Crystal report?

Thanks,
Tom