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

rbuser

About

Username
rbuser
Joined
Visits
1
Last Active
Roles
Member

Comments

  • Hi Nico,

    Many thanks for the example, I'm almost there but still have a few questions
    and problems :-

    1) Every message on this newsgroup (on this subject) states that you should
    use the Title & Summary bands, but …
  • Thanks Nico,

    The BottomOffset will work.

    Tom


  • Jim,

    Unfortunately I cannot save a data module using the data tabs menu as this
    application is to be seamless to the user. Therefore we will do all of the
    saving programatically. No worries anyway because I can as you say stream…
  • Jim,

    OK Then, I have a few questions about this (sorry it has taken so long to
    get around to this, you will probably need to re-read the posts).

    1. How do I actually save the data modules to file?
    2. Can I perform thi…
  • There are no controls below the subreport. Let me try to explain.

    The report looks like

    Articlenumber description
    315686 This is a article <-- Mainreport detail 1
    Dit is een artikel <-- subreport detail 1…
  • Jim,

    I have sub reports that do not have a datapipeline assigned to them and do
    not have an endless print problem.

    The reason these subreports do not have a datapipeline assigned is because
    the fields in the subreport…
  • Greetings,


    Jim, thanks for the quick response.

    However, I found and solved my own problem, thanks to information from the
    article "TroubleShooting: Report Prints Endless Pages". The subreport's
    DataPipeline was …
  • That didn't work. I even set Transparent to True for all of the regions in
    the DetailBand.BeforePrint. I also closed and restarted the application
    (this is using the end user report designer BTW).

    Thanks,
    Doug

  • Jim,

    Thanks a bunch, that did the trick.

    One more question: I've set the regions to be transparent, but they are
    still printing behind each of the detail lines. Is there something else I
    need to set?

    I'm …
  • I sent an example, and received a working reply but unfortunately not
    satisfactory to my users. The soultion for me was a compromise of setting the
    detail band to static. I do often find myself trying to embed regions,
    forgetting t…
  • Interesting feature - but it still doesn't work.
    With keeptogether true it shows none on the first page 2 and a bit on the
    second.

    The detail band is as follows

    xxxxxxxxxxxx xxxxxxxxxxxxxxx
    x r1a x x …
  • Hi, Jim

    Hmmm.... Where is the Subreport.BeforePrint event, I coundn't find such a
    event for the subreport, The only one I can see is that Subreport only has
    OnPrint event.

    William

  • Hi, Jim

    I just get confused, if I have the subreport1(it is in the detail band of
    main report), it has the subreport2 in the its detail band, in order to
    reprint subreport2 X times, which detailband.BandsPerRecord should be s…
  • Hi, Jim

    How to make this kind of subreport to print start at a new page each
    time?

    William

  • Hi,

    What does exactly the BandsPerRecord property do? Does it just simply
    re-print the same record X times? the one I really want is that the most
    inner subreport should be re-execute the query to get the new records base
  • I did some more test and it seems like it only happened to vendors that don't have
    data in all the subreport queries. What I mean is when all vendors are ran, all
    three subreport queries have data in them. Then if I ran for a single vendor…
  • Ok, I will try to come up with the example. The only thing is that it only
    happens when in the specific situation as I described. I don't know if any other
    data can produce the same result but I will try. But I will try.

    I have …
  • I'm using RB 5.54 (I know it's very old). We're using Interbase. The report is
    used to list transactions by vendors, and need to display totals by type of
    transaction and by vendor. Each subreport represents a different category of
    tr…
  • Forgot to add that I'm trying to do it at run time through the designer.
    (version 6.03)



  • the

    That was it, you are awsome. Thank you for all your help and patience.
    Much easier than messing with the master/detail settings.

    Karen
  • I'm lost. I tried to use the DADE completely in the beginning and it didn't
    work because I have three tables at the same level (similiar to ORDER
    DETAILS) and I would get duplicate data by linking them in the same query to
    the same I…
  • I'm not mixing the two approaches. I am using the the linking only in my
    tadoTable by setting the masterfields and master sources. I have turned off
    all linking through the pipeline directly. The data is written (sorted) by
    the mas…
  • Jim,

    My first choice was getting the master/detail to work at the table level.
    After way-too-long, I think I finally got it. My duplicate data seemed to
    go away by making all my tables inactive, then setting them to active agai…
  • Sorry Jim. I guess I need some clarification. I got it working somewhat at
    one time because I set the pipeline's master/detail pipelines instead of the
    actual ADOtables like I was initially. If I understand your message, then
    that …
  • Thanks a lot ! :-))
    in page break Comment by rbuser June 2003
  • I check PrintBehavior with Section style, but the result is false.

    I get :
    a blank page
    SubReport 2
    The first page
    SubReport 1

    I need
    The first page
    SubReport 1
    SubReport 2
    in page break Comment by rbuser June 2003
  • Jim,

    I apologize for not being able to grasp the whole idea. I agree that it
    would be preferable to use the dbCalcs and ppVars. I am trying to figure
    out where in the report to place the calc components. I need the subtotals<…
  • Thanks Nico, actually that is how I got around it. I was just wondering if
    there was a way to set the title bar to have the same behavior. This works
    though.


    Karen
  • Great!!!!

    It works...

    ppCommunicator :=
    TppSubReport(iObject).Report.FindUserObject('DealerLogoBand');
    if assigned(ppCommunicator) then ....;


    Thanx,
    Vincent!