RE: [sqr-users] setting the path to an image ressource

["Franck Masson" <franck.masson2002@laposte.net>]

If your  image and SQR  program are in  the  same  directory .

cd my_directory
sqr my_report.sqr


If not you can specify a relatif path regarding the location  you  are  when
you run your report.
sample:
/usr/my_project/sqr/my_report.sqr
/usr/my_project/image/image1.gif

cd  /usr/my_job
sqr ../sqr/my_report.sqr  .....
then  in your  sqr code  the path  should  be  ../image/image1.gif

another solution will be  to pass the  "Path" as a parameter of your report.


Franck


-----Original Message-----
From: sqr-users-bounces+franck.masson2002=laposte.net@sqrug.org
[mailto:sqr-users-bounces+franck.masson2002=laposte.net@sqrug.org]On
Behalf Of Marius Giepz
Sent: jeudi 29 mars 2007 15:38
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] setting the path to an image ressource


Andalib Yussuf schrieb:
> What are the steps of compiling and running sqr programs using SQR
> Developer, Activation, Viewer, and Server.  I am just a beginner and
> if I could get some help that would be great.  I apologize for any
> inconvenience to anyone.
>
> Anne
>
>
>> From: "the dragon" <ceprn@hotmail.com>
>> Reply-To: "This list is for discussion about the SQR database
>> reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>> To: sqr-users@sqrug.org
>> Subject: RE: [sqr-users] setting the path to an image ressource
>> Date: Wed, 28 Mar 2007 07:11:57 -0500
>>
>> Try using the complete explicit path in your definition.  Keep in
>> mind, if you do not define a path in your program or the init
>> variables, it has to look *somewhere* for the file, and the most
>> logical place is in the directory for the sqr executable.  Also, if
>> you are using Peoplesoft process scheduler to invoke this sqr
>> program, there is probably a path that needs to be defined in the
>> system.
>>
>> peace,
>> clark 'the dragon' willis
>>
>>
>>
>> PSA: Salary <> Slavery. If you earn a salary, your employer is
>> renting your services for 40 hours a week, not purchasing your soul.
>> Your time is the only real finite asset that you have, and once used
>> it can never be recovered, so don't waste it by giving it away.
>>
>> I work to live; I don't live to work.
>>
>> "Time is the coin of your life. It is the only coin you have, and
>> only you can determine how it will be spent. Be careful lest you let
>> other people spend it for you." -- Carl Sandburg (1878 - 1967)
>>
>> It is impossible to defeat an ignorant man in argument. -- William G.
>> McAdoo
>>
>> Religion is regarded by the common people as true, by the wise as
>> false, and by the rulers as useful. -- Seneca
>>
>> "I distrust those people who know so well what God wants them to do
>> because I notice it always coincides with their own desires." - Susan
>> B. Anthony
>>
>>
>>
>>
>> ----Original Message Follows----
>>
>> Hi there!
>> I am currently working on an invoice layout where I have to embed an
>> image. I do it like this:
>>
>> print-image (30,200)
>>    type=bmp-file
>>    image-size = (150,50)
>>    source='logo.bmp'
>>
>> When I put the bmp file in the same folder as the .sqt then the
>> imageframe is left blank with a cross.
>> The image is only beeing printed if I put the file in SQR's /bin
>> folder. Is there something I have to consider setting the
>> correct path?
>>
>> regards,
>>
>> Marius Giepz
>>
>> ++++++++++++++++++++++++++++++++++++++++++++
>> Marius Giepz
>>
>> _________________________________________________________________
>> 5.5%* 30 year fixed mortgage rate. Good credit refinance. Up to 5
>> free quotes - *Terms
>>
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search
=mortgage_text_links_88_h2a5d&s=4056&p=5117&disc=y&vers=910
>>
>>
>>
>> _______________________________________________
>> sqr-users mailing list
>> sqr-users@sqrug.org
>> http://www.sqrug.org/mailman/listinfo/sqr-users
>
> _________________________________________________________________
> Live Search Maps ? find all the local information you need, right when
> you need it. http://maps.live.com/?icid=hmtag2&FORM=MGAC01
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
I just use sqr reports with the comandline version of sqr. I call it
from a JAVA-App and create a PDF output.
For developement I use SQR-Express. For compilation I just use a simple
batchfile:

set name=%1
@echo %1
set user=...
set pass=...
set base=...

sqr %name%.sqr %user%/%pass%@%base% -f%name.sqt% jobnr  -KEEP -RS



Regarding the image problem, it would not be possible for me to set the
complete path as the report is beeing deployed to different locations on
different systems.
The Hyperion Documentation says:
*The file is assumed to reside in the current directory *or in the
directory where Production Reporting is installed, but the file can
reside in any directory as long a full pathname for the image file is
specified...

this doesnt work for me.

--
++++++++++++++++++++++++++++++++++++++++++++
Marius Giepz
topsystem Systemhaus GmbH
Europark A2
Adenauer Strasse 20
52146 Würselen
Germany
Phone : +49 2405 4670-0
email : mg@topsystem.de
++++++++++++++++++++++++++++++++++++++++++++

_______________________________________________
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