Lookup for multiple datasets of single column name contains different set of values

Question

Hi all,

Lookup is working fine , My requirement is :

I need to get AT and Month in ssrs table , i got this done by look up ., but only 10th month value is repeating for 11th month . i want to get like this below mentioned like

thanks .................

AT	Month
295	10
308	11
6	10
6	11
5	11
18	10
7	11
10	10
13	10
17	11

but am getting like

295	10
295	11
6	10
6	11
5	11
5	10
18	11
18	10
13	10
13	11

ID	Type	Class	AT	Month
DC	Monthly	B	295	10
DC	Monthly	B	308	11
DC	Monthly	C	6	10
DC	Monthly	C	6	11
DC	Monthly	L	5	11
DC	Monthly	L	18	10
DC	Monthly	T 2	7	11
DC	Monthly	T 2	10	10
DC	Monthly	T 3/4	13	10
DC	Monthly	T 3/4	17	11

Answer 1

Is this possible ???????

Answer 2

You describe what you want and what you get. You do not describe how you get what you get. What you have gotten looks like an unrestricted join. I would suspect you have

AT   Month

308  10

308  11

Somewhere in the results. You need to find the Query that looks something like this

SELECT <some columns>

FROM table1, table2

And add after table1, table2

WHERE table1.Month = table2.Month.

If there is already a where clause there put replace the word "WHERE" with "WHERE table1.Month = table2.Month AND".

---

If you're happy and you know it vote and mark.

Answer 3

Please post your sample data and lookup statement.

---

Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

Answer 4

Hi all,

Thanks for all reply ., I have been using lookup ,The thing i came to know if we use lookup for getting same fields, it will return only the first occuring , so in aggregate i could not solve . But now i made in single query by using joins and in where conditions i matched all the pks and fks..

Thanks :)

Answer 5

LookupSet retrieves a set of values for a single key value and MultiLookup retrieves a set of values for a set of keys.

---

Please Mark posts as answers or helpful so that others can more easily find the answers they seek.