[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Rép. : [sqr-users] Newbie Question
- Subject: [sqr-users] Rép. : [sqr-users] Newbie Question
- From: LEBLANC Philippe FTC <p.leblanc@francetelecom.com>
- Date: Fri, 27 Feb 2004 18:21:42 +0100
- List-id: This list is for discussion about the SQR database reporting language from Hyperion. <sqr-users.sqrug.org>
See example below:
==================================
Begin-Setup
Declare-Printer Printer1
for-reports = (Report1, Report2, Report3)
type = hplaserjet
point-size = 8
font = 1
End-Declare
Declare-Report Report1
layout = Layout1
printer-type = hplaserjet
End-Declare
Declare-Report Report2
layout = Layout1
printer-type = hplaserjet
End-Declare
Declare-Report Report3
layout = Layout1
printer-type = hplaserjet
End-Declare
Declare-Layout Layout1
paper-size = (12, 8.5) ! A4 (11.69, 8.27)
char-width = 5
line-height = 8
orientation = landscape
End-Declare
End-Setup
(...main procedure...)
! INITIALISATION DU RAPPORT D EDITION
Use-Report Report1
Alter-Printer point-size = 8
New-Report $EtatStatistiques
...
! RAPPORT No1
Use-Report Report2
Alter-Printer point-size = 8
New-Report $ListeIncoherences1
...
! RAPPORT No2
Use-Report Report3
Alter-Printer point-size = 8
New-Report $ListeIncoherences2
...
(your procedure begin-select)
...
! Edition de donnees pour le rapport2 (ex: master report)
Use-Report Report2
...
! Edition de donnees pour le rapport3 (ex: detail report)
Use-Report Report3
...
! CLOSE RAPPORT No2
Use-Report Report3
New-Report 'CloseCurrentReport'
! CLOSE RAPPORT No1
Use-Report Report2
New-Report 'CloseCurrentReport'
...
! EDITION DU TABLEAU DES STATISTIQUES (ex: counts or errors ...)
Use-Report Report1
Alter-Printer point-size = 8
...
(your print procedure)
...
! CLOTURE DU FICHIER D EDITION DU TABLEAU DES STATISTIQUES
Use-Report Report1
New-Report 'CloseCurrentReport'
==================================
beware the use of these line to control the font size !!!
Alter-Printer point-size = 8
==================================
Je reste à votre disposition pour toute demande d'information complémentaire.
Cordialement, Philippe LEBLANC
France Télécom Câble
Direction Informatique
Cellule Finances & Statistiques
Assistance centralisée: 01.55.58.36.00
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users