[sqr-users] (no subject)

["Kathy Mason" <masonk@evergegroup.com>]

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