Linking three fields to one

[haamr]

I'm trying to link two Progressive tables where three fields in one table link to a single field in another table. Also, there are underscores between each of the three fields in the first table. For example:
table1.index + "_" + table1.docnum + "_" + table1.custnum = table2.key

I was able to make this work on my SQL server by going to Database -> Show Sql Query and modifying the SQL query. However, I can't do this with the Progressive database since the box is uneditable.

I'm desparate to get a solution as this is for a customer. Any help would be greatly appreciated.

 

[synapsevampire]

Try posting your Crystal version.

ince you're using CR 8.X or below, and it isn't a SQL based database, the only way that comes ot mind is to build the report, then insert a subreport and build up the linking formula in the main, and link to the subreport using that.

If you can use real SQL, then you might use the ADO connectivity and paste in the SQL.

-k

 

[haamr]

Thanks for the tip. I'm using 8.5 in my work environment, but the customer is using version 10. I'm thinking the only way we're going to get there from here is to have their dba create a view so we can pull the data from there.

Thanks again.

 

[synapsevampire]

Yeah, a View or Stored Procedure is the better way to go.

-k