joining an Excel spreadsheet based on a formula

[TheBig1980s]

Hello:

I have a Crystal XI report that is made up of database tables from SQL 2005.

I need to add a column to this report from an Excel spreadsheet. As far as I know, the only field (column) from that spreadsheet that matches any of the fields on the Crystal report (for linking purposes) is a field in the spreadsheet that is a concatenation of customer ID and inventory item ID.

Now, if I create a formula in the Crystal report that concatenates the report's customer ID and inventory item ID fields, can I link the spreadsheet to the Crystal report based on these two formula fields?

I'm just trying to link the spreadsheet to the report based on a key field, and the spreadsheet's formula may be "it".

TheBig1980s

 

[IdoMillet]

You can use a formula to link to a subreport that uses the spreadsheet...

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[TheBig1980s]

Will Crystal allow me to create a subreport based on a spreadsheet without having first linked the spreadsheet to the database tables of the Crystal report?

 

[IdoMillet]

Yes.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com