subreports with 2 keys for link

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi... hope someone has come across this before!
I have a report of sales offices with some high level info
and need to have a subreport of salesrep detail (varies
per office). No problem creating both report and
subreport.
Huge problem getting the subreport to work within the
report. There are two key fields (office_name and
quarter) and both are character fields. Since both
reports have the same data source, the fields are
identical.
When I set up the Master and Child link in the Properties
box with both fields (office_name;quarter), the subreport
does not work. If I choose either of the two fields to
link, the subreport works, however the data relationship
is not correct (many quarters of data to one office or
vice versa).
I am using Access 2000 against SQL Server 2000. I have
tried writing the reports against views and against stored
procedures. Both give the same bad results. I have
checked the MS knowledge base and cannot find any known
bugs.
HELP !! This is driving me nuts!
Thanks in advance!
 
Placing multiple fields should work as long as the data types are the same.
Try delimiting them with a comma and place []s around the field names.
 
Hi Duane,
Thanks for the idea, but I have already tried this. Even
with the supposed wizard doing the connections, this fails.
I am wondering if there is some kind of unreported bug
when linking with multiple fields.
Still stuck, still stumped!

-----Original Message-----
Placing multiple fields should work as long as the data types are the same.
Try delimiting them with a comma and place []s around the field names.

--
Duane Hookom
MS Access MVP


Tony said:
Hi... hope someone has come across this before!
I have a report of sales offices with some high level info
and need to have a subreport of salesrep detail (varies
per office). No problem creating both report and
subreport.
Huge problem getting the subreport to work within the
report. There are two key fields (office_name and
quarter) and both are character fields. Since both
reports have the same data source, the fields are
identical.
When I set up the Master and Child link in the Properties
box with both fields (office_name;quarter), the subreport
does not work. If I choose either of the two fields to
link, the subreport works, however the data relationship
is not correct (many quarters of data to one office or
vice versa).
I am using Access 2000 against SQL Server 2000. I have
tried writing the reports against views and against stored
procedures. Both give the same bad results. I have
checked the MS knowledge base and cannot find any known
bugs.
HELP !! This is driving me nuts!
Thanks in advance!
Click to expand...


.
Click to expand...
 
By the way, I have now tried concatenating the two alpha
fields into one in the source for the report and the
subreport. Now I DO get a visible subreport, but instead
of connecting to specific groups of data on each page (for
each person), I get all data in the subreport on every
page, as if the linking were not working at all!!!
HELP!!
-----Original Message-----
Hi Duane,
Thanks for the idea, but I have already tried this. Even
with the supposed wizard doing the connections, this fails.
I am wondering if there is some kind of unreported bug
when linking with multiple fields.
Still stuck, still stumped!

-----Original Message-----
Placing multiple fields should work as long as the data types are the same.
Try delimiting them with a comma and place []s around
Click to expand...
the
field names.
--
Duane Hookom
MS Access MVP





.
Click to expand...
.
Click to expand...
 
Setting up these properties with several fields has always worked for me.
Are you running code that changes the values?

--
Duane Hookom
MS Access MVP


Tony said:
By the way, I have now tried concatenating the two alpha
fields into one in the source for the report and the
subreport. Now I DO get a visible subreport, but instead
of connecting to specific groups of data on each page (for
each person), I get all data in the subreport on every
page, as if the linking were not working at all!!!
HELP!!
-----Original Message-----
Hi Duane,
Thanks for the idea, but I have already tried this. Even
with the supposed wizard doing the connections, this fails.
I am wondering if there is some kind of unreported bug
when linking with multiple fields.
Still stuck, still stumped!

-----Original Message-----
Placing multiple fields should work as long as the data types are the same.
Try delimiting them with a comma and place []s around
Click to expand...
the
field names.
--
Duane Hookom
MS Access MVP


Hi... hope someone has come across this before!
I have a report of sales offices with some high level info
and need to have a subreport of salesrep detail (varies
per office). No problem creating both report and
subreport.
Huge problem getting the subreport to work within the
report. There are two key fields (office_name and
quarter) and both are character fields. Since both
reports have the same data source, the fields are
identical.
When I set up the Master and Child link in the Properties
box with both fields (office_name;quarter), the subreport
does not work. If I choose either of the two fields to
link, the subreport works, however the data relationship
is not correct (many quarters of data to one office or
vice versa).
I am using Access 2000 against SQL Server 2000. I have
tried writing the reports against views and against stored
procedures. Both give the same bad results. I have
checked the MS knowledge base and cannot find any known
bugs.
HELP !! This is driving me nuts!
Thanks in advance!


.
Click to expand...
.
Click to expand...
Click to expand...
 
Duane,
The only thing that I am doing dynamically is prompting
for the Quarter (one of the two linking fields). Do you
think this might be the issue??
Thanks!
-----Original Message-----
Setting up these properties with several fields has always worked for me.
Are you running code that changes the values?

--
Duane Hookom
MS Access MVP


Tony said:
By the way, I have now tried concatenating the two alpha
fields into one in the source for the report and the
subreport. Now I DO get a visible subreport, but instead
of connecting to specific groups of data on each page (for
each person), I get all data in the subreport on every
page, as if the linking were not working at all!!!
HELP!!
-----Original Message-----
Hi Duane,
Thanks for the idea, but I have already tried this. Even
with the supposed wizard doing the connections, this fails.
I am wondering if there is some kind of unreported bug
when linking with multiple fields.
Still stuck, still stumped!


