Linking tables from 2 db drivers

[istuart]

I linked two tables using the same field from each, but the tables are from two different database sources. One table is from a Peoplesoft Query the other from Excel.

The data source for the main report is Peoplesoft while the subreport's data source is from Excel. I'm able to browse field data from the subreport but the report itself is blank. What am I doing wrong? Is it because it's two distinct db drivers?

 

[groggle]

It is technically possible to do what you are doing.

My guess is there is a difference between the two fields by which you are linking the main report and subreport.

Use Crystal to browse both the fields in the main and sub reports to identify their data type and length. If they are not identical (data type and length if a string and data type if not a string) then this would be the reason.

It is possible to create a formula in either the main or sub report to "make" one identical to the other. Then link the main report to the subreport via the formula field in one to the matching data field in the other.

 

[istuart]

Thanks, I figured this was the problem. I tried to change the field property in the excel file. Both are strings but the excel file is a standard 255 characters and I can't figure out how to change it. (the field in the psoft query is a 10 character string).

How can I create a formula to make the fields identical to one another?

 

[lbass]

In CR, create a formula using the Excel field like this:

left({excel.string},10)

Then you can use this formula to link the subreport to the main report on the psoft string.

-LB

 

[istuart]

Should I create this formula in the main report?

 

[istuart]

You guys freakin amaze me!!! Thanks, that did the trick. I created the formula in the main report and it worked like a charm. Thanks lboss and groggle.