compare two datasets in ssrs

Question

compare two datasets in ssrs

mpradeep23

SSCommitted

Points: 1868
More actions
March 27, 2014 at 1:18 am

#289827

Hi
i have two datasets which same columns and simlar data few are mismatch.
i want the difference between those two datasets in ssrs
thanks in advance,
pradeep

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

That's great. What is the problem?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

mpradeep23 SSCommitted Points: 1868 More actions · Answer 2

mpradeep23

SSCommitted

Points: 1868

March 27, 2014 at 2:46 am

#1700584

How to compare bewteen datasets in ssrs

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

mpradeep23 (3/27/2014)
How to compare bewteen datasets in ssrs

I believe a SQL query will be more suited to find the differences.

SSRS can show the results though.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

Refer following link:

http://stackoverflow.com/questions/2077807/sql-query-to-return-differences-between-two-tables

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

mpradeep23 SSCommitted Points: 1868 More actions · Answer 5

i have two dataset from two different database servers

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

mpradeep23 (3/27/2014)
i have two dataset from two different database servers

Either use linked servers, or move on dataset to another server.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

mpradeep23 SSCommitted Points: 1868 More actions · Answer 7

mpradeep23

SSCommitted

Points: 1868

March 27, 2014 at 6:38 am

#1700650

i want to do in ssrs report only

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

mpradeep23 (3/27/2014)
i want to do in ssrs report only

Good luck with that. SSRS is not made to do such kind of things.

You'll have to use two seperate data sets to pull in the data, and the only way to access one dataset from another is to use the LOOKUP function.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

doug.brown SSCertifiable Points: 5607 More actions · Answer 9

You could perhaps try using ReportItems. Have Table A with the results form dataset 1, and Table B with the results from dataset 2. These two tables could have their visibility set to false. Then create a third table, with an expression something like:

=ReportItems!Textbox1.Value - ReportItems!Textbox2.Value

Where Textbox1 is the value field in Table A and Textbox2 is the value field from Table B.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 10

doug.brown (3/27/2014)
You could perhaps try using ReportItems. Have Table A with the results form dataset 1, and Table B with the results from dataset 2. These two tables could have their visibility set to false. Then create a third table, with an expression something like:
=ReportItems!Textbox1.Value - ReportItems!Textbox2.Value
Where Textbox1 is the value field in Table A and Textbox2 is the value field from Table B.

Although technically correct, this seems like the most inefficient way to compare data sets 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

webrunner SSC-Dedicated Points: 31863 More actions · Answer 11

I think the advice about using queries makes the most sense.

But look at this to synchronize reports if needed.

http://basitaalishan.com/2013/04/02/sql-server-reporiting-services-migrating-ssrs-reports-data-sources-and-subscriptions-from-one-server-to-another/

Good luck.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html