grouping on expression

  • hi

    i have created 1 group in my report.now i want sorting on differen field.

    example,

    account date month

    u1 12/31/2010 3.4

    u1 12/31/2009

    u1 09/30/2010

    u2 08/31/2010 7.6

    u2 06/31/2010

    here i have create group on account,now i want to short by month,so if i choose month in drop down

    data should be

    u2 08/31/2010 7.6

    u2 06/31/2010

    u1 12/31/2010 3.4

    u1 12/31/2009

    u1 09/30/2010

    but it showing me same data,how to do this?

  • riya_dave (5/31/2012)


    hi

    i have created 1 group in my report.now i want sorting on differen field.

    example,

    account date month

    u1 12/31/2010 3.4

    u1 12/31/2009

    u1 09/30/2010

    u2 08/31/2010 7.6

    u2 06/31/2010

    here i have create group on account,now i want to short by month,so if i choose month in drop down

    data should be

    u2 08/31/2010 7.6

    u2 06/31/2010

    u1 12/31/2010 3.4

    u1 12/31/2009

    u1 09/30/2010

    but it showing me same data,how to do this?

    OK lets keep this simple:

    1) what are the columns you want to :

    a) group by

    b) order by

    2) why have only two of the rows got month values (7.6 and 3.4)? If the rows with NULL are to be included which order should they appear in?

    Please give the answers to the questions above and a description of the fields you have available and data types of those.

    Fitz

  • hey mark thanks,

    i got solved,i need to create group and then in group properties ->sorting

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

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