I replaced group by with Where but still the same i am attaching the package i created.
use "date selection" Form PPMquery and run the query please check "Coil Shop" should be grouped but the problem is they are separated because dates are different.
What i want "Coil Shop" should in...
I have a problem with the result of a Query.
Start Date
End Date
Query runs after entering unbound pameter text box Start and end date.
What i want is i am grouping of Opertaor, sum of defects between the dates.
but dates i am not able to group or sum or etc.
I want when the start...
HI all
I request you all to correct the data base to record the defect of an operator and supllier wise.
if total defects of the day is 10 then it should prompt the subcalculation of all defects selecting operator's as well as supplier's defects and grand total of the defects should be...