Forum Discussion
No data Available for Selected Parameters In Paginated Reports
I have a Scenario on Paginated Report (SSRS Reports), I Have developed a Report where i have Product Name Parameter. This Parameter is Text Parameter, Where I can type in the values for Product Name ...
For this, it is all depends on how you bringing back your data in the resultset/dataset. I'm assuming, when people enter 3 products in the parameter, you must somehow knows how to separate them, probably using comma separated, or semi-colon, or whatever, that way you know how to parse that and know it is 3 products that were entered and not just one. Normally, if the product list is not that many, you may want to show the list of products available and make that parameter as multi-value/multi-select parameter.
Anyhow, in the main query, after you already parse that 3 products into its own column and row (store it in temp table or something). Then, you want to start your query with something like this:
select t1.product_name, t2.*
from #product_list t1
left join (select .... do you subquery here) t2 on t2.product_name = t1.product_name
This way, your query will always bring back 3 rows (again, idk what or like how many rows will your subquery bring back). If there is no product from your sub query, it will still have that missing product in your resultset with null values on the t2 subquery. Then, when you do paginate and group it by product, that missing product will still create a new tab.
Good luck
Anyhow, in the main query, after you already parse that 3 products into its own column and row (store it in temp table or something). Then, you want to start your query with something like this:
select t1.product_name, t2.*
from #product_list t1
left join (select .... do you subquery here) t2 on t2.product_name = t1.product_name
This way, your query will always bring back 3 rows (again, idk what or like how many rows will your subquery bring back). If there is no product from your sub query, it will still have that missing product in your resultset with null values on the t2 subquery. Then, when you do paginate and group it by product, that missing product will still create a new tab.
Good luck