Hi, Is this possible to have single sub report in main report and the report name of the sub report should be dynamically passed based on the parameter selection in main report. Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Hi, It will not. Reason is that the moment you map the subReport name, you need to pass the required list of parameters from main report to subreport and in case of dynamic subreport, handling of passing parameters from main report to subreport will be hard. Aftab Ansari

Hi, Sub report cannot be called dynamically. We have to specify the name of the sub report. But I think we can try a work around for this. Create a table in database where we can have all possible paramters Values and URL( of all your 100 sub reports) as the columns. Create a report, drag a table and delete header. Keep only one text box in that table. Fetch the values of above mentioned table values as per the parameters condition in where condition into a dataset in the RDL. assign the dataset to this table and click on the texbox properties -> go to Actions -> select GO TO URL -> Select the field ( from the dataset) which has that URL value Call this report as sub report in your main report. In turn this sub report will call the actual report and rendered in your main report. Regards, Bharadwaj Sastry.