Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

SQL Query

edited April 2004 in End User
hi,
I need to get data from two tables. for one table i get data using query

SELECT Porders."Created By" Created_By,
Count(*) AS Total_Jobs ,
SUM(CASE WHEN ( Porders.ClosedLevel = 1 AND Porders."Created By" <>
'null' ) THEN 1 ELSE 0 END) AS Open,
SUM(CASE WHEN (Porders.ClosedLevel <> 1 AND Porders."Created By" <>
'null' ) THEN 1 ELSE 0 END) AS Close
FROM Porders Porders
GROUP BY Porders."Created By"
ORDER BY Porders."Created By"


same data is reuired from the Torder table on same report. how to do it?
I have reportbuilder which is given as tool in staffing software for end
user. nothing else is available with it. no demos and nothing.
Thanks,
Trupti

Comments

  • edited April 2004
    Trupti,

    You will need to create another query or join the two tables together. If
    you create another query in DADE, you can link the two which will result in
    an underlying table join.

    -----------------------------------------
    Article: End-User Tech Support
    -----------------------------------------

    Please understand that Digital Metaphors can only provide tech support to
    the Delphi developers that purchase ReportBuilder. Digital Metaphors
    receives no distribution royalties from Delphi developers that embed
    end-user reporting solutions in their applications. It is the responsibility
    of the software publishers that sold you the product to provide you with
    tech support.

    There is an end-user tutorial called Learning ReportBuilder that can be
    downloaded from our web site for free. See the following article for more
    infomation.

    --------------------------------
    Article: Learning ReportBuilder
    --------------------------------

    Learning ReportBuilder is a complete learning system designed to teach end
    users how to build a range of reports. This system includes a 125-page PDF
    file, a stand-alone application complete with a database, and a help file.
    The PDF file is comprised of a series of tutorials that step end users
    through the process of building reports as simple as a table listing and as
    complex as crosstabs. The tutorials also introduce conceptual aspects of
    report building along the way. The application is used in conjunction with
    the tutorials so that the learning experience is interactive. The end user
    just prints out the PDF file, runs the application, and learns
    ReportBuilder. The help file is accessible from the application, so all
    three tools work together to provide a seamless learning environment.

    Learning ReportBuilder installs into C:\Program Files\LearnReportBuilder.
    When the system has successfully installed, a complete set of instructions
    appears in the form of a 'ReadMe' doc, so the end user knows just what to do
    upon installation.

    - Download Learning ReportBuilder

    http://www.digital-metaphors.com/LearnRB/LearnRB.exe

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.