subreports with 2 keys for link

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

 

[Duane Hookom]

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.

 

[Tony]

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!

.

 

[Tony]

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





.

.

 

[Duane Hookom]

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


.

.

 

[Tony]

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


.

.

.

 

[Tony]

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

office

or


.

.

 

[Duane Hookom]

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

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

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!


.

.



.

.