I have a situation where I have one main report and about 20 sub reports. The main report has 4 tables. All but two of the subreports use staright tables to access data. The two reports in question are big reports with a lot of data and calculations that I decided to do within Stored Procedures (MSSQL 2000). The SPs work great and the reports run fine when outside of the main report. However, when I insert, link and run the report but the sub reports come up empty.
I am linking them using the fields within the table from the main report linked to the Parameters within the sub reports. I had this working about an hours ago, but I did something that completely ruined my day and now it isn't working.
I am linking them using the fields within the table from the main report linked to the Parameters within the sub reports. I had this working about an hours ago, but I did something that completely ruined my day and now it isn't working.