Adding DB field on summary report

[flmngldn]

I created a report that summerizes data ( with drill down). All the data on the report looks fine. Now I want to add the description of the project. As soon as I insert the field on the group level my total field changes. I am not sure what is going on but I need help

 

[synapsevampire]

I suspect that it's a linking concern.

You need to at least post your Crystal version when posting, otherwise you force people to guess.

If a field from a table is not used in the report, Crystal will ignore that you added that table in the SQL, so once you add the field, the SQL is altered.

You should also paste the database/connectivity used.

You can check this by selecting Database->Show SQL Query both before and after the field is inserted.

You might want to check with your dba to understand how the joins should be accomplished.

-k

 

[flmngldn]

I am using Crystals 8.5 and accessing data from Access database. I went to Database->Show SQL Query and this option is greyed out so I cannot see the SQL code.