Post reply

Page wise total of records by gouping on a column

  • May 12, 2010 at 12:06 am

    #386909

    Hi All,

    I am having a requirement in one report. Please provide your valuable suggestions and help me out in this.

    There is a report having 10 columns in which on running the report it fetches >1000 records. There is a sum column at the end of page by grouping o a column.

    for example: take a look in the following column structure

    City FirstName LastName Address Number of Assets

    there may be n number of city names, and at last there is sum of "Number of Assets" for each corresponding city. I applied sum in the footer , but the problem is in each page the number of records displaying is 30 (Total pages = (n records/30) pages) , at the end in the sum row , for each page it is displaying the sum of all the n records in each page . but my requirement is to dispaly the sum for each page individually group on city column.

    Thanks in Advance,

    Venu Gopal.K
    Software Engineer
    INDIA

  • May 17, 2010 at 5:32 am

    #1168191

    Hi

    Are you using the scope of the SUM(NumOfAssets.value, "City" ) or just the plain old SUM(NumOfAssets.value)?

    If the value of the field is already calculated (for instance a sum on the number of assets in the City grouping), and is being shown in the table, then you might be able to reference it by using the ReportItems!FieldName.value as part of the expression in the header/footer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply