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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subreport help

Status
Not open for further replies.

dnador

Technical User
Joined
Jun 8, 2002
Messages
5
Location
US
I need to creat a report like below. I think that the
SourceObjects table would be the source of the main
report while the 3 sections below would be subreports.
The thing is I don't know how to set this up and connect
the subreports to the main. I got a start, but can't get
the subreport labels to show up. I also need to have the
subreports sort of shrink and grow according to the
amount of data in them. Some objects may have no internal
procedures for instance and I don't want that section to
show up and take up space in that case. Same with the
other subreports.
Can anyone point me in the right direction?
I appreciate your time,
Dave


ReportHeader
ObjectType

ObjectName Comments
------------------------------------------------
|--ReferencedTable Sel Ins Upd Del Cre |
|----------------------------------------------|
| TableName x x x x x |
| TableName x x x x x |
| TableName x x x x x |
| TableName x x x x x |
|----------------------------------------------|
|--InternalProcedures |
|----------------------------------------------|
| ProcedureName |
| FunctionName |
|----------------------------------------------|
|--ObjectsReferenced | ReferencedObjects |
|----------------------------------------------|
| PackageName | PackageName |
| ProcedureName | ProcedureName |
| FunctionName | FunctionName |
------------------------------------------------
ReportFooter


Table Name Columns
----------------------------------------------
SourceObjects - ObjectType,
ObjectName,
Comments
SourceCrud - TableName,
Sel,
Ins,
Upd,
Del,
Cre
ObjectDependancies - ObjectName,
ObjectType,
ReferencedObjectName,
ReferencedObjectType
ObjectProcedures - ObjectName,
ProcedureName

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top