-----Original Message-----
Placing multiple fields should work as long as the data
types are the same.
Try delimiting them with a comma and place []s around the
field names.

--
Duane Hookom
MS Access MVP


Hi... hope someone has come across this before!
I have a report of sales offices with some high level
info
and need to have a subreport of salesrep detail (varies
per office). No problem creating both report and
subreport.
Huge problem getting the subreport to work within the
report. There are two key fields (office_name and
quarter) and both are character fields. Since both
reports have the same data source, the fields are
identical.
When I set up the Master and Child link in the
Properties
box with both fields (office_name;quarter), the
subreport
does not work. If I choose either of the two fields to
link, the subreport works, however the data relationship
is not correct (many quarters of data to one office or
vice versa).
I am using Access 2000 against SQL Server 2000. I have
tried writing the reports against views and against
stored
procedures. Both give the same bad results. I have
checked the MS knowledge base and cannot find any known
bugs.
HELP !! This is driving me nuts!
Thanks in advance!


.

.
Click to expand...
Click to expand...


.
Click to expand...
 
I have tried the same report by eliminating the prompt and
hard-coding the date in question into the source views and
I still am getting junk report pages, even though now I am
only linking on one column!!!!
I am starting to think that there is something strange
with Access 2000 or the SQL Server
connection/environment.
-----Original Message-----
Duane,
The only thing that I am doing dynamically is prompting
for the Quarter (one of the two linking fields). Do you
think this might be the issue??
Thanks!
-----Original Message-----
Setting up these properties with several fields has always worked for me.
Are you running code that changes the values?

--
Duane Hookom
MS Access MVP


Tony said:
By the way, I have now tried concatenating the two alpha
fields into one in the source for the report and the
subreport. Now I DO get a visible subreport, but instead
of connecting to specific groups of data on each page (for
each person), I get all data in the subreport on every
page, as if the linking were not working at all!!!
HELP!!

-----Original Message-----
Hi Duane,
Thanks for the idea, but I have already tried this. Even
with the supposed wizard doing the connections, this
fails.
I am wondering if there is some kind of unreported bug
when linking with multiple fields.
Still stuck, still stumped!


-----Original Message-----
Placing multiple fields should work as long as the data
types are the same.
Try delimiting them with a comma and place []s around
the
field names.

--
Duane Hookom
MS Access MVP


Hi... hope someone has come across this before!
I have a report of sales offices with some high level
info
and need to have a subreport of salesrep detail (varies
per office). No problem creating both report and
subreport.
Huge problem getting the subreport to work within the
report. There are two key fields (office_name and
quarter) and both are character fields. Since both
reports have the same data source, the fields are
identical.
When I set up the Master and Child link in the
Properties
box with both fields (office_name;quarter), the
subreport
does not work. If I choose either of the two fields to
link, the subreport works, however the data
relationship
is not correct (many quarters of data to one
Click to expand...
Click to expand...
office
or


.
Click to expand...
.
Click to expand...
 
Quarter isn't a date field is it? I have seen some issues with 'latency' in
reports. Try copy your SQL Server table to Access and run the report to see
if fixes the issue.

--
Duane Hookom
MS Access MVP


Tony said:
I have tried the same report by eliminating the prompt and
hard-coding the date in question into the source views and
I still am getting junk report pages, even though now I am
only linking on one column!!!!
I am starting to think that there is something strange
with Access 2000 or the SQL Server
connection/environment.
-----Original Message-----
Duane,
The only thing that I am doing dynamically is prompting
for the Quarter (one of the two linking fields). Do you
think this might be the issue??
Thanks!
-----Original Message-----
Setting up these properties with several fields has always worked for me.
Are you running code that changes the values?

--
Duane Hookom
MS Access MVP


By the way, I have now tried concatenating the two alpha
fields into one in the source for the report and the
subreport. Now I DO get a visible subreport, but instead
of connecting to specific groups of data on each page (for
each person), I get all data in the subreport on every
page, as if the linking were not working at all!!!
HELP!!

-----Original Message-----
Hi Duane,
Thanks for the idea, but I have already tried this. Even
with the supposed wizard doing the connections, this
fails.
I am wondering if there is some kind of unreported bug
when linking with multiple fields.
Still stuck, still stumped!


-----Original Message-----
Placing multiple fields should work as long as the data
types are the same.
Try delimiting them with a comma and place []s around
the
field names.

--
Duane Hookom
MS Access MVP


Hi... hope someone has come across this before!
I have a report of sales offices with some high level
info
and need to have a subreport of salesrep detail (varies
per office). No problem creating both report and
subreport.
Huge problem getting the subreport to work within the
report. There are two key fields (office_name and
quarter) and both are character fields. Since both
reports have the same data source, the fields are
identical.
When I set up the Master and Child link in the
Properties
box with both fields (office_name;quarter), the
subreport
does not work. If I choose either of the two fields to
link, the subreport works, however the data
relationship
is not correct (many quarters of data to one
Click to expand...
office
or
vice versa).
I am using Access 2000 against SQL Server 2000. I have
tried writing the reports against views and against
stored
procedures. Both give the same bad results. I have
checked the MS knowledge base and cannot find any known
bugs.
HELP !! This is driving me nuts!
Thanks in advance!


.

.



.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top