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

nardmoseley

About

Username
nardmoseley
Joined
Visits
8,058
Last Active
Roles
Administrator

Comments


  • There is not a known issue with RB 10.09. Make sure you are using RB 10.09
    and not RB 10.08.

    Please create a simple, focused test project that can run here in the Delphi
    debugger. Use standard Delphi components and RB. U…

  • We need a runnable example to do anything but guess as to what might be
    causing the error.

    Perhaps you have a global 'scoresList' somewhere else and it is getting
    confused (though it shouldn't). As a test renaming it to<…
  • I cannot determine anything wrong from looking at the code sample. If you
    would like to create a simple, focused example project, we can check it out
    here using the debugger. Send in zip format to
    support@digital-metpahors.com. Use…

  • Try implementing a solution using Delphi code and then write a pass-through
    function that you can call from RAP.


    --------------------------------------------------
    Article: Extending RAP
    ----------------------…
  • Subreports do not have their own AutoSearch or DADE TdaDataModule. If you
    load an .rtm into a subreport, then the DADE dataviews get merged into the
    main report's TdaDataModule.

    TppReport
    DataModule.DataViews[ ]
  • If calling Group.Free works from Report.OnInitializeParameters, then I would
    use that. It's a timing issue.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • The Group.OnGetBreakValue event can be used to control when the group
    breaks. If you want the group to never break, then return a constant value.

    Another option might be to call Group.Free. However you need to do this
    pr…


  • 1. RB 11 includes AutoSearch and Visual Linking support for manual edited
    SQL. No code is required.

    a. From the Design workspace you can add Parameters and configure the
    Parameter.AutoSearchSettings properties and …


  • Are you connecting at least one of the fields from the detail dataset to a
    data-aware control or subreport? The report engine examines the data-aware
    components to determine which datapipelines are being used in the report. I…

  • I researched this and it will be fixed for the next maintenance release. I
    notice the error only occurs when I drag-drop to an empty event-handler.

    In my testing if I create the event-handler first, the code is inserted

  • If you want to limit the size of the Image control, try using the
    DetailBand.BeforePrint event to check the image dimensions.

    Example:

    If myImage.Picture.Width > MaxWidth then
    myImage.Stretch := True

  • Try setting Stretch to False. Set AutoSize to True.

    Stretch in this context really means - resize the image to fit within the
    bounds of the control. So the image gets either shrunk or enlarged.

    AutoSize means resize…

  • I recommend downloading a trial of RB 11 for D7 and trying the same test.

    You can also try manually refreshing the RB printer list.

    uses
    ppPrintr;

    begin

    ppPrinters.Refresh;

    end;<…

  • With RB 11.03 you can solve this without writing any code. The key is to use
    Parameters - which allow a tremendous amount of control and flexibility over
    autosearch behavior by setting properties.

    Use the Design workspac…

  • At Delphi design-time the Designer.DatabaseSettings are loaded/saved from
    RBulider.ini.

    A step could probably be added to the Developers Guide RAP tutorials to
    configure the DataSettings.

    The Learning ReportBu…
  • I read this over a few times and do not understand what you are trying to
    say.

    RB 10.09 was the last produced release for RB 10.x. Please send your serial
    number and registration info to info@digital-metaphors.com and request

  • Please see the answer I posted to your question in the General newsgroup.

    Please do not cross post.

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • 1. To access a field value, use myDataPipeline['FieldName'] - this code is
    generated for you if you drag a field from the Code Toolbox to the designer.

    2. To access the TppField objects, use
    myDataPipeline.FieldObjects['…

  • The The ReportBuilder RAP reference is installed with ReportBuilder and
    integrated in to the Delphi help system.

    The RAP Code Toolbox at the bottom right corner of the Calc workspace has an
    Objects and Language tab that …
  • To echo Nico, it works for me using RB 11.04.

    Perhaps the issue is not the 'and' operator, but more likely the negation
    uniary operator "-". Since the "-" operator can representative negation or
    subtraction it is a bit tricky. O…

  • Thanks for the additional detail. I modified daSQL, FormatValue to use
    AnsiUpperCase going forward.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • Can you specify what unit(s) are causing the issue? Or how should I go about
    researching this?


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • During first pass, the pagination is calculated (i.e. the spaced used by
    each object, the height of each band, what fits where). This cannot be
    changed during the second pass.

    You will need to pre-process the data and ca…

  • Here are some simple samples

    1. To check a data value.....

    if myPipeline['Quantity'] = 0 then
    begin
    // set to use special formatting
    end
    else
    begin
    // set to use standard format…

  • In general, you cannot modify the SQL while the report is generating.

    The solution is to model the data access to support your requirements.

    Some options:

    1. In the query, perform a SQL join to link in the look…
  • Yes, pass the report instance to the function as a parameter. By default the
    pass-thru functions do not have access to the Report instance.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

  • Definitely a mystery. Perhaps dues to an issue with a prior release. Using
    RB 11.06, you might try deleting and then re-adding the Report.Parameter for
    the existing report that has the error.

    --
    Nard Moseley
    D…

  • It works correctly in my testing here. In re-reading this thread I notice
    you are using 11.05, try updating to 11.06.

    In my testing, I used ElevateDB with RB 11.06 and D2007.

    I ran the Demos\EndUser Databases\Elevat…

  • The feature is not dependent upon any particular database engine. ElevateDB
    will work great.

    The feature requires you to first define the Report.Parameter and configure
    the Parameter with a DataType, Name, and default Va…

  • RB 11 enables you to use bind a parameter to manually edited SQL by using
    :ParameterName notation. At run-time RB will be automatically replace the
    :ParameterName with the paramter value.

    Example:

    1. Define a …