Sign in
Microsoft.com
 
Microsoft
 
 
 

none
query with sum() in crystalreport RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi!

    this is the query i use to show my database table in listview

    "select item,description,price,category,date, sum(qty),sum(total) from tbl_records where  Date ='" & BunifuDatepicker1.Value.Date & "'  group by item,description,category"

    but when i use this query for the crystal report the column for qty and total is empty. what will i do ? can anyone please help me.

    thankyou!


    • Edited by euchan09 Tuesday, September 4, 2018 7:09 AM
    • Moved by Alex Li-MSFT Wednesday, September 5, 2018 1:02 AM
    Tuesday, September 4, 2018 7:05 AM
    |

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    According to your description, your issue is more related about crystal. And this forum is discussing and asking questions about the vb.net.
    Thank you for your understanding.
    Thank you for participating in the forum activities.

    Best Regards,

    Alex

    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, September 4, 2018 8:13 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    ok im so sorry.
    Thursday, September 6, 2018 3:48 AM
    |