Small Report Too Big

rbuser

I have a dataset with 14 Records. I Am Trying to make an Invoice Out Of It.
THe HeaderInformation is contained on All the lines so there are DataAware
Fields in the Header of the report. On the Lients are the Detail Fields.

However when I Preview the report it trys to create a report that is
hundreds of pages long. Anyone know what is going on here?

Nigel.

rbuser

In article <42f005d1$1@dm500.>, swami@swamisdsSPAM.dfg says...

How is the dataset connected to the report? Is anything else connected to
the dataset?

One explanation may be that you have a dataset where the current record
is being changed - you are getting hundreds of pages because the dataset
keeps getting a "first" (or refreshed by a connected master dataset).

I've also sometimes received this behaviour when the report size is too
big - that is, something on the report designer is larger than 8-1/2 x 11
sheet (or whatever your page properties are).

Cheers,
EdB

rbuser

> One explanation may be that you have a dataset where the current record

There is no master detail relationship. I tried changing to two data sets
(The first is a single record that holds the header, the second holds the
lines). THe seccond data set appears in a subreport and is not connected to
the first through a master detail relationship.

This report used to work when it was just lables filled in at runtime in
code.

nicocizik

Hi,

Be sure the main report and subreport are not connected to the same
datapipeline.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

> Be sure the main report and subreport are not connected to the same

Checked this. Main Report Is Connected to one pipeline as are all the fileds
in the header.

The Sub report and all its fields are connected to a second pipeline. I
think the problem is that the Report seems to think there is more than one
record in the MainData Pieline. When I move the Header Fields in to the
detail band THe Header Fields are repeated over and over againn

Nigel.

rbuser

As A Side note I am still using Version 9.01. Is it possible this relates to
an issue corrected 9.02?

Nigel

nicocizik

Hi Nigel,

As always, we recommend using the latest version of ReportBuilder. I
believe there were a few issues addressed that may help your problem. Try
upgrading to RB 9.02 and see if the problem still occurs.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I will upgrade. Though I found the problem. I had set the Pipeline for the
fields in the main report but not the main report itself.

I feel like an idiot. Sorry for taking up everyones time.

Nigel.