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

  • 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,
  • 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.
  • 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
    - TppRe…
  • 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 …
  • 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…
  • I tried to hide SQL property but RAP still sees the real one (at compile
    time)
    I will try to reproduce (if time will permit ...) with the rb demo

  • Ok we did it.
    There is a strange side-effect not actually a problem
    It seems that RAP "sees" the "real" class we are registering.
    For example, our class (TILOracleQuery) has an SQL property, which is a
    TStrings.
    In the inte…
  • The spreadsheet style report is not exactly what i meant.

    In the spreadsheet style report the columns are defined in a fixed manner.
    Each column displays one field.

    What I want is a variable number of colums to be retrieve…
  • >


    Sorry, my mistake. I misread something.

    Tom
  • The code in TForm1.ppReport1GetAutoSearchValues appears to be changing it,
    but I don'f fully understand it. I'm hoping it will answer my question, or
    move me forward.

    /Matthew Jones/
  • Pardon me for joining in...


    Is there a way to add a function or global in Delphi code that can then be
    used in the SQL of the RAP dialogs? Basically, some means of setting a
    value that can be used in a comparison in the …
  • But are they global for every report?
    I thougt they are only for the report in which they reside...



  • Okay, I'm learning far too much tonight. The line:
    ppReport.AutoSearchFields[0].SearchExpression := 40 {value};

    is in my Delphi code. If I put it in the ppReportGetAutoSearchValues
    event, it only ever gets called w…


  • Okay, so you have to click the search button to see it. Seems odd to call
    it "Auto" when it is manual. The rest of the questions remain though. 8-)

    /Matthew Jones/
  • > Report.AutoSearchFields[0].SearchExpression := {global value here}

    This sounds the ideal thing. Unfortunately I just cannot work out how to
    get it to work at all. Is this Delphi code or RAP code? The Autosearch
    example fo…
  • Thanks - I think I'm not making myself clear though. I'm using the ADO
    connection stuff to connect to SQL Server. I need the master query to
    select a single record (the detail queries are indeed easy to link - I am
    impressed with t…
  • I indeed found a different approach and am happy to tell you that I got all
    reports fully functional again right before the weekend so I'm pretty
    satisfied with that :-)

    Thanks for your help and hope you have a nice weekend,
  • I meant subreport instead of "detail" in my first line... sorry.

    V.

  • I did what you said but it's not working. I read in the help that a detail
    will not print if the parent band's Printheight is set to Static. Since I'm
    using columns that go from left to right instead of toptobottom I cannot set
    the pr…
  • Hi Nard,

    The number of records in Z varies so I can't use a fixed number of fields in
    a subreport. How do I make a subreport auto-create the neccesary fields
    then? Or can you make 1 subreport and repeat it for each record in Z?<…
  • Maybe I should write this a bit more clear:


    There are 3 recordsets, X, Y and Z. X is the master and Y and Z are details.
    My other post was about recordset Y which is connected to the TppReport so
    that Y's contents can be d…
  • Found it myself -- the Signature did not have a semicolon at the end.

    Jim

  • Thanks, Nard. Didn't mean to step on your reply.

    Jim

  • Hi Nard,
    I don't want recompile and change my code again.
    I want know is there way without changing the code and recompile and release
    it again.

    I think I will define the AutoSearch Field for the Due Date and how can I
  • I solve it with CreateAutoSearchCriteria.

    Regards,

    Jose Maria Sanmartin

    "Jose Maria Sanmartin" escribi? en el mensaje
  • Hello Nard,

    In fact I am using Custom AutoSearch Dialogs but

    1.- I don't know how to use a custom autosearchpanel for two fields

    2.- or How to disable an autosearchpanel and use AutoSearchFields[0] and
  • ok, I'm already doing that. I can see that my criteria
    is actually being added now. However, my report
    does not get refreshed until go to the Query designer,
    clicked ok, before the report actually display the data
    based on the ne…
  • > It looks so easy when you know the answer but i have searched around for

    I know--I spend hours looking for something before I send support (for any
    product) a question. I try to simplify/isolate the question as much as I can
  • Hi Ed,

    thanks a lot for your help.

    It looks so easy when you know the answer but i have searched around for
    hours.

    Once again many thanks

    F.-P:Krebs