Problem with GroupHeaderBand

[shmuly]

An issue that I am now facing is that I would like to summarize one of the groups and have the summary of the group and other group values to show up on one line. Therefore, instead of using a data band to display the other groups values, I am putting it all in the group footer. I added the code that you mentioned above to the before click event and end render event but for some reason for the first time the group text box is supposed to be displayed, its not coming in, instead it comes in for the last row, example-

Instead of having my report look like this:

Date-------------------Account----------------Campaign--------------Amount
9/25/2007--------------1111-------------------Dinner 2008------------$850
--------------------------------------------------Tuition 2008------------$8,000
-------------------------222---------------------Dinner 2007------------$500
-------------------------333---------------------Dinner 2007------------$300
9/26/2007-------------1111-------------------Camp 2008-------------$100
-------------------------555---------------------Tuition 2008------------$7,000

It’s showing up like the following:

Date Account Campaign Amount
--------------------------1111--------------------Tuition 2008-----------$8,000
--------------------------222---------------------Dinner 2007------------$500
9/25/2007--------------333---------------------Dinner 2007------------$300
--------------------------1111-------------------Camp 2008 -------------$100
9/26/2007-------------555---------------------Tuition 2008------------$7,000



In this report, I have three groupings, date, account, and campaign. I am trying to get a total of all the invoices for each campaign grouped by the campaign, account, and date. After the campaign grouping, I have a data band that’s height and its text boxes that it includes are set to zero, this is how I get the amounts to summarize for the campaign in the campaign group footer.
In the first group footer, I have the date, account, campaign, and sum amount textboxes. In the date and account text box I have the following code in the Before Print Event (txtAccountId.Enabled = AccountIdVar CStr(Payments.accountid)
AccountIdVar = Payments.accountid

The issue is that the txtAccountId is only printing the value for the last row of the group, instead of the first even though the first time the report is printing the first row, the txtAccountId value is nothing.

Thank you in advance.

[Edward]

Please open the attached report in the Demo.exe example application from the standard delivery of Stimulsoft Reports.Net.

Please take a look on the following aspects:

- Sort of DataBand
- EndRenderEvent of GroupHeader1
- GroupHeader1.BeforePrintEvent

Please let us know if any help is required.

Thank you.

[shmuly]

I am still facing the issue when I want to print all the group fields and a sum of a fourth field all on one line (since I am summarizing the fourth field, I would like to put all the fields on the group footer instead of the header which is causing the problems that I mentioned above). Is this feasible, should I be able to print three fields that are grouped and a fourth summarized one all on one line without repeating group fields?