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

DBText not filled

edited July 2004 in General
I'm using 3 TextPipelines to read in 3 textfiles. In my header file there
are 24 items and in my report I have linked 24 DBText to the records.

But only the first 6 DBText items are filled, number 7 is only filled with
the first 2 characters of the record(the size is 'autosize' so it should
fit). Records 8-18 are on page 2 and 19-24 are on page 3 and number 8 is on
the same place as number 1 an do is number 19 on the same place as number 1.

All the records should display on page 1 in the right DBText objects but
instead they are spread over 3 pages. How could this happen?

Thnx for your help!

Wouter de Kort

ps: I've just started with using Report Builder on my work, currently I'm
working at home with a trial version of ReportBuilder, could that be the
problem?

Comments

  • edited July 2004
    Hi Wouter,

    Thanks for trying ReportBuilder.

    A single report object can only traverse the data from one dataset during
    report generation. If you would like to traverse the data for all three
    pipelines, you will need to place a few subreports on your main report and
    assign their DataPipeline properties to the other TextPipelines. I'm unsure
    why only two characters of some of the fields is displaying but it may have
    something to do with the fact that the datapipeline is not connected for all
    the records you are trying to display. Also, if you would like to keep all
    the records on one page, you can simply resize the subreports to all fit on
    one page. See demo 73 for an example of this located in the
    \RBuilder\Demos\1. Reports\... directory. (dm0073.pas).

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2004
    Sorry if I was not clear enough :) My english isn't great(as you should have
    noticed ;) )

    I'm using the trial version because I'm working at my own home computer, at
    work I've got a complete registered version of Report Builder. I only
    mentioned it because I didn't know if it could cause the problem.

    I've already created a few reports and I've used the subreport for some
    things but I don't thing that causes the problem i currently have because
    the header fields that are causing my problem come from one text file.

    All the DBText fields where already placed one 1 page :) Resizing the detail
    band is something I can understand ;)

    The problem is that altough I have placed 24 DBText fields Report Builder
    uses only a few of them and the rest is empty. Instead of using the other
    text fields it creates a new page and starts at the top of the page.

    So on page 1 i've got:

    DBtext 1 : 1
    DBtext 2 : 2
    :....
    DBtext 7: 7
    DBtext 8 - 24 are empty

    Page 2:

    DBtext 1: 10
    DBtext 2: 11
    ...
    DBtext 18: 18
    DBtext 19- 24 is empty

    Page 3:

    DBText1 : 23
    DBText2 : 24

    So altough I haven't changed the record that DBText1 points to it shows
    different records on different pages.
    Some numbers suddenly appear at the bottom of the page altough there are no
    text fields there.

    I hope I've explained the problem somewhat better know :)
    Thnx for your help!

    Wouter de Kort

  • edited July 2004
    Hi Wouter,

    Sorry about that, when you mentioned you were using a trial version, I
    assumed you were a new user :). If possible please send an example of this
    application to support@digital-metaphors.com and I'll try to recreate this
    behavior on my machine.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.