The main report has a DataSet which returns a number of dates from a query on Database A returning column DateA. The report consists of a Table where the first column is the DateA and a second column containing a sub-report. The Sub-report is provided with the date parameter. The sub-report itself runs a stored procedure on Database B using the date as the parameter. The sub-report itself executes as stand-alone with no errors. When this runs as a sub-report, I can see that VS hads received the data and attemps to render the output, i.e. the . At this stage, I receive the message "Microsoft Visual Studio has encountered a problem and needs to close". What should I be looking for to identify the problems?

Hi, Were there large amount of data in the main report? You can try less data, for example, use TOP N in the select list to limit n rows of data in the dataset query, in the main report to see if it works. I suspect it was caused because of too many data for render on the report. When you deploy the report, you can remove the TOP N command from the dataset query. thanks, Jerry

Hi, Were there large amount of data in the main report? You can try less data, for example, use TOP N in the select list to limit n rows of data in the dataset query, in the main report to see if it works. I suspect it was caused because of too many data for render on the report. When you deploy the report, you can remove the TOP N command from the dataset query. thanks, Jerry