SQR Programming Language Resources
SQR Development SQR Reports
begin-report
end-report

SQR: What's new


Welcome to sqr-info.com, where you will find links to the best sites offering useful information on SQR development and the SQR programming language for SQR programmers and their employers. We cover both Hyperion SQR (formerly Brio SQR Server) and Oracle/PeopleSoft SQR.

It is polite to point! Please bookmark this page, and link to us from your web site!

Visit our Specific SQR Topics page for links to discussion forum and blog postings.
 


Hyperion Developer Network > Tech Doc > What's New in Hyperion SQR (Release 8 | 8.1 | 8.2 | 8.3)
New features in Hyperion SQR.



begin-procedure
end-procedure

SQR how-to, tips, code and discussion

Are you an
independent contractor?
(Or need one?)

Tap into our network.

Protallian, the Professional Talent Alliance, is a self-referred network of independent contract consultants and engineers. We are in beta and currently inviting independent contractors specializing in SQR and/or PeopleSoft to join the network.

Member site: www.protallian.net
Client site: www.protallian.com
ERPCommunity > PeopleSoft > Development > SQR
A forum for SQR technical questions and discussion.

PeopleSoftCity > Support Center > SQR
A newer forum for SQR developers.

PeopleSoft Fans > Forum Index > PeopleSoft Tools
General technical discussion, including SQR.

Yahoo! Groups > PeopleSoft-Fans Group
A moderated email list covering PeopleSoft topics, including SQR for PeopleSoft.

SQR Users Group > SQR-Users List
An active email list for SQR programming questions. Page also links to archives of past discussion topics.

SQR Users Group > Library
Sample code and tools.

PeopleSoft > Customer Connection > Support > Troubleshooting > Tips Requires account/password
Scroll to "SQR" for information on SQR for PeopleSoft. (Requires Customer Connection login.)

PeopleSoft > Customer Connection > Support > Discussion Groups Requires account/password
Discussion groups covering all PeopleSoft technologies, including SQR for PeopleSoft. (Requires Customer Connection login.)

Also see our Specific SQR Topics page



begin-sql
end-sql

Databases

Oracle Technology Network
Oracle's technical directory.

SQL Server Developer Center
Microsoft's technical directory for SQL Server.

DB2 Technical Resources
IBM's technical directory for DB2 UDB.

Sybase Developer Network
Sybase's technical directory.



begin-document
end-document

SQR reference

Hyperion Developer Network > Tech Doc > Quick Reference Card (Release 8 | 8.2 | 8.3 | 8.5)
Quick reference cards for Hyperion SQR syntax.

Hyperion Developer Network > Tech Doc > Language Reference (Release 8 | 8.1 | 8.2 | 8.3 | 8.5)
Full language reference for Hyperion SQR.

SQR programmer's reference card
A comprehensive syntax reference for versions 2.x-6.x.

Hyperion Developer Network > Tips/FAQs > Support Matrix (Release 8.1 | 8.1.2 | 8.2)
Matrix showing Hyperion SQR support by operating system, database, web server and browser types.

PeopleBooks
The PeopleBooks library contains the SQR for PeopleSoft Developer's Guide and the SQR for PeopleSoft Language Reference. PeopleBooks may also be ordered at PeopleSoft > Customer Connection > Support > Documentation > Ordering PeopleBooks. Requires account/password (Requires Customer Connection login.)
Also available online at peoplesoftcity.com: SQR for PeopleSoft version 8.4 Developer's Guide and Language Reference

PeopleSoft > Customer Connection > Support > Troubleshooting > Tips > SQR Answer Book Requires account/password
Covers Process Scheduler configuration, process security, printing configuration, debugging tips, common errors and other information. For PeopleSoft releases 6.x, 7.x and 7.5x. (Requires Customer Connection login.)



read
lookup

SQR-related publications

SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8
By Galina Landres and Vlad Landres

Harnessing SQR
By Darrin Miller   Contents | Order

SQR Programmer Reference, Second Edition
By Don Mellen

PeopleSoft 8.4 SQR Cheat Sheet
By Joseph Weessies


Related Titles

Essential Guide to PeopleSoft Development and Customization
By Tony DeLia, Galina Landres, Isidor Rivera and Prakash Sankaran

PeopleSoft HRMS Reporting
By Adam T. Bromwich



#debug
show

SQR tools

Axis Computer Consulting Services > Downloads > Source Code > SQR/SQC
A number of SQR tools for printing, creating SQL, and scanning PeopleSoft databases.

Ray Ontko & Co. > Library > SQR Library
Editor configuration files, SQR utilities, SQR procedure libraries and links.

PSoftPros > Scripts > SQR Page 1 | 2 | 3
Many SQR code samples and utilities.

SQR Tools
Includes a function library and two code analyzers, along with other SQR information.

SQR Users Group > Library
Sample code and tools.

SqrParser Plugin for the jEdit Editor
Parses SQR programs to produce a structure tree.

SQR Tree
Produces an expandable tree of procedures and included files.

SQR to XML Spreadsheet
Library of SQR procedures to create Excel spreadsheets (including formulas and cell formatting) from within SQR programs.

SP Debugger for SQR
A GUI-based, interactive SQR debugger.

List your products on sqr-info.com!



begin-setup
end-setup

Consultants and integrators

SparkPath Technologies, Inc.
Provides PeopleSoft and SQR technical development and support.



begin-select
end-select

Contracting and employment

Yahoo! Groups > SQR Jobs Group
A less-active, unmoderated email list for posting SQR-related resumes, project announcements, job announcements, help-wanted and work-wanted ads.

Protallian Resources
A community of independent contract consultants, including SQR developers. 2 sites: For contractors | For clients



begin-program
end-program

Getting started with SQR

The SQR Evangelist
Why use SQR? One guru's experiences. Ask the SQR Evangelist.

Hyperion Developer Network > Tech Doc > Getting Started with SQR (Release 8 | 8.1 | 8.2 | 8.3)
An extensive, detailed tutorial for Hyperion SQR.

CodeFactory > SQR tutorial
A quick, basic tutorial with an emphasis on report output.

Also see Publications



evaluate
end-evaluate

Related links

SQR Integrator: Turn your SQR platform into a powerful data warehousing environment

Application development-related links

Trade a link with us



begin-footing
end-footing

About sqr-info.com

Site ©2004-2007 SparkPath Technologies, Inc. and its licensors. All rights reserved.
This site is not affiliated with Oracle Corp.



Terms of use




ask
Technical topics
from SQR forums & blogs

Visit our
Specific SQR Topics page
 


#define

What is SQR?


Hyperion SQR, from Hyperion Solutions Corp., is a powerful and flexible programming language.

SQR generates presentation-quality reports for distribution through the web or via various file formats. While best known for its robust enterprise reporting capabilities, it also provides general-purpose procedural programming functionality useful for high-volume database/file access and updates. SQR runs on multiple database and operating system platforms.

In 2007, Hyperion was acquired by Oracle Corp.  SQR and programs developed using SQR are also delivered with PeopleSoft solutions from Oracle. PeopleSoft (which also has been acquired by Oracle) purchased rights to the SQR source code and maintained its own version of SQR. Almost all of the SQR coding-related information here and elsewhere on the internet will apply to both versions.

The PeopleSoft version is not sold separately. The name "SQR" has been largely retired from the Hyperion version; it is now simply a part of the Production Reporting component of Hyperion System 9.