Problem Grouping
Hi there!
I'm trying to make a report grouping data of two queries but I want to group them in two different groupheaders. I mean I want to get something like:
Static text(printed using masterheader)
GroupHeader with condition1
Masterdata
Groupfooter with data
Master footer (to sum query result)
Masterheader (other text)
Masterdata (other query)
Masterfooter (sum other query)
...
Other static text
Other groupheader with coundition2, printed SEPARATELY from the first
Masterdata
Groupfooter with data
Master footer (to sum third query's result)
But unfortunately I get something like:
Static Text
Group1 and Group2
Other bands
I've searched and tried everything in this forum about grouping, but with no result. Is it possible to get report looking as I want?
I'm trying to make a report grouping data of two queries but I want to group them in two different groupheaders. I mean I want to get something like:
Static text(printed using masterheader)
GroupHeader with condition1
Masterdata
Groupfooter with data
Master footer (to sum query result)
Masterheader (other text)
Masterdata (other query)
Masterfooter (sum other query)
...
Other static text
Other groupheader with coundition2, printed SEPARATELY from the first
Masterdata
Groupfooter with data
Master footer (to sum third query's result)
But unfortunately I get something like:
Static Text
Group1 and Group2
Other bands
I've searched and tried everything in this forum about grouping, but with no result. Is it possible to get report looking as I want?
Comments
look at using subreport objects in detailbands set to a rowcount of 1 and not connectted to any dataset
EDIT: I've been misunderstood the point of groupcondition in Groupheader. After some headbanging the problem is solved editing SQL to specify exact groupcondition.
Regards!