I
Ilya
Hi, everybody:
How to access record from a particular report page ?
Thanks in advance, Ilya.
How to access record from a particular report page ?
Thanks in advance, Ilya.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Larry Linson
Please clarify your question -- I don't understand what you are asking.
I
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
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
D
David Straker
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
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
I
Ilya
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.
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.
D
David Straker
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
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
D
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
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
I
Ilya
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
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
D
David Straker
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
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
D
David Straker
I
Ilya
David:
I may negotiate with my client to change the place for the
legend into the Page Footer, so I would like to know
proper address of the web site.
I would see a solution for any place, Page Header or
Footer by preplanning Page Detail and Page Header/Footer.
First step is to put all records into temporary table with
line number for each record. The second step is
precalculate portion of records for detail section and for
the subreport in the Footer/Header. There is a way to
control number of records per page. What I do not know is
if Report Writer allows manipulate RecordSource at Run
Time? What do You think about this ?
Thanks in advance, Ilya
I may negotiate with my client to change the place for the
legend into the Page Footer, so I would like to know
proper address of the web site.
I would see a solution for any place, Page Header or
Footer by preplanning Page Detail and Page Header/Footer.
First step is to put all records into temporary table with
line number for each record. The second step is
precalculate portion of records for detail section and for
the subreport in the Footer/Header. There is a way to
control number of records per page. What I do not know is
if Report Writer allows manipulate RecordSource at Run
Time? What do You think about this ?
Thanks in advance, Ilya
D
David Straker
Ilya,
Look further down in the messages - my post on 09/30/2003 at 09:19 gives the
correct web page address. It's http://www.estraker.com/CrystalExamples -
look for your name on the page.
I think that it's a good idea to design systems that work within the normal
boundaries of the development software you're using. I occasionally need to
explain to my clients why some of their requirements are not possible in a
given technical environment unless they are willing to give me unlimited
time and money. If you want to write your own pre-processor for Access
reports and your client is willing to pay whatever it costs and wait until
it's finished, good luck. Personally I wouldn't do it.
David Straker
Look further down in the messages - my post on 09/30/2003 at 09:19 gives the
correct web page address. It's http://www.estraker.com/CrystalExamples -
look for your name on the page.
I think that it's a good idea to design systems that work within the normal
boundaries of the development software you're using. I occasionally need to
explain to my clients why some of their requirements are not possible in a
given technical environment unless they are willing to give me unlimited
time and money. If you want to write your own pre-processor for Access
reports and your client is willing to pay whatever it costs and wait until
it's finished, good luck. Personally I wouldn't do it.
David Straker
L
Larry Linson
What I do not know is if Report Writer
allows manipulate RecordSource at Run
Time?
You can change the RecordSource of a Report in the Report's OpenEvent ONLY
at Runtime (or in Design View).
What you describe seems a good match for a Subreport in the Header or
Footer. Unfortunately, neither the Page Header nor Page Footer has CanGrow
and CanShrink properties to allow them to adjust to a different number of
lines of information in a SubReport control. This would only be worth
additional effort, it appears, if you have a known number of Market Codes on
each page, or an upper limit for the number that you can use to size a
SubReport Control.
The Report Header, Detail, and Report Footer do have CanGrow and CanShrink
properties, but that is of no use for what you want to do.
I simply do not have a solution for this -- I was hopeful that MVP Stephen
Lebans might have addressed this issue but I do not see it among the many
enhancements and tricks he has done for Reporting. His web site is
http://www.lebans.com, if you'd like to take a look at the many things he
has made available.
Larry Linson
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.