Two Dataset without joining them in SSRS

Question

I have two Datasets in my SSRS report and both dataset coming from different database. and there impossible to join them

Example not real Data ..... so what im tring to do is (Dataset1) total number of Visiter divided by (Dataset2) Total number of Cars * 1000 (sectors) row group by every month and Year.

for example (not real) if we have 24 Visitors and 2063 Cars *1000 so we get AVG of 1000 Sectors 11.63

Is there any funcation in SSRS where i solve this problem IN Excel you know i easy but I need to create report in SSRS please any help would safe me. Thanks

enter image description here

Answer 1

The lookup function in SSRS allows you to get fields from a different dataset based on matching criteria.

See here for more information: https://msdn.microsoft.com/en-GB/library/ee210531.aspx