[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] (no subject)
Kathy,
Other than comment line changes and some white-space, the "bar100.sqr" you
provided is identical to mine.
I would suggest you contact PeopleSoft and ask them why the "Declare-Chart"
command is not functioning properly.
Peter
-----Original Message-----
From: Kathy Mason [mailto:masonk@evergegroup.com]
Sent: Wednesday, May 28, 2003 12:23 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] (no subject)
Peter,
Here is an example of an SQR that is failing. This is a sample SQR -
bar100.sqr from the samplew directory. This error log is very similiar for
any sqrs I have tried to run that contain charts. The log listed below is
followed by the SQR.
Thanks for any help you might give.
Kathy
SQR Log
Error on line 67:
(SQR 3503) Unknown variable type.
Chart-Size = ( 50,50)
Error on line 68:
(SQR 3701) Invalid command.
Title = 'Employee Sales'
Error on line 69:
(SQR 3701) Invalid command.
Type = 100%-bar
Error on line 70:
(SQR 3701) Invalid command.
3D-Effects = yes
Error on line 71:
(SQR 3701) Invalid command.
X-Axis-Label = 'Employees'
Error on line 72:
(SQR 3701) Invalid command.
Y-Axis-Label = 'Sales (in thousands)'
Error on line 73:
(SQR 3701) Invalid command.
End-Declare
Error on line 95:
(SQR 3503) Unknown variable type.
Print-Chart emp_sales_chart (#y, #x)
Error on line 96:
(SQR 3701) Invalid command.
Fill = color
Error on line 97:
(SQR 3701) Invalid command.
Sub-Title = '100% Bar-Chart: bar100.sqr'
Error on line 98:
(SQR 3701) Invalid command.
Data-Array-Row-Count = #row
Error on line 99:
(SQR 3701) Invalid command.
Data-Array-Column-Count = #col
Error on line 100:
(SQR 3701) Invalid command.
Data-Array-Column-Labels = ('Jun', 'Jul', 'Aug')
Error on line 101:
(SQR 3701) Invalid command.
Data-Array = emp_sales
Errors were found in the program file.
SQR for PeopleSoft: Program Aborting.
Here is the SQR - BAR100.sqr
! bar100.sqr
! Demonstrates Chart Printing; Chart Type: 100% Bar Chart
!
! Copyright (C) 1994-2000 Brio Technology All Worldwide Rights Reserved
!
! Disclaimer:
!
! This program is provided as an example and, while it is thought to be
! free from defect, Brio Technology makes no representations or war-
! ranties, either expressed or implied, with respect to the adequacy of
! the program in regard to merchantability or fitness for any particular
! result. The program is provided "as is" and the entire risk as to
! quality and performance is with the buyer. In no event shall Brio
! Technology be liable for special, direct, indirect or consequential
! damages resulting from any defect in this program. Some states do not
! allow the exclusion or limitations of implied warranties or liability
! for incidental or consequential damages, in which case the above
! limitations and exclusions may not apply to you.
!
!***************************************************************************
!
! Modification History:
!
! Date Eng Description
! -------- ---
------------------------------------------------------------
! (_V3.0.1_)
! 09-18-94 RMV (DEV-3191)
! o Inception
! (_V3.5.4_)
! 04-03-96 PAB (DEV-4088)
! o Cleaned up the modification history.
! (_V4.1_)
! 07-28-97 BDC (OH-B006)
! o Header modification
! (_V6.0_)
! 01-05-00 PAB (OH-9795)
! o Change ending copyright year to 2000.
! (_EOH_)
!***************************************************************************
Begin-Setup
Declare-Printer Default-ps
Color = yes
End-Declare
Declare-Report Default
Printer-Type = ps
End-Declare
Declare-Layout Default
Max-Lines = 62
Left-Margin = 0.10
Right-Margin = 0.25
End-Declare
Create-Array ! This Array is passed to the Print-Chart
Name = emp_sales
Size = 20 ! Maximum of 20 rows of data
Field = col_name:char:1
Field = sales:number:3 ! Fields in each row
! Declare-Chart is not necessary to print a chart. However, it can be used
! as a template and its properties can be modified in each Print-Chart
! that uses this chart name.
! NOTE: Declare-Chart must physically preceede Print-Chart
Declare-Chart emp_sales_chart
Chart-Size = ( 50,50)
Title = 'Employee Sales'
Type = 100%-bar
3D-Effects = yes
X-Axis-Label = 'Employees'
Y-Axis-Label = 'Sales (in thousands)'
End-Declare
End-Setup
Begin-Report
! Load the array with the Chart Data. Max rows is specified in Create-Array
Put 'Madeline' 10 12 12
Into emp_sales(0) col_name(0)
sales(0) sales(1) sales (2)
Put 'Jacob' 25 35 45
Into emp_sales(1) col_name(0)
sales(0) sales(1) sales (2)
Put 'Evan' 18 28 38
Into emp_sales(2) col_name(0)
sales(0) sales(1) sales (2)
Put 'Claire' 60 70 80
Into emp_sales(3) col_name(0)
sales(0) sales(1) sales (2)
Move 10 TO #x
Move 5 TO #y
Move 4 TO #row
Move 4 TO #col
Print-Chart emp_sales_chart (#y, #x)
Fill = color
Sub-Title = '100% Bar-Chart: bar100.sqr'
Data-Array-Row-Count = #row
Data-Array-Column-Count = #col
Data-Array-Column-Labels = ('Jun', 'Jul', 'Aug')
Data-Array = emp_sales
End-Report
Kathy
-----Original Message-----
Kathy,
Which sample is failing? Please attach the .SQR and the .LOG/.ERR files.
Peter
_______________________________________________
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