How to bind Master and sub report dynamically in c# (ASP.NET) -

i have done crystal report master , sub report through odbc connection(directly connecting database using sql query). report has around 400 pages , takes 15 mins local when have deployed in server taking hour complete. how increase performance here ?

i following different approach overcome above issue using ado.net data source(stored procedure programmatic) using typed data set. here master report have bound data source stored procedure how can bind sub report pragmatically ?

each sub report need parameter master report. have 1 master , sub report, both reports needs bind based on data. please me out bind master , sub report using c# code using stored procedure.

it's difficult sure if you've got stored procedure main report you're best off incorporating data/functionality of sub report same stored proc. calling sub report each row in big report slow part of report in first place, it's inefficient.