Best Way to Achieve this report

rbuser

I have a report that lists the day of each month then an event beside it.
But if there is no event beside it It shoudl still list the day and have a
blank space next to it. Such as

M 1
T 2 Baseball game
W 3 Football Game
T 4
F 5
S 6
S 7
..(continues for everyday of the month)
F 26 Baseball Game
S 27
S 28 Picnic Lunch

I can get a query to return me the days that have events, but how can I get
ReportBuilder to print each day number for those days that there are no
events?

Thanks

nicocizik

Hi Chris,

The easiest way to accomplish this type of report is to create a
Master-Detail style report. You already have the detail dataset created,
now you need to create a Master dataset consisting of an empty calendar, or
just the days and dates. Then you can link the detail to the master using
the date and be sure that the detail datapipeline's SkipWhenNoRecords
property is set to False. Then the report should print as you expect. If
you need an example let me know.

--

rbuser

Ok that makes great sense to me. I think i can handle it, but if you do
already have an example of such a thing i'd like to see it.

Thanks.

rbuser

Ok an example would be good here, as I have come up with a few questions.

1. The examples I found in demos with master/detail reports are only where
the master is in a band above the detail, I need them on the same band, how
does this differ?

2. My master will be a stringlist i'm guessing or something of that sort,
while my detail will be a query, how do I set up a master/detail
relationship with stringlist / query?

Thanks.

nicocizik

Hi Chirs,

Check out demos 136 and 139 (dm0136.pas and dm0139.pas) in the
\RBuilder\Demos\1. Reports\... directory. These demos show how to use a
JITPipeline to pull data off of a string list and how to link these
pipelines in a Master-Detail relationship. You will want to link your
JITPipeline to your original dataset.

--

rbuser

Ok I have already found those and basically got it working, now I just have
a general question.

In my detail band I have the follow
------------
Text Field
Text Field 2
Memo Field
------------

if text field 2 is empty and memo field is empty I want the report to use
that space for the next row and not leave an empty space. How do I get it
to shift up in this manner.

For Example
------------
Game 1
Date 1
Memo 1
------------
Game 2
------------
Game 3
Date 3
------------
Game 4

I tried changing their visible properites but I must not be doing it in the
proper place.

nicocizik

Hi Chris,

Try setting the TppDetailBand.PrintHeight to phDynamic. If this does not
help, you will need to suppress the printing of null values in the detail
band by setting the DataPipeline.SkipWhenNoRecords property to True.

--