Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: group by in data report w/o data environment

    hi im newbie here..
    im having diffuclty on how to group my records in my data report
    I've tried to use sql query but still doesn't work. i want to goup it by prodtype
    my code:


    Set rs = con.Execute("Select * from tbl3DRitems where drno='" & Combo2.Text & "'")



    ' Set rs = con.Execute("select count(prodno), count(proddesc), count(qty), count(unitprice), count(totalamt), count(prodtype) from tbl3DRitems where DRno = '" & Combo2.Text & "' group by prodtype")
    DataReport2.Sections("Section4").Controls("lblcust omer").Caption = Text4.Text
    DataReport2.Sections("Section4").Controls("lbladdr ess").Caption = txtadd.Text
    DataReport2.Sections("Section4").Controls("lbldate ").Caption = DT1.Value
    DataReport2.Sections("Section4").Controls("lblterm s").Caption = Text2.Text
    DataReport2.Sections("Section4").Controls("lblPO") .Caption = Text6.Text
    DataReport2.Sections("Section4").Controls("lblDA") .Caption = Text5.Text
    DataReport2.Sections("Section4").Controls("lblinvo no").Caption = Text1.Text

    Set DataReport2.DataSource = rs
    DataReport2.Show vbModal




    plz help.. any ideas greatly appreciated!

  2. #2
    Join Date
    Feb 2009
    Posts
    29
    Why not use Crystal Report?

  3. #3
    Join Date
    Mar 2009
    Posts
    2
    Quote Originally Posted by jerome.mercado26
    Why not use Crystal Report?

    yeah.. i think im going crazy using Data environment.. now im usind crystal report sooo easy unlike before.. thanks jerome!

  4. #4
    Join Date
    Oct 2004
    Posts
    72
    Quote Originally Posted by jerome.mercado26
    Why not use Crystal Report?
    Hi... i'm interesting to Crystal Report, but existis a free version?
    Tks.

  5. #5
    Join Date
    Feb 2009
    Posts
    29
    you mean Crystal Report 4.6?

Posting Permissions

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