Formula

[mikema]

All,

Ok I have become desperate. I never thought it would be so difficult to generate such simple reports. All I want to do is report on an access db and set a formula that has a where clause which is similar to this.
{SelectedAccounts.SourceSam} = {AccountRefs.Account} thats it. Not to difficult. It works just fine in Access but I can't seem to get the identical report in Crystal Reports. Please can someone help?

Thanks to all,

- Mike

[sig][/sig]

 

[HoustonGuy]

I'm not sure what type of formula you are trying to build Mike. Are you trying to show only the two fields that match?
If so, this should be in the record selection formula for the entire report.

Also, are the tables in your report joined properly?

Do you have more info you can give?

Cody [sig]<p>Cody ford<br><a href=mailto:codyjford@hotmail.com>codyjford@hotmail.com</a><br><a href= > </a><br>VB, VBS, Seagate Info/Crystal Reports<br>
[/sig]

 

[mikema]

Cody,

Thanks for the quick response. This might help. Here is the SQL statement that I use in Access to generate the needed recordset. However, I can't seem to build the report to be identical to this.

SQL: Select DISTINCT AccountRefs.Account, SelectedObjects.Fullname
From AccountsRefs INNER JOIN SelectedObjects ON AccountRefs.Account = SelectedObjects.SourcSam

Thats it. I thought this would be very simple to generate under crystal reports but I'm having trouble.

thanks

[sig][/sig]

 

[kenhamady]

mikema,

In Crystal you don't link tables by formula (like a where clause). You link tables in a visual linking window, something like the lines you draw in access relationships.

Crystal may have tried to help you by &quot;Smart Linking&quot; but since your link has fields of different names, it couldn't have gotten the link correct.

In the design environment use &quot;Database&quot; &quot;Visual Linking Expert&quot; and you should see the two tables. Drag the field from one to the other to create the link. It will default to an Equal (Inner) join. Make sure that you delete any other arrows that appear.

When you are done if you go to &quot;DataBase&quot; &quot;Show SQL Query&quot; you should see your SQL statement. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Taining by Ken Hamady</a><br>[/sig]