Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Small Report Too Big

edited August 2005 in General
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.

Comments

  • edited August 2005
    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
  • edited August 2005
    > 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.

  • edited August 2005
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2005
    > 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.

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

    Nigel

  • edited August 2005
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2005
    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.

This discussion has been closed.