Join two fields and one time

[djieon]

Hi all,

I am trying to create the following in Crystal Reports xi

JOINS between tables

RM_COMMON_ATTRIBUTES.EASTING >= CFG_MAP_REGISTER.EASTING_BLC
RM_COMMON_ATTRIBUTES.EASTING <= CFG_MAP_REGISTER.EASTING_TRC
RM_COMMON_ATTRIBUTES.NORTHING >= CFG_MAP_REGISTER.NORTHING_BLC
RM_COMMON_ATTRIBUTES.NORTHING <= CFG_MAP_REGISTER.NORTHING_TRC

so I have done this by taking two lines from the same field on the left too two fields on the right...however when I make 1 of the lines greater than it also makes the other line greater than...

any ideas?

Thanks.

David.

 

[kray4660]

I believe that is a restriction of SQL. You may have to do some of the 'filter' in either a where clause (command, stored procedure) or in selection criteria.

 

[hilfy]

Or you may have to write a Command (SQL Select statement) to do this. For more information on using Commands, see here:

http://scn.sap.com/community/crysta...ices-when-using-commands-with-crystal-reports

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com