Deleted Controls Still there and being acessed

[Shadez]

Heres a strange one for you guys to ponder over

I have just updated a existing report and deleted several controls, the strange thing is the controls still exist somewhere. Evey time i run the report it asks me for the contents of the fields

I have checked the entire report no visible trace of the control, and no reference to it left in code

I have compacted several times and no change

anyone know a round it without restarting the report from scratch

Shadez

 

[Rich]

There is some other reference to the fields somewhere on the report or in the sorting and grouping options

 

[Shadez]

I dont think so, here is the query used to create the report, the deleted fields where [calltime] and [Product]. [Calltime] was removed entirely and [product] was changed to [countofproducts].

SELECT DISTINCT [QueryCallHistory].[NCO], [QueryCallHistory].[CallActivityIDFK], [QueryCallHis3b].[PracticeIDFK], [QueryCallHistory].[CallIDPK], [QueryCallHistory].[CallDate], [QueryCallHis3b].[Title], [QueryCallHis3b].[FirstName], [QueryCallHis3b].[Inital], [QueryCallHis3b].[Surname], [QueryCallHistory].[PersonnelIDPK], Sum(IIf([actionidfk]=1,1,0)) AS Detailed, Sum(IIf([actionidfk]=3,1,0)) AS SecRec, Sum(IIf([actionidfk]=2,1,0)) AS Sample, Sum(IIf([actionidfk]=4,1,0)) AS TransOrder, [QueryCallHis3b].[CountOfproduct]
FROM QueryCallHis3b INNER JOIN (QueryCallHistory INNER JOIN Products ON [QueryCallHistory].[product]=[Products].[Description]) ON ([QueryCallHis3b].[PersonnelIDPK]=[QueryCallHistory].[PersonnelIDPK]) AND ([QueryCallHis3b].[CallIDPK]=[QueryCallHistory].[CallIDPK])
WHERE [QueryCallHistory].CallData.[CallDate]>#11/25/2002# And [QueryCallHistory].CallData.[CallDate]<#3/7/2003# And [Products].[ProductIDPK] In (2,3,4,5,6,7,8,9) And [QueryCallHistory].CallData.[CallActivityIDFK] In (1,2,3,4,5,6,7,8,9)
GROUP BY [QueryCallHistory].[NCO], [QueryCallHistory].[CallActivityIDFK], [QueryCallHis3b].[PracticeIDFK], [QueryCallHistory].[CallIDPK], [QueryCallHistory].[CallDate], [QueryCallHis3b].[Title], [QueryCallHis3b].[FirstName], [QueryCallHis3b].[Inital], [QueryCallHis3b].[Surname], [QueryCallHistory].[PersonnelIDPK], [QueryCallHis3b].[CountOfproduct]
ORDER BY [QueryCallHistory].[CallDate] DESC , [QueryCallHistory].[CallActivityIDFK] DESC;

this query workes fine when run.

If there is a reference on the report its buried somwhere it cannot be accessed.


Shadez

 

[Carmen]

Try going into the Design View of your report and checking the Sorting and Grouping options there.........