End user needs info
Hello,
I am a true end user of Report Writer. The version that shows up on the
splash screen is 2.0. (This may be our software providers versioning) The
software runs a Sybase Database ver 5.x.x.x
I am looking for a reference of all available functions that I can use in
writing queries. I am not a SQL guru in any way.
I want to know how to evaluate IF functions and similar things for
calculated fields. I also am looking for ways to evaluate expressions in a
query.
For example, I want to return all records in a table where the order is
earlier than TODAY minus 20 days. (I do not want the user to have to type in
the date in the Auto-Search window every time).
Again, I am looking for a reference that shows all the keywords, functions
methods etc etc that can be used when writing/designing a query.
Thanks,
Jason Eberhart
AlertOne Services, Inc
I am a true end user of Report Writer. The version that shows up on the
splash screen is 2.0. (This may be our software providers versioning) The
software runs a Sybase Database ver 5.x.x.x
I am looking for a reference of all available functions that I can use in
writing queries. I am not a SQL guru in any way.
I want to know how to evaluate IF functions and similar things for
calculated fields. I also am looking for ways to evaluate expressions in a
query.
For example, I want to return all records in a table where the order is
earlier than TODAY minus 20 days. (I do not want the user to have to type in
the date in the Auto-Search window every time).
Again, I am looking for a reference that shows all the keywords, functions
methods etc etc that can be used when writing/designing a query.
Thanks,
Jason Eberhart
AlertOne Services, Inc
This discussion has been closed.
Comments
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
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com