Hello,
I have 2 SQL tables A and B.
Field 1 from table A is a 15 characters string field.
Field 1 from table B is a 25 characters string field.
Both tables have records matching by their 1st 10 characters
Like so:
Table A Field 1 Table B Field 1 Table B Field 2 AAAAAAAAAA12345 AAAAAAAAAA987874565645 100 BBBBBBBBBB12345 AAAAAAAAAA12377660011 100 CCCCCCCCCC12345 BBBBBBBBBB66120022334 200 DDDDDDDDDD12345 CCCCCCCCCC12377660012 300 DDDDDDDDDD12377660013 400 DDDDDDDDDD12377660014 400 DDDDDDDDDD12377660015 400
I need to create a report based on table A, but I also need Table B Field2 column (always the same for all Table B records starting with the same 10 characters)
How can we create such a link in CR11? (reports are using ODBC to connect to SQL tables)
I have tried all the combinations possible for the link, report always comes up empty.
Basically, I think can filter the records from the selectionformula (Left(TableA Field1,10)=Left(TableB Field1,10)), but it seems the link (outer join) from Table A to table B is not working as I expect.
Any ideas on how that link should be defined?
Thank you
Yannis