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

Comparing two fields in query designer

rbuserrbuser
edited April 2004 in End User
I'm trying to build a report using the query designer that includes all
records where column1 < column 2... but this doesn't seem to be possible...
I have to type something into the value and I can't seem to type the name of
the field into that value.

The other thing I'd like to do is link a table to another table based on
multiple criteria - e.g.
Select foo from A Join B
ON x=y AND k<j

Is this possible?

Best Regards,

James Crosswell
Software Engineer
Microforge.net Limited
http://www.microforge.net

Comments

  • nardmoseleynardmoseley
    edited April 2004

    1. To select records where column1 < column2, access the Query Designer and
    select the Search tab. Select column1 from the available field list, then in
    the Value edit box specify the field by qualifying it with the database
    table name (i.e. tablename.Column2.).

    2. Not sure whether you are asking about performing a SQL join on two tables
    or using ReportBuilder's Query DataView linking feature.

    a. SQL Joins are performed using the Tables tab of the Query Designer. The
    join dialog enables any number of fields to be specified.

    b. Query DataView linking can be performed by dragging the linking field
    from the detail dataview to the master dataview. A visual link is drawn in
    the Data workspace. You can select the link with the mouse and then
    double-click to access the Link dialog and add more fields. Alternatively
    you can position the mouse over the detail Query DataView and press the
    right mouse button to display the context menu. Then select the Link menu
    item to display the Link dialog.





    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited April 2004
    "Nard Moseley (Digital Metaphors)" wrote in
  • nardmoseleynardmoseley
    edited April 2004


    Yes. You can do this via the Link dialog as I described in my prior
    response...

    "You can select the link with the mouse and then
    double-click to access the Link dialog and add more fields. Alternatively
    you can position the mouse over the detail Query DataView and press the
    right mouse button to display the context menu. Then select the Link menu
    item to display the Link dialog."




    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

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