hi i am having 2 datasets in SSRS reports.. so in that matrix format i create a report.. in that row group i gave state wise group..so in that 1st colmn i gave count(Fields!CUSTOMER_ID.Value, "DataSet1") 2nd column i gave count(Fields!CUSTOMER_ID.Value, "DataSet2") but 1st columns coming correct count value corresponding to that state but 2 column is not coming correct its gave same value for all the state how to get value for corresponding data for state

A matrix and a table can be associated with only one DataSet, in your case DataSet1. The second dataset is always showing you the total, count for all the row in your dataset and doesn't apply a grouping. The workaround is: To use subreports, orTo join the datasets into one.

To join the datasets into one. how to join 2 dataset into one..1st dataset will give current month value..2nd dataset will give previous month value..how can i join this two.. i used lookup function also..if i use lookup no value will come on that 2nd column

Hi There Can you please share your expression for lookup function as I think it should work, what parameter you are passing to your lookup function Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi, Based on your scenario, you can rewrite the query of DataSet2 to return the count of CUSTOMER_ID values in each state. Then, you can join the two datasets on the CUSTOMER_ID column or use the Lookup function in the expression. The query may looks like: SELECT state, COUNT(CUSTOMER_ID) AS CCID FROM (SELECT TOP (100) PERCENT s.state, c.CUSTOMER_ID FROM ) AS tab_1 GROUP BY state ORDER BY state For more information about join two dataset and the Lookup function, please see: Using Inner JoinsLookup Function Hope this helps. Regards, Mike Yin