I am having column which contains status as "Quoted", "Job Awarded","Enquiry" and atlast i am showing the totals for all the status like
Total Quoted :
Total Awarded :
and also the status is passed as a parameter.If the user select "Quoted", then it will show only the Records with status as "Quoted" and it will show the total for the "Quoted" Status only. But the problem is, If i select any of the status, other status total will not appear.
because it is grouped by the status also.
My question is.
Whatever the selection crieteria, the user is giving, i need to show all the totals of the status at the end of the
report.
Solution:
----------
The sol: which i found out was
if the user select the status as "Quoted" also, i will show all the records with all the status. I want to suppress the
records which doesn't have the Status as "Quoted" and also
if the user doesn't select the status, i need to show all the records with all the status
Early Reply solicited.
Very URgent
Regards,
Buhari
Total Quoted :
Total Awarded :
and also the status is passed as a parameter.If the user select "Quoted", then it will show only the Records with status as "Quoted" and it will show the total for the "Quoted" Status only. But the problem is, If i select any of the status, other status total will not appear.
because it is grouped by the status also.
My question is.
Whatever the selection crieteria, the user is giving, i need to show all the totals of the status at the end of the
report.
Solution:
----------
The sol: which i found out was
if the user select the status as "Quoted" also, i will show all the records with all the status. I want to suppress the
records which doesn't have the Status as "Quoted" and also
if the user doesn't select the status, i need to show all the records with all the status
Early Reply solicited.
Very URgent
Regards,
Buhari