Results 1 to 2 of 2

Thread: Beginner

  1. May 10th, 2008, 04:53 AM #1
    sangeeramesh
    sangeeramesh is offline

    Thread Starter
    Junior Member
    Join Date
    Nov 2007
    Posts
    30

    Cool Beginner

    hi i am displaying crystal report using stroed procedure.my stroed procedure returns following records


    ID Lang City
    123 test aaa
    123 abc aaa
    123 tap aaa

    so in the report record displays 3 times

    instead i want to display like this


    123 test,abc,tap aaa

    how to do this?
    Reply With Quote Reply With Quote
  2. May 12th, 2008, 12:06 AM #2
    VBFnewcomer
    VBFnewcomer is offline
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Beginner

    how about using grouping on ID and using some formula to retrieve all related records
    THANK YOU FOR RECOGNIZING MY CONTRIBUTION AND RATING ME!

    Working Environment
    Version: VB6
    OS: ME/XP

    Office Applications: FAQs By RobDog888 * Great Excel tutorial by si_the_geek * VB6 Errors by Si * VB6 Controls: MSFlexgrid populate by si * RichText Box Tips & Tricks * Crystal Report: Multi column Report CR9 & 11 * CR9 & 11 Group Totals * ADO related: ADO further steps * ADO Tutorial by Dee-u * DB related: SQL Reserved Words * More Reserved Words * Diff ways to Insert Records into a DB * Pictures in Database * VB6 Controls: MSFlexgrid populate by si * RichText Box Tips & Tricks * Crystal Report: Multi column Report CR9 & 11 * CR9 & 11 Group Totals * ADO related: ADO further steps * ADO Tutorial by Dee-u * DB related: SQL Reserved Words * More Reserved Words * Diff ways to Insert Records into a DB * Pictures in Database
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width