Report Grouping

[majid.pervaiz]

Dear friends,

I have a report where I want to represent data by year and quarter within that and within that the type of request and then I want to identify whether task is met or not met.

attached is the sample report. I don't know why it is repeating the met and not met and not grouping it.

appreciate your expert advice.

 

[JHB]

Do you've the grouping in the report or in the query.
Show the report in design view.
Or post your database with some sample data, + name of the report.

 

[majid.pervaiz]

Dear JHD - group is in the report.. I am not sure how to do grouping in query. see the screenshots that's how I did query

 

[JHB]

Grouping needs to be in the report, so that is correct.
Show the report in design view.
Or post your database with some sample data, + name of the report.

 

[majid.pervaiz]

attached is the report design, appreciate your help JHB.
additionally, I don't know the year and quarter showing numeric number

 

[JHB]

additionally, I don't know the year and quarter showing numeric number

What do you mean with the above?
Your report (design) looks more or less okay, so is it possible for you to post your database with some sample data, (zip it)?