Hi Ralph,
Yup, I've been reading (and rereading) that as I tinker. The explanation
of skip-to - and the way it behaves with a subreport - makes perfect
sense, and the explanation of two-level reports also makes perfect
sense, and indeed I can get both features to work just fine separately.
But my understanding seems to be breaking down when trying to combine
the two features. Intuitively, one would think this would behave like
skip-to on a subreport (i.e. with skip-to in a two-level report header
operating on the second field of the report index), but that doesn't
appear to be the case. I can't quite figure out /what/ it's doing after
putting the skip-to code in various parts of the report (first-page
header both before and after the do-subreport code, and two-level-report
header).
Worst-case scenario, I just redo this as a proper report/subreport
combo, but it would be nice to know if there's a way to use skip-to with
dates in simple two-level report designs. And if anybody can confirm
this should in fact work as I'm describing, then I'll see if I can find
whatever dumb subtle mistake I've made. :)
On 7/17/2018 10:49 AM, Ralph Alvy wrote:
Did you read the Iteration Control chapter of my PDF book?
RA
On 17 Jul 2018, at 7:14, Dave Britten wrote:
Greetings folks,
I'm wracking my brain trying to figure out how to make this work as
expected. I've got a time/billing database, with a time entry panel.
I've created a report based on this panel that I'll use to produce
details of all entries within a given month. I want these entries to
be grouped by client, so I've configured the report to use an index
on Client ID, Date, and the first-page header has a two-level
subreport code sorted by Client ID. So far so good; the format of the
output is exactly what I want, and includes some variables that
calculate subtotals and a grand total for various footer sections.
Then I added a prompt for a date that I'm putting in RV1. Try as I
might, I can't figure out where to put the skip-to code to make this
the start date for the report. My assumption is that this would work
like a subreport, and the skip-to would operate on the second field
of the index. When putting the skip-to code in the two-level report
header (via cut/paste, since you can't directly put it there with
Ctrl-F7), I get pretty odd results. When entering "07/01/2018" for
the start date, the report is going straight to a record from 7/9,
but not displaying anything from the two-level header that comes
after the skip-to code. Then the report ends after that one record,
displaying both the two-level footer and final footer. I'm not really
sure what to make of that.
What's the correct way to get the effect of a two-level report, with
a start-date prompt that skips to the first record after that date
within each client, and also omits the two-level header/footer for
any client that doesn't have any records within that date range?
--
-Dave Britten
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
--
-Dave Britten
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
