locked
Won't see duplicated rows. RRS feed

  • Question

  • Hello,

    Due to my silly designing for the database.
    I get many rows that like


    Type          Amount       Total
    Cash           200            2000
    Cash           250            2000
    Cash           200            2000
    Cash           150            2000
    Cash           200            2000
    Cash          1000           2000


    What I want to show on the report is


    Type          Amount       
    Cash           200            
    Cash           250            
    Cash           200            
    Cash           150            
    Cash           200            
    Cash          1000        


    Total          2000   


    Can you please how to do that?


    Thanks
    Friday, December 5, 2008 8:09 PM

All replies

  • Let me restate my question.

    In my rdlc report there is a table from a stored procedure.
    Type    Amount Total
    Cash 200 2000
    Cash 250 2000
    Cash 200 2000
    Cash 150 2000
    Cash 200 2000
    Cash 1000 2000
    Credit 50 600
    Credit 150 600
    Credit 400 600

    This table is designed silly because of the third column.
    To hide it, now I am going to diaplay the total values in another table.
    It should be
    Type     Total 
    Cash 2000
    Credit 600

    I guess the function of sum(Fields!xx.Value) may be used but I don't know it exactly.
    By grouping?
    Would you please tell me a wise way?

    Thanks
    Saturday, December 6, 2008 3:34 AM
  • Hi
       Yes. Grouping is the solution here. If you are using table to present data you must go to table properties, next to 'Groups' tab and after you add a group you must set an expression in 'group on' part (for example '=Fields!Type.Value'). In disigner you must use any kind of agregation function like sum or avg.

    everything is a matter of probability...
    Sunday, December 7, 2008 10:10 AM
  •  Well, I used sum function. What I got is
    Cash 2000 
    Cash 2000
    Cash 2000
    Cash 2000
    Cash 2000
    Cash 2000

    They are duplicated. I only want to show one row.







    Monday, December 8, 2008 2:34 PM
  • Have you set grouping in your table (or matrix) and use agregation function? If so can you post your data schema and write exacly what data you use as data source and what you want to see on report?

    everything is a matter of probability...
    Monday, December 8, 2008 10:08 PM