subreport does not display same as main report

[JACK GUNAWAN via AccessMonster.com]

Hi, I have a subreport on main report. The problem is that the subreport does
not display the same list as the main report. Ihave tried link child and
master but still does not 'move along' with the main. I have linked the
order id and product id as in the main report but to no avail. Any
suggestion? Thanks

Jack

 

[Guest]

Post your query SQL for the main and subforms.

 

[JACK GUNAWAN via AccessMonster.com]

My query sql is:
SELECT [Unit Printed Price].OrderID, [Unit Printed Price].OrderDate, [Unit
Printed Price].ProductID, [Unit Printed Price].ProductName, [Unit Printed
Price].Y, [Unit Printed Price].ExtendedPrice, [Unit Printed Price].QTY, [Unit
Printed Price].[Print Unit Price], [Unit Printed Price].Freight, [Unit
Printed Price].Category_ID, [Unit Printed Price].TotalPaid, [TotalPaid]-[A]
AS Return, ([SumOfExtendedPrice]-[Freight]) AS A, [Unit Printed Price].
ApotikSubFinal, [Unit Printed Price].ApotikSubFinal, [Unit Printed Price].
CHECKERID, [Unit Printed Price].Employee
FROM [Unit Printed Price] RIGHT JOIN [Total Sales Sorted Print] ON [Unit
Printed Price].OrderID = [Total Sales Sorted Print].OrderID
ORDER BY [Unit Printed Price].ProductName;
Thanks for the inquiry. I still cannot figure out the solution. I just want
the subreport to display the same list as the main report as it 'moves' along.
actualy the list of the subreport is the samne as the main report but when
the main repot moves ot second page, the subreport still display the first
page of the list. Thanks.


jack

Post your query SQL for the main and subforms.

Hi, I have a subreport on main report. The problem is that the subreport does
not display the same list as the main report. Ihave tried link child and

[quoted text clipped - 3 lines]

Jack

 

[Duane Hookom]

What do you mean by "moves along"? Are the record sources the exact same? Do
you have any values set in the Link Master Child properties of the subreport
control on the main report?

--
Duane Hookom
MS Access MVP
--

My query sql is:
SELECT [Unit Printed Price].OrderID, [Unit Printed Price].OrderDate, [Unit
Printed Price].ProductID, [Unit Printed Price].ProductName, [Unit Printed
Price].Y, [Unit Printed Price].ExtendedPrice, [Unit Printed Price].QTY,
[Unit
Printed Price].[Print Unit Price], [Unit Printed Price].Freight, [Unit
Printed Price].Category_ID, [Unit Printed Price].TotalPaid,
[TotalPaid]-[A]
AS Return, ([SumOfExtendedPrice]-[Freight]) AS A, [Unit Printed Price].
ApotikSubFinal, [Unit Printed Price].ApotikSubFinal, [Unit Printed Price].
CHECKERID, [Unit Printed Price].Employee
FROM [Unit Printed Price] RIGHT JOIN [Total Sales Sorted Print] ON [Unit
Printed Price].OrderID = [Total Sales Sorted Print].OrderID
ORDER BY [Unit Printed Price].ProductName;
Thanks for the inquiry. I still cannot figure out the solution. I just
want
the subreport to display the same list as the main report as it 'moves'
along.
actualy the list of the subreport is the samne as the main report but when
the main repot moves ot second page, the subreport still display the first
page of the list. Thanks.


jack

Post your query SQL for the main and subforms.

Hi, I have a subreport on main report. The problem is that the subreport
does
not display the same list as the main report. Ihave tried link child and

[quoted text clipped - 3 lines]

Jack

 

[JACK GUNAWAN via AccessMonster.com]

What do you mean by "moves along"? Are the record sources the exact same? Do
you have any values set in the Link Master Child properties of the subreport
control on the main report?

My query sql is:
SELECT [Unit Printed Price].OrderID, [Unit Printed Price].OrderDate, [Unit

[quoted text clipped - 28 lines]

Hi, what I mean is that the main page goes to the second page of the report
but the subreport still display the same list as the first page's subreport.
The record sources are the exact same. I have set the order id values in the
link master child properties of the subreport control on the main report. I
had tried all possible values but still produce the same things. Thanks for
the attention.


Jack

 

[JACK GUNAWAN via AccessMonster.com]

What do you mean by "moves along"? Are the record sources the exact same? Do
you have any values set in the Link Master Child properties of the subreport

[quoted text clipped - 5 lines]

Hello, can someone help me with this ms access report problem. Thanks for
the kind attention.


Jack

 

[Duane Hookom]

I still don't understand why you would ever want a subreport to display the
exact same information as the main report. Maybe if I knew why, I could help
with a solution.

--
Duane Hookom
MS Access MVP
--

What do you mean by "moves along"? Are the record sources the exact same?
Do
you have any values set in the Link Master Child properties of the
subreport

[quoted text clipped - 5 lines]

Hello, can someone help me with this ms access report problem. Thanks for
the kind attention.


Jack

 

[JACK GUNAWAN via AccessMonster.com]

I still don't understand why you would ever want a subreport to display the
exact same information as the main report. Maybe if I knew why, I could help

Actually, i am using access as pos system, i would like to print the same
report twice on the same piece of paper so that the other piece would be my
backup copy and the other to customers. If i print twice the same report,
the length of the backup report would be long as it includes customers name
and etc. I only need the items being sold as a backup copy so as to double
check if the inventory goes wrong. Thanks. I hope Duane would help.

Jack

 

[Duane Hookom]

I would not use a subreport for this. You can just print the report twice or
printout 2 copies or add a table with two records to the report's record
source query.