Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Grrr. Hissss..

rbuserrbuser
edited January 2009 in End User
Hi Guys,

Why do I do this to myself??

I am converting reports from a Clipper, yes the DOS application, environment
to Delphi using RB.

I am currently wrestling with a problem where in the Invoice table the
Customer # is a numeric. In the Company table, only one record in it, is a
string field called 'WtyCusts'. Within WtyCusts the Warranty Customer's
Customer # are recorded in the form 'xxxxxx;yyyyy;zzzzz', minus the quotes of
course and where xxxxx, yyyy, zzzz represent different Customer #s.

In the report I am trying to set up a 'Search' where only records for those
Customer #s that don't appear in 'WtyCusts' are retrieved/shown.

In the report the Invoice & Company tables are two separate tables in the Data
tab.

I have other reports I will need to address with similar structure so fixing
this one will go to fixing some others as well.

Any thoughts/suggestion on how to work this issue will be greatly appreciated.

Regards & TIA,

Ian

Comments

  • rbuserrbuser
    edited January 2009
    "Ian Branch" wrote in message
  • rbuserrbuser
    edited January 2009


    Hi Paul,

    Again, thanks for responding.

    All I am working on att is in the End-User report designer.

    I am using Advantage .ADT tables.

    Regards,

    Ian
  • rbuserrbuser
    edited January 2009
    "Ian Branch" wrote in message
  • rbuserrbuser
    edited January 2009
    Hi Paul,

    Thank you for your input.

    Your thoughts led me to a fourth option. As each Customer can have one or
    more of many product Wty relationships, I added a Wty Flag, boolean, for each
    product to the Customer DB. Six flags in all.

    This eliminated the problem in one fell swoop.

    Regards & thanks again for your input.

    Ian
  • nardmoseleynardmoseley
    edited January 2009


    With RB 11 this is no longer a limitation. You can edit the SQL directly and
    still use autosearch and visual linking. :)

    With RB 11 you can create and configure Report.Parameters via the Designer.
    Parameters can be configured for AutoSearch and Lookups. And for dates,
    there is a built-in calendar. From the Data workspace you can create search
    conditions and bind to Parameters - so for example you can bind several
    queries to a single parameter. When editing SQL directly you can use
    :ParamName notation. And linking has been enhanced to enable 3 different
    types of data linking.

    The power of what is possible without writing any code is a huge leap
    forward. :)

    http://www.digital-metaphors.com/rbWiki/General/What's_New/RB_11


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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited January 2009
    "Nard Moseley (Digital Metaphors)" wrote in
This discussion has been closed.