[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Re: sqr-users Digest, Vol 6, Issue 18
- Subject: [sqr-users] Re: sqr-users Digest, Vol 6, Issue 18
- From: Krishna <knookula@yahoo.com>
- Date: Thu, 26 Aug 2004 14:49:14 -0700 (PDT)
- Delivery-date: Thu, 26 Aug 2004 16:50:19 -0500
- In-reply-to: <E1C0I5N-0003sS-00@seldon.sqrug.org>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
MY REPORT BUILDER version on Windows NT is 6.1.3 (Build 90)
This is the Declare-Layout Code that I have in my Begin-Setup Block of code.
SQR version installed on SUN Server is SQR 4.3.4/SUN/SUN OS 5.5.1/ Oracle 8.1.7
Code Snippet:
Begin-Setup
Declare-Layout Default
Paper-Size = (Letter)
Orientation = Portrait
Top-Margin = 1.00
Left-Margin = 0.5
Line-Height = 1
Char-Width = 1
Max-Lines = 666
End-Declare
Declare-Variable
Text $l_month
TEXT $report_run_dt
TEXT $report_nm
Integer #scrn_tot
Integer #inv_tot
Integer #intake_tot
End-Declare
End-Setup
I have written several reports every other report works fine except this one
which I am having problem with. There are no error logs when the code is either
manually run or scheduled through Unix cron.
I really don't know what to do...??
Message: 4
Date: Wed, 25 Aug 2004 18:05:09 -0400
From: "Robert K. Foster"
Subject: [sqr-users] RE: Generating a Report
To: sqr-users@sqrug.org
Message-ID: <412D0D15.5020303@radiology.msu.edu>
Content-Type: text/plain; charset="us-ascii"
It seems possible that you have a different version of SQR running on
the Sun box. I use a bourne shell script to setup the environment and
then execute the SQR. This allows me to use two different versions of
SQR. That maybe what is going on.
Bob.
sqr-users-request@sqrug.org wrote:
> Subject:
> [sqr-users] RE: Generating a Report
> From:
> Krishna
> Date:
> Tue, 24 Aug 2004 12:30:39 -0700 (PDT)
> To:
> sqr-users@sqrug.org
>
> To:
> sqr-users@sqrug.org
>
>
>Hello there,
> Can anyone please tell me why is SQR when running in Report Builder generates
>a report using the layout declared in the Declare-Layout section of the code,
>but when I copy the same code to unix Sun Server and execute the report on the
>sun box, the report gets generated but the data is not formatted and on the
>other hand it does not print any graphics like horizontal and veritcal lines
>that I am drawing in the report. Your immediate input is highly appreciated. I
>looked into the manuals, and could not find anything which could help me out.
>I am sure that some users may have faced the same problem, your solution is
>greatly appreciated.
>Thank You
>Kris
>
>
-------------- next part --------------
Here was a non admissible message part of 'text/x-vcard' MIME type. It
has been automatically discarded before sending the message to the
list.
---------------------------------
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users