Hi All,

I have a report which got many parameters but the main one is company parameter. Today the guy from finance come over and asked me can I print all the entities at once now I have to select one entity click view and the print it and so for all the rest.

Now my question is: there is away that i can allow to select the all company at once the report need to duplicate for every company independently. The report is made up of 5 tables with different scope but all using the same company parameter.

Thanks

Regards

Federico 

Hi Federico,

You can use multi-select parameter option in SSRS to show all the results in one report instead of creating separate o/p for each parameter.

Try this below link which explains step by step guide to create multi-select parameter in SSRS:

https://technet.microsoft.com/en-us/library/aa337396%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396

https://social.technet.microsoft.com/Forums/sqlserver/en-US/0ead7ceb-3fdd-4625-aa82-1d4195f984b1/passing-multivalue-parameter-in-stored-procedure-ssrs?forum=sqlreportingservices

https://www.mssqltips.com/sqlservertip/2844/working-with-multiselect-parameters-for-ssrs-reports/