Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: How to include a condition when linking tables Post Reply Post New Topic
Author Message
charlese
Newbie
Newbie


Joined: 21 Apr 2011
Online Status: Offline
Posts: 33
Quote charlese Replybullet Topic: How to include a condition when linking tables
    Posted: 21 Nov 2013 at 6:04am
Hi,
 
The source for my reports are based on XSD tables NOT stored procedure or SQL.
So in Database Expert, I brought in my 3 XSDs required for the report and linked them together.  However I also want to specify at this stage to ignore zero amount from the ARBalance xsd.
The problem I am having is my report still printing the Report header, page header, even though the amont in the detail is zero and I don't want to print anything if the amount from ARBalance is zero.
 
Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 21 Nov 2013 at 8:36am
I would put the filter in the Report/Selection Formulas/Record

as opposed to the join/link criteria.

Obviously, if you have an app that is creating the XML files, you could have that filter out the records that have the ARBalance = 0.

HTH
IP IP Logged
charlese
Newbie
Newbie


Joined: 21 Apr 2011
Online Status: Offline
Posts: 33
Quote charlese Replybullet Posted: 22 Nov 2013 at 4:55am
Hi,
 
Thank you for your advise on this.  I amended as you requested and added this line
 
{ARDetailBalances.BalDue} > 0.00
 
But it is still printing a blank page.
 
Any more ideas please ?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 02 Dec 2013 at 5:03am
I guess I would check the data to make sure that there is data to be displayed.

Nothing worse than trying to fix a report that isn't broken...I would just make sure that how the 3 files are being join/linked actually results in a valid record

Sorry I can't give any better solution
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.