How to access a record from the report page ?

  • Thread starter Thread starter Ilya
  • Start date Start date
I

Ilya

Hi, everybody:
How to access record from a particular report page ?
Thanks in advance, Ilya.
 
My Clarification:
Detail section includes records with "market code" field.
I have to put on each page header the list of market code
names: Market Code1 - Name1
Market Code2 - Name2
 
Ilya,
If I understant your question correctly you are trying to give an
explanation of all marketing codes on the page header of every page. Like a
"legend".

Create a new report that shows just the market codes you want to see in your
report header. Then create a subreport in the header section of your main
report and use the new Market Codes report as the "Source Object" for the
subreport. Link Child Fields and Link Master Fields should both be blank for
the subreport.

David Straker
 
Dear David:
Thanks for your Responce:
Inspite of obvious I have done your suggestion.
The list in Page header shows all market codes not
restricted with current page. So, the problem still exists.
Regards, Ilya.
 
Sorry Ilya,
I'm not following your English very well. I'm going to try to guess your
question again.

Do you want each page of detail to have only the Market Code for those
details on the page header then, when a Market Code changes for the details,
start a new page with the new page header showing the new Market Code. If
so, I've posted an Access 2000 mdb called dxsTest.mdb on my developer page
at www.estraker.com.CrystalExamples for you to look at.

If I've got the question wrong again, let me know.

David Straker
 
Ilya,
I just saw your other post on Sept 26 entitled "Subreport with
Detail/PgeHeader Objects". It seems to cover the same problem. You other
post seems to be saying "Each Detail line has a related Market Code. I want
the Page Footer to show all of the Market Codes that have appeared in detail
lines on the page". (Please keep all related posts in one newsgroup item if
you can, instead of re-posting - so we can follow the whole story.)

It would be easier if you could change the requirement. For example, just
show the Market Code on each Detail Line. That's what report writers are
good at. Or, start a new page for each Market Code. That's what I thought
you wanted when I wrote my reply earlier tonight. Or show all Market codes
in the footer. That's what I originally thought you wanted.

If you really have to keep track of the Market Codes used on the page and
then create a Page Footer listing them, that's also in the dxsTest.mdb I
posted at www.estraker.com.CrystalExamples for you (look for your name on
the Web page). Just make sure that you make the page footer tall enough for
the maximum number of lines for Market Codes that can be shown plus any
fields below them (like page number and print date) or part of the page
footer won't print..

David Straker
 
Dear David:
Thanks for your patience.
Here is another try to clarify:
For each unique MarketCode value in detail section of the
Page there shall be legend line in the page header. Not in
the footer, not in the detail section, but in the Page
Header. This request is coming from my client, so my
choice is limited. Starting a new page based on market
value is not acceptable.
With my best, Ilya
 
Hi Ilya,
I can't see how you can put a "summary" of the detail in the page header -
it is created before the detail. Report writers don't work like this. You
need to put it in the page footer.

David Straker
 
Back
Top