Subreport not in sync with Main Report

[Pele]

I created a Subreport within a Main Report and the links
were done correctly i.e. Customer ID. I only have a Page
Header in the Main Report (i.e. no Report Header).

The problem is that, while the Main Report now shows a
separate page for each customer, the subreport list all
the records that will fill a page; instead of limiting the
list to the relevant Customer ID.

I don't know what is going on. ANy help will be
appreciated.

1) Why is the subreport only stopping after listing a
pages worth of detail. Why is it even showing all these
detail records.
2) Why isn't the subreport just limiting the list to the
pertinent Customer ID displayed in the Main Report (which
is what I want).

Pele

 

[Allen Browne]

1. Open the main report in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. On the Data tab of the Properties box, set LinkMasterFields to [Customer
ID] and LinkChildFields to the matching field in the subreport.

 

[Pele]

Allen,

As said in the initial post, the links were done correctly
and the report is still not working. Somebody had
suggested that I should create a customer ID groupheader
and that seemed to work, except that I now don't have
different customers on separate pages.


Toks

-----Original Message-----
1. Open the main report in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. On the Data tab of the Properties box, set LinkMasterFields to [Customer
ID] and LinkChildFields to the matching field in the subreport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I created a Subreport within a Main Report and the links
were done correctly i.e. Customer ID. I only have a Page
Header in the Main Report (i.e. no Report Header).

The problem is that, while the Main Report now shows a
separate page for each customer, the subreport list all
the records that will fill a page; instead of limiting the
list to the relevant Customer ID.

I don't know what is going on. ANy help will be
appreciated.

1) Why is the subreport only stopping after listing a
pages worth of detail. Why is it even showing all these
detail records.
2) Why isn't the subreport just limiting the list to the
pertinent Customer ID displayed in the Main Report (which
is what I want).

Pele

.

 

[Allen Browne]

You don't?

In report design view, right-click the grey bar over the CustomerID Header
section, and choose Properties.

On the Format tab of the properties box, you can specify that you want to
Force New Page... Before Section. That should give you a new page for each
customer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Allen,

As said in the initial post, the links were done correctly
and the report is still not working. Somebody had
suggested that I should create a customer ID groupheader
and that seemed to work, except that I now don't have
different customers on separate pages.


Toks

-----Original Message-----
1. Open the main report in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. On the Data tab of the Properties box, set LinkMasterFields to [Customer
ID] and LinkChildFields to the matching field in the subreport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I created a Subreport within a Main Report and the links
were done correctly i.e. Customer ID. I only have a Page
Header in the Main Report (i.e. no Report Header).

The problem is that, while the Main Report now shows a
separate page for each customer, the subreport list all
the records that will fill a page; instead of limiting the
list to the relevant Customer ID.

I don't know what is going on. ANy help will be
appreciated.

1) Why is the subreport only stopping after listing a
pages worth of detail. Why is it even showing all these
detail records.
2) Why isn't the subreport just limiting the list to the
pertinent Customer ID displayed in the Main Report (which
is what I want).

Pele

.