Columns come from which dataset in report?

rbuser

Hi everybody,

The help says the following about the columns property of ppReport:

"When the columns property is set to any number greater than 1,
ReportBuilder will print your records in columns."

My question: What records from which dataset does it use to find out the
number of neccesary columns?
a) The dataset property of ppReport?
or
b) The dataset property of any of the fields actually used in the
column?

Thanks for any help you can give me,

Vincent.

nicocizik

Hi Vincent,

The number of columns is determined by the number of columns you define in
the page setup. For instance, if you create a report with 3 columns and
there is only enough data to fill two columns, the third column will remain
blank but you will still have 3 columns present. You can limit the number
of records printed per column by using the DetailBand.PrintCount property.
Please see demos 32 and 33 in the RBuilder\Demos\1. Reports\... directory
for more information on how columns work in ReportBuilder.

--

rbuser

Hi Nico, thanks for your reply.

I think I didn't state my question clear enough. What I meant is:

I connected a dataset X to a ppReport. Then I set ppReport.Columns to 2 (for
2 columns). On the column that is then shown in my report I put a dbEdit
that is connected to dataset Y.

Now, after opening all my datasets on runtime, dataset X has 1 record and
dataset Y has 2 records.

Question: Should there be 1 or 2 columns shown in my report on runtime?

Regards,

Vincent.

nicocizik

Hi Vincent,

Sorry for the confusion. When setting the number of columns using the
Report.Columns property, a new column will not start unless the first column
runs out of room on the page. To answer your question, only one column will
be printed when you run your report unless you connect the report to DataSet
Y and set the DetailBand.PrintCount to 1.

--

rbuser

Ah, I think we're getting somewhere.

So to make a TppReport create more than 1 column, the dataset connected to
the TppReport must have more than 1 record.
Other datasets used whereever do not matter.

Thanks for your help,

Vincent.

rbuser

Hey guys,

I still don't have it working. With:
- the master dataset (containing 1 record) connected to the TppReport
- TppDBText fields connected to a detail dataset (containing 2 or more
records) in the column
- TppReport.Column = 2
- TppReport.ColumnWidth = 336

it still only prints 1 column. Not even 2 or more pages with 1 column per
page but always just 1 column....

Why would the column not be repeating?

Regards,

Vincent.

nicocizik

Hi Vincent,

If possible, please send a small example in .zip format to
support@digital-metaphors.com with a description on how you would like it to
look and I will take a look at the design for you.

--

rbuser

Nico,

I've sent an email with a 8kb zip file that has a little sample program in
it and an explanation on what I'd like the report to do.

Hopefully you can help me with this.

Cheers,

Vincent.

nicocizik

Thanks Vincent,

I'll take a look at it and get back to you asap.

--

rbuser

Nico,

I also sent an email saying that it's okay now. A colleague of mine figured
out what was wrong and the report is printing as expected now. I hope you
didn't waste too much time on it.

Thanks for all your help,

Vincent.