Page Numbering in Subreports

[Tamiyra]

Hi,

If anyone can help, i would appreciate it.

This is kinda hard to explain so please bare with me. Ok my main report is set up as follows:
pageHeader
subreport1
conditional pagebreak...
subreport2
subreport3
subreport4
PageFooter

Basically each subreport is its own complete report and the main report is used only to merge the reports into one report package. The problem I am having is that I want the page numbers on the subreports to carry over and be the same as they were when the subreports were standalone reports (Indivdual Page numbers for each subreport). But when i run the main report, the page numbers all appear as zero.. I have tried making my own counters in replace of the [page] report variable, and that works when the subreport is run, but when the report is called from main report it doesn't work properly. It is like the code on the subform is ran in a totally different way if it is viewed by itself or from a master form. I have tried just resetting the [page] variable with code and with a macro also but still it displays 0. Is there a way around this, if anybody can understand what I am trying do...


Any suggestions would be extremley helpful......Cause i have spent 2 days on this now and have no clue how to accomplish this....

 

[Lee Chai Ling]

Display message in report

I have a report which show orders details by state. Let's say there are 3 states: A,B,C. I do the report separately and combine them using subreport.
If there is no order for state B, the report will show "No order for state B".Can anyone help me? Thanks!

 

[Tamiyra]

I have a report which show orders details by state. Let's say there are 3 states: A,B,C. I do the report separately and combine them using subreport.
If there is no order for state B, the report will show "No order for state B".Can anyone help me? Thanks!

you can make a textbox or a label and place it under the subreport box
Then on the OnFormat command for that section of your report, you could try entering the follow code or similar code


if rptB.hasdata then
txtNoDataBMsg.visible = false
else
txtNoDataBMsg.visible = true
end if


This wil show the textbox when there is no data in rptB.


Hope this helps