Codejock Developer Community : [SOLVED] Total in Footer

[SOLVED] Total in Footer : Hi cbs,The loop can be placed...

Wed, 13 Apr 2011 10:41:18 +0000

Author: Xander75
Subject: 17343
Posted: 13 April 2011 at 10:41am

Hi cbs,

The loop can be placed anywhere within your code after the grid has been populated with the data. This method creates a column footer, not the best method I think!

The following link shows another way in which to do this instead with using the FooterRow technique: http://forum.codejock.com/forum_posts.asp?TID=18062

There's a few screenshots to show you how I did it and the code to reproduce it too, which I believe I did for you too cbs

Anyways, I hope this helps.

[SOLVED] Total in Footer : Hi Xander75,Can you suggest where...

Tue, 22 Mar 2011 17:52:49 +0000

Author: cbs
Subject: 17343
Posted: 22 March 2011 at 5:52pm

Hi Xander75,

Can you suggest where to place this loop to produce the footer totals?

Thanks,
CBS

[SOLVED] Total in Footer : Ok Thanks.. Let us expect in...

Wed, 29 Sep 2010 11:33:49 +0000

Author: SHAN
Subject: 17343
Posted: 29 September 2010 at 11:33am

Ok Thanks..

Let us expect in the future CJ release....

[SOLVED] Total in Footer : Hi,If you look in my previous...

Wed, 29 Sep 2010 11:28:57 +0000

Author: Xander75
Subject: 17343
Posted: 29 September 2010 at 11:28am

Hi,

If you look in my previous posting at the bottom I did say "However I don't believe there's a way to change the Font ForeColor or Backcolor."

I did try to do this but I was unsuccessful in finding a solution. I had a look at using Markup but I am unsure if this is possible either.

[SOLVED] Total in Footer : Waw Thanks for Quick Reply It...

Wed, 29 Sep 2010 11:18:23 +0000

Author: SHAN
Subject: 17343
Posted: 29 September 2010 at 11:18am

Waw Thanks for Quick Reply

It works..........

What about ForeColor and BackColor?

Is that possible to Change also....???

[SOLVED] Total in Footer : Hi, I know you can change the...

Wed, 29 Sep 2010 10:50:35 +0000

Author: Xander75
Subject: 17343
Posted: 29 September 2010 at 10:50am

Hi,

I know you can change the Footer Font, Style, Size etc by using the following code:

    Dim Column As ReportColumn
    Set Column = rpcGrid.Columns(1)
    With Column
        .FooterAlignment = xtpAlignmentRight
        .FooterFont.Bold = True
        .FooterFont.Italic = True
        .FooterFont.Name = "Courier New"
        .FooterFont.Size = "12"
    End With

However I don't believe there's a way to change the Font ForeColor or Backcolor.

[SOLVED] Total in Footer : Hi, Now i have a question ,...

Wed, 29 Sep 2010 10:32:04 +0000

Author: SHAN
Subject: 17343
Posted: 29 September 2010 at 10:32am

Hi,

Now i have a question , How do I highlight the footer total as Bold/ Different foreColor/ Backcolor...?

Is that possible?

[SOLVED] Total in Footer : Hi Thanks for the Code....! It...

Wed, 29 Sep 2010 10:15:59 +0000

Author: SHAN
Subject: 17343
Posted: 29 September 2010 at 10:15am

Hi Thanks for the Code....!

It works for the footer total... !

Untill CJ implements this footer total we can use your solution.....!

[SOLVED] Total in Footer : Hi,You could do this once your...

Wed, 29 Sep 2010 05:30:28 +0000

Author: Xander75
Subject: 17343
Posted: 29 September 2010 at 5:30am

Hi,

You could do this once your ReportControl is populated, using a loop to count the data required and then update the footer.


    Dim dColVal as Double
    Dim Record as ReportRecord
    
    dColVal = 0

    For i = 0 To ReportControl.Records.Count - 1
        Set Record = ReportControl.Records.Record(i)
        dColVal = dColVal + cdbl(Record.Item(5).Value)
    Next

    ReportControl.Columns(5).FooterText = dColVal 
    ReportControl.Populate

[SOLVED] Total in Footer : Hi, If you are tryingto use...

Tue, 28 Sep 2010 13:46:39 +0000

Author: Aaron
Subject: 17343
Posted: 28 September 2010 at 1:46pm

Hi,

If you are trying to use SUM in your FooterRecords, it isn't implemented yet... Maybe in next release...