Post reply

Problem with Groupby

  • October 17, 2008 at 9:50 am

    #194738

    hi

    i create a groupby on one of my columns (vendorid).

    it gives me output as

    vendoid invoiceid invoicedate

    1

    2 somedate

    1

    3 somedate

    2

    4 somedate

    2

    5 somedate

    but..............

    i want my out put like

    vendoid invoiceid invoicedate

    1

    2 somedate

    3 somedate

    2

    4 somedate

    5 somedate

    I want my vendoid displayed only once not twice. How can i do that?

    Hope you understand my question

    Please help me

    I am learner.I recently stared reports

  • October 17, 2008 at 10:00 am

    #886477

    That's a display issue, not a data issue. That kind of thing should be done in your application/report, not in the database.

    You can set the grouping levels in the report to display the data like that. Play with adding more headers to the default grid in the report.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 17, 2008 at 10:01 am

    #886480

    yea gila

    my questions was wrong sorry guys

    Thanks for your patience

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

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