Hi,
I am dynamically builting a query in sql server based on the parameters from the main report and running the subreport for every item in the same groups resulting in Subreport not showing data.
But when i run the subreport seperatly with the same set of parameters but for single item in a group i get data.
I am thinking that it might be due to timeout in the report.I have change the command timout but still sub report does not return any data for 2 grouping scenarion but rest of the two sub report generates data.
Can you please help me or assit me how to fix this issue.
I am dynamically builting a query in sql server based on the parameters from the main report and running the subreport for every item in the same groups resulting in Subreport not showing data.
But when i run the subreport seperatly with the same set of parameters but for single item in a group i get data.
I am thinking that it might be due to timeout in the report.I have change the command timout but still sub report does not return any data for 2 grouping scenarion but rest of the two sub report generates data.
Can you please help me or assit me how to fix this issue.