Skip to Content

data conversion

Hi to all

Actual data in database

COUNTY AID CODE ACTIVE TERMINATED GRAND TOTAL Alpine 84 52 4 56 Alpine 85 6 0 6 Amador 84 657 53 710 Amador 85 74 4 78 Amador 88 15 0 15 Amador 89 3 3 6 Butte 50 25 7 32 Butte 53 6 0 6 Butte 84 5195 618 5813 Butte 85 554 89 643 Butte 88 52 3 55 Butte 89 20 6 26

convert to.....

COUNTY AID CODE ACTIVE TERMINATED GRAND TOTAL Alpine 84 52 4 56 Alpine 85 6 0 6 Total 58 4 62

Amador 84 657 53 710 Amador 85 74 4 78 Amador 88 15 0 15 Amador 89 3 3 6 Total 749 60 809

Butte 50 25 7 32 Butte 53 6 0 6 Butte 84 5195 618 5813 Butte 85 554 89 643 Butte 5252 723 6575 Butte 89 20 6 26 Total 5852 723 6575 6576

I am using 3.1

Thanks in advance

Ranjeet

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 08, 2014 at 12:13 PM

    >Apply break on country

    >enable break footer and took sum of those active, terminated and grand total columns

    Thanks,

    Bala

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.