Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
crystal report detail RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    The issue might sound familiar, but i haven't been able to resolve
    this problem despite finding some related posts in this area.

    This is how the data model looks like
     
    product   qty    tbl1
     
          0     10
          0     11
          0     12
          1     13
          1     14
          1     15
          2     16
          2     17
          2     18

    product   qty   tbl2
          0    33
          1    42
          2    51

    in my dataset look like tbl1 how can i make it to tbl2 on crystal report
    details part

    • Moved by Youjun Tang Monday, September 14, 2015 6:20 AM third-party
    Thursday, September 3, 2015 1:33 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    This is a data issue, how you pulling your data for the report is it via SQL or linq or...?, in both cases you need grouping by the Product column and then sum on the Qty column.

    I think CR has a grouping functionality also, you can post your question on their official forum for a further suggestions.

    Fouad Roumieh

    • Proposed as answer by Xavier Xie-MSFT Monday, September 14, 2015 6:19 AM
    • Marked as answer by Just Karl Wednesday, September 23, 2015 10:55 PM
    Thursday, September 3, 2015 6:10 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote 
    Dim q = From p In tbl1
            Group p By transactionTypeName = p(0) _
            Into totalForType = Sum(Convert.ToDouble(p(1))) _
            Select transactionTypeName, totalForType

        Dim tbl2 As DataTable = tbl1.Clone
        For Each item In q            
            tbl2.Rows.Add(New Object() {item.transactionTypeName, item.totalForType})
        Next
    then set your crystal reports document's data source to tbl2
    Thursday, September 3, 2015 3:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    sorry i really can understand

    coz now mydataset is like tbl1 and i wan to show in crystal report details part

    like tbl 2

    Thursday, September 3, 2015 6:06 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    This is a data issue, how you pulling your data for the report is it via SQL or linq or...?, in both cases you need grouping by the Product column and then sum on the Qty column.

    I think CR has a grouping functionality also, you can post your question on their official forum for a further suggestions.

    Fouad Roumieh

    • Proposed as answer by Xavier Xie-MSFT Monday, September 14, 2015 6:19 AM
    • Marked as answer by Just Karl Wednesday, September 23, 2015 10:55 PM
    Thursday, September 3, 2015 6:10 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    sorry i really can understand

    coz now mydataset is like tbl1 and i wan to show in crystal report details part

    like tbl 2

    Crystal Reports are third party software. If you decide to go to SAP's website for assistance with their software make sure you select a Forum regarding using Crystal Reports with Visual Studio and provid which version of Crystal Reports you are using and which version and year of Visual Studio you are using.

    La vida loca

    Thursday, September 3, 2015 9:39 AM