If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
reports and queries
Good afternoon,
i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. |
#2
|
|||
|
|||
reports and queries
tryn2learn wrote:
i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
reports and queries
thank you i was able to group by using the report wizard and "status" as the
grouping item... however i'm still unable to get the total cout of each field. i see the =count(*) but i'm not able to get it to work, i appreciate your patience in this matter. "Marshall Barton" wrote: tryn2learn wrote: i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
reports and queries
Using a wizard to mess with a report can cause confusion.
From here on, work on the report in design view. What do you mean by "see the =count(*)"? Telling us "i'm not able to get it to work" doesn't provide any clues about what might be wrong. It would be more useful if you explained what the report displayed in the group footer text box? As a wild guess, all I can suggest is to double check that you put the =Count(*) in the text box's Control Source property instead of some other ineffective place such as a label's caption. -- Marsh MVP [MS Access] tryn2learn wrote: thank you i was able to group by using the report wizard and "status" as the grouping item... however i'm still unable to get the total cout of each field. i see the =count(*) but i'm not able to get it to work, i appreciate your patience in this matter. "Marshall Barton" wrote: tryn2learn wrote: i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. |
#5
|
|||
|
|||
reports and queries
okay, Its telling me how many groups i have, but not home many within each
group example ( i have two items under "open" status and one items under "resolved' status but it's not showing me that). it looks like this: Collective Summary: Open 2 Work In Progress 1 Hold 1 Resolved 1 Detailed Summary: Open: 2 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Work In Progress: 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Hold 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Resolved 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A "Marshall Barton" wrote: Using a wizard to mess with a report can cause confusion. From here on, work on the report in design view. What do you mean by "see the =count(*)"? Telling us "i'm not able to get it to work" doesn't provide any clues about what might be wrong. It would be more useful if you explained what the report displayed in the group footer text box? As a wild guess, all I can suggest is to double check that you put the =Count(*) in the text box's Control Source property instead of some other ineffective place such as a label's caption. -- Marsh MVP [MS Access] tryn2learn wrote: thank you i was able to group by using the report wizard and "status" as the grouping item... however i'm still unable to get the total cout of each field. i see the =count(*) but i'm not able to get it to work, i appreciate your patience in this matter. "Marshall Barton" wrote: tryn2learn wrote: i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. |
#6
|
|||
|
|||
reports and queries
sorry i meant i want it to look like this:
it looks like this: Collective Summary: Open 2 Work In Progress 1 Hold 1 Resolved 1 Detailed Summary: Open: 2 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Work In Progress: 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Hold 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Resolved 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A "tryn2learn" wrote: okay, Its telling me how many groups i have, but not home many within each group example ( i have two items under "open" status and one items under "resolved' status but it's not showing me that). it looks like this: Collective Summary: Open 2 Work In Progress 1 Hold 1 Resolved 1 Detailed Summary: Open: 2 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Work In Progress: 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Hold 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Resolved 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A "Marshall Barton" wrote: Using a wizard to mess with a report can cause confusion. From here on, work on the report in design view. What do you mean by "see the =count(*)"? Telling us "i'm not able to get it to work" doesn't provide any clues about what might be wrong. It would be more useful if you explained what the report displayed in the group footer text box? As a wild guess, all I can suggest is to double check that you put the =Count(*) in the text box's Control Source property instead of some other ineffective place such as a label's caption. -- Marsh MVP [MS Access] tryn2learn wrote: thank you i was able to group by using the report wizard and "status" as the grouping item... however i'm still unable to get the total cout of each field. i see the =count(*) but i'm not able to get it to work, i appreciate your patience in this matter. "Marshall Barton" wrote: tryn2learn wrote: i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. |
#7
|
|||
|
|||
reports and queries
It's good to know what it should look like, but What does it
actually look like? You said "Its telling me how many groups i have", does that mean "it", whatever "it" is, displays the number 4? If so, that would imply that you are not grouping the report and that the items are in a subreport. It probably also implies that you put the count text box in the report footer instead of in the **group** header or footer section. What/Where did this Collective Summary part come from??? If you are not seeing some data that you can guarantee is in the report's record source query, then there a bigger problem than what you are asking about. You better explain what records the query actually is selecting by itself, without using the report. -- Marsh MVP [MS Access] tryn2learn wrote: okay, Its telling me how many groups i have, but not home many within each group example ( i have two items under "open" status and one items under "resolved' status but it's not showing me that). it looks like this: Collective Summary: Open 2 Work In Progress 1 Hold 1 Resolved 1 Detailed Summary: Open: 2 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Work In Progress: 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Hold 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Resolved 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A "Marshall Barton" wrote: Using a wizard to mess with a report can cause confusion. From here on, work on the report in design view. What do you mean by "see the =count(*)"? Telling us "i'm not able to get it to work" doesn't provide any clues about what might be wrong. It would be more useful if you explained what the report displayed in the group footer text box? As a wild guess, all I can suggest is to double check that you put the =Count(*) in the text box's Control Source property instead of some other ineffective place such as a label's caption. tryn2learn wrote: thank you i was able to group by using the report wizard and "status" as the grouping item... however i'm still unable to get the total cout of each field. i see the =count(*) but i'm not able to get it to work, i appreciate your patience in this matter. "Marshall Barton" wrote: tryn2learn wrote: i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. |
#8
|
|||
|
|||
reports and queries
you're right, this is how it currently looks:
Status Open TechReq # Assigned To: Manager Requested: 123456789 P Port A Law TechReq # Assigned To: Manager Requested: 123456789 T Zach A Law Status Resolved TechReq # Assigned To: Manager Requested: 123456789 P Port A Law the report is partially grouped like i want. The "open" is together and the "resolved" is together with the information for each below it, but i don't know how to add the collective summary line where is shows how many are in each: Open 2 Resolved 1 sorry for not being able to explain myself, but i again appreciate your help and patience with me "Marshall Barton" wrote: It's good to know what it should look like, but What does it actually look like? You said "Its telling me how many groups i have", does that mean "it", whatever "it" is, displays the number 4? If so, that would imply that you are not grouping the report and that the items are in a subreport. It probably also implies that you put the count text box in the report footer instead of in the **group** header or footer section. What/Where did this Collective Summary part come from??? If you are not seeing some data that you can guarantee is in the report's record source query, then there a bigger problem than what you are asking about. You better explain what records the query actually is selecting by itself, without using the report. -- Marsh MVP [MS Access] tryn2learn wrote: okay, Its telling me how many groups i have, but not home many within each group example ( i have two items under "open" status and one items under "resolved' status but it's not showing me that). it looks like this: Collective Summary: Open 2 Work In Progress 1 Hold 1 Resolved 1 Detailed Summary: Open: 2 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Work In Progress: 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Hold 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Resolved 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A "Marshall Barton" wrote: Using a wizard to mess with a report can cause confusion. From here on, work on the report in design view. What do you mean by "see the =count(*)"? Telling us "i'm not able to get it to work" doesn't provide any clues about what might be wrong. It would be more useful if you explained what the report displayed in the group footer text box? As a wild guess, all I can suggest is to double check that you put the =Count(*) in the text box's Control Source property instead of some other ineffective place such as a label's caption. tryn2learn wrote: thank you i was able to group by using the report wizard and "status" as the grouping item... however i'm still unable to get the total cout of each field. i see the =count(*) but i'm not able to get it to work, i appreciate your patience in this matter. "Marshall Barton" wrote: tryn2learn wrote: i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. |
#9
|
|||
|
|||
reports and queries
I have read through our prior's and retried it is now working... thank you
again for your help and support in this. "tryn2learn" wrote: you're right, this is how it currently looks: Status Open TechReq # Assigned To: Manager Requested: 123456789 P Port A Law TechReq # Assigned To: Manager Requested: 123456789 T Zach A Law Status Resolved TechReq # Assigned To: Manager Requested: 123456789 P Port A Law the report is partially grouped like i want. The "open" is together and the "resolved" is together with the information for each below it, but i don't know how to add the collective summary line where is shows how many are in each: Open 2 Resolved 1 sorry for not being able to explain myself, but i again appreciate your help and patience with me "Marshall Barton" wrote: It's good to know what it should look like, but What does it actually look like? You said "Its telling me how many groups i have", does that mean "it", whatever "it" is, displays the number 4? If so, that would imply that you are not grouping the report and that the items are in a subreport. It probably also implies that you put the count text box in the report footer instead of in the **group** header or footer section. What/Where did this Collective Summary part come from??? If you are not seeing some data that you can guarantee is in the report's record source query, then there a bigger problem than what you are asking about. You better explain what records the query actually is selecting by itself, without using the report. -- Marsh MVP [MS Access] tryn2learn wrote: okay, Its telling me how many groups i have, but not home many within each group example ( i have two items under "open" status and one items under "resolved' status but it's not showing me that). it looks like this: Collective Summary: Open 2 Work In Progress 1 Hold 1 Resolved 1 Detailed Summary: Open: 2 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Work In Progress: 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Hold 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A Law Resolved 1 TechReq # 123456789 Assigned To:P Porter Manager Requested: A "Marshall Barton" wrote: Using a wizard to mess with a report can cause confusion. From here on, work on the report in design view. What do you mean by "see the =count(*)"? Telling us "i'm not able to get it to work" doesn't provide any clues about what might be wrong. It would be more useful if you explained what the report displayed in the group footer text box? As a wild guess, all I can suggest is to double check that you put the =Count(*) in the text box's Control Source property instead of some other ineffective place such as a label's caption. tryn2learn wrote: thank you i was able to group by using the report wizard and "status" as the grouping item... however i'm still unable to get the total cout of each field. i see the =count(*) but i'm not able to get it to work, i appreciate your patience in this matter. "Marshall Barton" wrote: tryn2learn wrote: i'm trying to produce a report that will display different status level and how many are in each level. there are 4 levels ( open, pending, waiting, closed) under each level there is a id number that will be given - i need the report not only to tell me how many i have under each status level but to give me the id's that are under that level also. for example lets say i have 4 tickets in (open) status 2(pending) 5 (waiting) and 10 (closed) status how can i get the report to not only show me these totals but the 4 under open - 2 uder pending - 5 under waiting and 10 under close... thank you for you help it is truly appreciated. Use the report's Sorting and Grouping window (View menu) to create a group on the status level field. Select Yes for the Group Header and Footer properties in the lower part of the window. Then put the status level text box in the group header section. Put a text box with the expression =Count(*) in the group footer section. Put the id number text box in the detail section. |
#10
|
|||
|
|||
reports and queries
That's good to hear, but what did you do to get the summary
part? I just found out that was the problem and haven't had a chance to suggest ways to deal with it (I think a multi-column subreport might be the most appropriate approach). -- Marsh MVP [MS Access] tryn2learn wrote: I have read through our prior's and retried it is now working... thank you again for your help and support in this. "tryn2learn" wrote: you're right, this is how it currently looks: Status Open TechReq # Assigned To: Manager Requested: 123456789 P Port A Law TechReq # Assigned To: Manager Requested: 123456789 T Zach A Law Status Resolved TechReq # Assigned To: Manager Requested: 123456789 P Port A Law the report is partially grouped like i want. The "open" is together and the "resolved" is together with the information for each below it, but i don't know how to add the collective summary line where is shows how many are in each: Open 2 Resolved 1 |
|
Thread Tools | |
Display Modes | |
|
|