cancel
Showing results for 
Search instead for 
Did you mean: 

Formula as linking field

Former Member
0 Kudos

Hello,

I have 2 fields that make up a key to a linked table.

How do I get the database expert to recognize a formula field (Field1+Field2)?

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Will,

You cannot!

Use a SQL Query (with the Join on the concatenated fields) to create the report instead. You can add this SQL Query via the 'Add command' option.

-Abhilash

0 Kudos

You can however use the formula in a subreport link so that may work for you also.

What are you actually trying to do? Maybe there is another way to do it...

Don

Former Member
0 Kudos

Ab,

I tried your 'Add Command' option and it worked. Thanks.

I have found that when I use this approach, CR will intermittently hang (not responding) when reading records.

Any idea why this would happen?

Thanks

Former Member
0 Kudos

Hi Will,

First thing you create new report with "Add command" option . I hope the command contains more records thats why CR hanged when reading records.

Note: CR hanged some times while the command query edit or modify .

Please provide the add command query more helpful us.

Use SQL commands to solve report problems and speed Crystal Reports

Thanks,

DJ

abhilash_kumar
Active Contributor
0 Kudos

Glad the Add Command suggestion worked.

There could be many reasons why that can happen. I recommend posting a new discussion for that issue per SCN's rules.

-Abhilash