I am a CR newbie. I'm trying to create a report that contains many subreports, which link to SQL Server 2000 stored procedures as a datasource. Some of these subreports contain data collected from two tables with a one-to-many relationship (a parent table and a corresponding update table). I need to display data from a row in the parent table in a detail section of my subreport. In the same section, I need to display all the update records for the parent record.
Since I'm using stored procedures, I do not believe I can use data shapes or data cubes. Is there another way I can solve what must be a common problem?
Any help will be most appreciated!
Since I'm using stored procedures, I do not believe I can use data shapes or data cubes. Is there another way I can solve what must be a common problem?
Any help will be most appreciated!