Crystal Reports 2005- Group totals in the page footer
-
Hi Guys, I'm totally new to Crystal reports and this problem has me stumped. Here it is, lets say i have a table of employees this table has the departments they work in too and i want to display the number of employees in each department at the end of the report(in the page footer) Here is what i did so far Added a new group and grouped the records according to the Department name This gives me the total of the employees in that department but it appears within the table i created I want these to move in to the page footer If i do move it to the page footer i get the total of only one group Been banging my head against this for the past couple of days now. I'm sure i'm missing something obvious. Do i need a formula Field??? Also if i still want the group totals but i need the records sorted on another field is that possible?
-
Hi Guys, I'm totally new to Crystal reports and this problem has me stumped. Here it is, lets say i have a table of employees this table has the departments they work in too and i want to display the number of employees in each department at the end of the report(in the page footer) Here is what i did so far Added a new group and grouped the records according to the Department name This gives me the total of the employees in that department but it appears within the table i created I want these to move in to the page footer If i do move it to the page footer i get the total of only one group Been banging my head against this for the past couple of days now. I'm sure i'm missing something obvious. Do i need a formula Field??? Also if i still want the group totals but i need the records sorted on another field is that possible?
Colwin wrote:
Hi Guys, I'm totally new to Crystal reports and this problem has me stumped. Here it is, lets say i have a table of employees this table has the departments they work in too and i want to display the number of employees in each department at the end of the report(in the page footer) Here is what i did so far Added a new group and grouped the records according to the Department name This gives me the total of the employees in that department but it appears within the table i created I want these to move in to the page footer If i do move it to the page footer i get the total of only one group Been banging my head against this for the past couple of days now. I'm sure i'm missing something obvious. Do i need a formula Field??? Also if i still want the group totals but i need the records sorted on another field is that possible? Quote Selected Text
A couple of things... 0) End of report != Page footer 1) Are you saying you want the information to appear only at the end of the report, or should it appear at the end of every page? 2) If at the end of every page, what if the detail section for a department requires more than one page? What should be printed at the end of the first page then? 3) If at the end of the report (Report footer), do you want just a list of the data grouped by departments? If yes, why don't you create a sub-report containing just the grouped information and stick it in the Report footer? This way, you can have your main report ordered any other way you need too... HTH
-
Colwin wrote:
Hi Guys, I'm totally new to Crystal reports and this problem has me stumped. Here it is, lets say i have a table of employees this table has the departments they work in too and i want to display the number of employees in each department at the end of the report(in the page footer) Here is what i did so far Added a new group and grouped the records according to the Department name This gives me the total of the employees in that department but it appears within the table i created I want these to move in to the page footer If i do move it to the page footer i get the total of only one group Been banging my head against this for the past couple of days now. I'm sure i'm missing something obvious. Do i need a formula Field??? Also if i still want the group totals but i need the records sorted on another field is that possible? Quote Selected Text
A couple of things... 0) End of report != Page footer 1) Are you saying you want the information to appear only at the end of the report, or should it appear at the end of every page? 2) If at the end of every page, what if the detail section for a department requires more than one page? What should be printed at the end of the first page then? 3) If at the end of the report (Report footer), do you want just a list of the data grouped by departments? If yes, why don't you create a sub-report containing just the grouped information and stick it in the Report footer? This way, you can have your main report ordered any other way you need too... HTH
Thank you for your response. i need the information at the end of the report. The end of the report need the count of all the employees in each department like this Dept1 10 Dept2 14 . . . . like that. I don't know at the start how many departments are there i will look at embedding a sub report at the end of the report Thanks again Colwin
-
Colwin wrote:
Hi Guys, I'm totally new to Crystal reports and this problem has me stumped. Here it is, lets say i have a table of employees this table has the departments they work in too and i want to display the number of employees in each department at the end of the report(in the page footer) Here is what i did so far Added a new group and grouped the records according to the Department name This gives me the total of the employees in that department but it appears within the table i created I want these to move in to the page footer If i do move it to the page footer i get the total of only one group Been banging my head against this for the past couple of days now. I'm sure i'm missing something obvious. Do i need a formula Field??? Also if i still want the group totals but i need the records sorted on another field is that possible? Quote Selected Text
A couple of things... 0) End of report != Page footer 1) Are you saying you want the information to appear only at the end of the report, or should it appear at the end of every page? 2) If at the end of every page, what if the detail section for a department requires more than one page? What should be printed at the end of the first page then? 3) If at the end of the report (Report footer), do you want just a list of the data grouped by departments? If yes, why don't you create a sub-report containing just the grouped information and stick it in the Report footer? This way, you can have your main report ordered any other way you need too... HTH
-
You are welcome :)