I am trying to create a report using two tables. The problem is that the field in the field in the one table has trailing spaces and the other tables does not. For example, the one table has Item ABC123 and the other table has Item ABC123 with 10 trailing spaces. If I link the tables as is, I get no records. Is there a way to create a link using a 'Trim' statement??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking Tables 1
- Thread starter jsecco
- Start date
-
1
- #2
You cannot link tables with a formula field. You need to write 2 reports, and insert the one with the trim() formula in it as a subreport, linmked by the database field and the formula field in the second report. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
714-348-0964
dgilsdorf@mchsi.com
synapsevampire
Programmer
Fix the table, even a bad DBA should be able to correct this almost immediately.
A View is probably the quickest way to resolve this.
-k kai@informeddatadecisions.com
A View is probably the quickest way to resolve this.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question