vivekkohli

And that field should be the last field in that group. Other wise it will overlap with the field that occurs after this stretch with overflow field

Add a new temp group with no field latched to it, i.e leave the roup exp part empty for the group. Place the field that u want to stretch with overflow there. Nothing will overlap and it will work fine.

Try this query, it may work SELECT (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name = 'BA' AND pe.gender = 'MALE') A1, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name = 'BA' AND pe.gender = 'FEMALE') A2, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name = 'BA') A3, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name = 'BE' AND pe.gender = 'MALE') B1, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name = 'BE' AND pe.gender = 'FEMALE') B2, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name = 'BE') B3, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name NOT IN ('BA','BE') AND pe.gender = 'MALE') C1, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name NOT IN ('BA','BE') AND pe.gender = 'FEMALE') C2, (SELECT COUNT(id) FROM person pe JOIN program pr ON pe.id = pr.id AND pr.name NOT IN ('BA','BE')) C3

Hi, I have a problem with page footer. I want a manually added group to behave as a page footer, as i want to print a lot of records. So I have added a new group as a requirement to print those records on a new page. But now i need to print a sub report on a new page which is a full A4 size report. If i put the sub report in the summary section then it will print only for the last record. But if i put the sub report in the groups which i made then the page footer is not allowing to generate the report. If i remove the page footer then it works fine. But I need the page footer. I also tried to put the footer into some other added group but then the footer data starts to appear at the end of the data that prints before it and not at the bottom of the page. So this is not the solution. I have exhausted all that I could try. I am asking for everyone's help. Thanks in advance Vivek