[progress Communities] [progress Openedge Abl] Forum Post: Outer Apply From Crystal Reports...

  • Thread starter Thread starter richtpt
  • Start date Start date
Status
Not open for further replies.
R

richtpt

Guest
In Crystal Reports I'm writing a command to get the data. When I try to save the command it tells me it can't find the outer apply table.field. Here's the sql (note the outer apply is simplified for testing): select tag_rec."tag-num", tags.TagDetTally, pro_duct.desc2 as 'Size', tag_rec.desc2 as 'TRLength' from tag_rec inner join pro_duct on pro_duct.product = tag_rec.product outer apply (select tag_detail.tagnum as 'TagDetTally ' from tag_detail where tag_detail."tag-num" = tag_rec."tag-num") tags It keeps saying it can't find tags.TagDetTally. This works fine in Crystal when connecting to a sql server database. Is this not possible? Thanks! p.s. Connection is using the Progress OpenEdge 11.5 ODBC driver. The driver works fine, just can't get this outer apply working.

Continue reading...
 
Status
Not open for further replies.
Back
Top