linking datflex files with other files

[lauriesamh]

I'm using CR8.5 and am trying to link a dat file using datflex to another system table. The problem I'm having is that the field I'm linking to (person_id) is a String length 8 in the dat file and a String length 9 in the other table. I want to edit the link in the SQL Query tool, however it is greyed out. Any ideas how to edit the link
where
person_id = substring (person_id Other table,1,8)

Thanks

 

[IdoMillet]

If these files are from 2 different data sources, consider using a linked subreport instead of a join.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lauriesamh]

I'm going to try the subreport. Do you think the reason the SQL section is greyed out is due to the limitations of the data flex driver I'm using? Is there any patch for the dataflex driver that would allow me to edit in sql?

 

[IdoMillet]

It makes sense that SQL editing is limited to a single data source.

Another option is to link to these two data sources from MS Access and then use Crystal to connect to Access as a single data source.

By the way, you never stated what the 2nd data source is.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com