Linking subreport to main report problem

G

Guest

I have a main report and 3 subreports.
The main report and 2 subreports all have a field that is named the same
(OPP_ID) that links them all together.
The 3rd subreport has a field named OPPORTUNITY. I can't rename this field
in the table due to all the changes that would entail throughout the db.
Is there someway to link this field OPPORTUNITY to the other 3 named OPP_ID
within this report?
 
G

Guest

Thanks for the quick response but I don't think that solves my problem as all
the fields are the same datatype...text.
 
G

Guest

Karl is simply suggesting to use the names of the fields since they don't
have to be the same name. They do need to have the same data values in order
to link.

If you can't figure it out, you can add a column to the third subreport's
record source like
OPP_ID: OPPORTUNITY
This will create a new column with the OPPORTUNITY value but a different
name. This shouldn't be necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Subreports to create a Main Report 7
SynNeed to account for null values in subreports 2
subreport totals on Main report 3
Having problems linking Child/Master fields in Report 10
subreport/report total question 5
Subreport with no records 8
Changing subreport orientation in main report? 3
Printing Subreport data not linked to Main Report 4

Top