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
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