Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieving pagenumber from one report1 into the second report

Status
Not open for further replies.

varunms

Programmer
Jul 15, 2002
5
US
Hi There,
I have posted this questions in Several forms but i didn't get any responses. Is there no way to do this or am i not able expalin you the problem correctly?? please tryto help me with this.

I have Titles and their descriptions
displayed in one report with page numbers added to
that report, and what i am trying to do in the second
report is printing the Titles in the order of their
subject.So, in this second report can i get the
pagenumber of the Title in which it is present in the
first report.??can i do this??

I have tried doing like this:
In the design view of the second report in the control
source i.e in the expression builder of the
pagenumber(2nd report) can i write some thing like
this:

Reports![Labels order by title]![pageno] where
Reports![Labels order by title]![Title] Like
Reports![orderby subjectindex1]![Title]

Report1 is ![Labels order by title]
report2 is ![orderby subjectindex1]

i don't think we can write but there should be a way
to do this.

Could you please tell me some ways or a path how to
start this application...

hope i will get some repsonse today.

Thanks for your Ideas,
varun
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top