RE: [sqr-users] SQR doubts...

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

1. Begin-program is the newer term for begin-report.  They work the same,
but the vendor (Brio/Hyperion) recommends begin-program.  Begin-document is
completely different; it is for entering text in free-form to be printed.

2. Crystal Reports is strong in formatting reports, with a wysiwyg (what you
see is what you get) graphic, visual development environment.  SQR is a
procedural programming language that is used mostly for reports, but can do
much more.  On the other hand, it is harder to use multiple fonts and
images.

3. Yes.  You can use [$variable] to replace almost any part of any SQL
operation (begin-select or begin-sql).

4. The trick is to pass the information through the command line or to use
different sqc include files depending on the operating system, database
type, or database instance.

-----Original Message-----
From: Vishali Chandramouli [mailto:vichandr@syr.edu]
Sent: Friday, November 21, 2003 8:32 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR doubts...


Hi,
Here are a few basic queries I have.

1. Difference between begin-program, begin-report and begin-document?
2. Major difference between Crystal Reports and SQR - Apart from the fact
that SQR is lot more flexible and Crystal integrates with PSQuery
3. Is it possible to use dynamic column names, and/or dynamic number of
columns in a begin-select?
4. How does a SQR <a> running from Prcs Scheduler <b> Running from Cmd
Prompt know on what OS its running? Basically what I am asking I guess is
how does setenv.sqc or opsys.sqc work. I didnt see anything in pssqr.ini to
show where the OS variable is being set.


Thanks a ton!
Vishali


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users