Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeating records on a subreport

Status
Not open for further replies.

selvirino

Programmer
Jun 18, 2001
17
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top