I'm having what I'm hoping will be a simple issue -
My co-worker has created a large report which contains several tables in SSRS 2008. Each table is tied to one dataset, yet only certain data can be returned to each respective table. Right now he's applying filters at the table-level behind each table, however as you can imagine this is not efficient because there is a LOT of data returning for this report.
I'll try and give a simplified example -
There are two tables in the report body - one for containing products relating to both Cats and Dogs, and one for containing products relating to Birds. Each product starts with the name of the specific animal - for example "Cats-Mouse Toy", "Dogs-Frisbee", "Birds-Rubber_Leaf".
Now I need to somehow filter out each product so that they go to their proper tables. As mentioned above, my co-worker was creating a specific filter for each product, but this is proving to be inefficient. For example, there are 52 different products for Birds alone. That would mean 52 different filter entries for each product. What I would like to do is use the LIKE operator but i'm not getting the results I want on the first table.
So, on the first table I need something like: =(Fields!Products.value LIKE &
View Complete Post