Hi,

I just created a report having a parameter e.g. Product, it has around a total of 45 products. But when I go to select the product from the drop-down menu I find that there are only around 26 products listed below and the remaining are not visible at all. I have created a command and have used Inner join to link 3 tables. I tried really very hard to find the reason of what is the problem but was unsuccessful. Can anyone please give their thoughts or ideas.

Thanks.

see if your inner joins have narrowed down your selection. are the 45 products in 1 table or 2 or 3

am I linking the right stuff together? question to ask yourself when working on it.