Re: MANY questions about SQR / Portal

[Paul Hoyte <phoyte@SHARIDIONNE.COM>]

Lets give this a shot....

1.  I don't know of a way to hide or suppress the production of the SPF file
in the portal.  We tried to do this a a class recently and found that the
Portal JF is defaulting to using the -keep parameter which will
automatically produce the spf file.  Would have to change portal internally
to keep the spf from being produced.
2. If you do not have the PDF fonts defined in the SQR.ini file with the
same font number as the HTML section, then you will get the default PDF font
which if I remember correctly is Courier.
3. Just completed an assignment using SQL Server7 and Sqr 6 and it worked
fine.  Use the *= or =* to indicated the left or right outer joins. EG And
PERSEXTRNL.RELATION_CD *= CODESET.ID.  Can't use the same table however in a
join to another.
4. Dr. Watson appearances require a little more research with a lot more
information.  One thing to look at is to make sure that you are authorized
to execute the procedure.
5. The DDO interface is the way to connect to Essbase.  Don't have a sample
program handy but you might want to check with the developers at your home
office for some pointers....
7. Another idea is to make a gif file for the square and then use the
precision printing to position the square and them print the number inside
of the square.

That's all for now.....

Paul Hoyte
Sharidionne, Inc.
(248) 559-6868
www.sharidionne.com
phoyte@sharidionne.com

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Nicolas Moscaritolo
Sent: Sunday, April 08, 2001 9:34 PM
To: SQR-USERS@list.iex.net
Subject: MANY questions about SQR / Portal


If you can point me in the right direction on ANY of these items, that would
be great.

1. How can I hide the SPF file in the Portal. Currently, (by default), when
an SQR job runs, it displays the HTML and the SPF.

2. PDF and fonts. I created an SQR program to produce a simple report. When
I also had the SQR create a PDF, the fonts I had in the HTML did NOT show up
in the PDF. Any ideas.

3. Using SQL Server and SQR 6.0, I could not get the LEFT JOIN to work. The
client said that SQL Server takes ANSI SQL and therefore SQR is expected to.
I am used to Oracle so the only join clause I've seen is Oracle style.

4. I tried to execute a SQL Server Stored Procedure using SQR 6.0. When I
did (either through ReportBuilder or SQR Server), Dr. Watson paid a visit
and it blew up.

5. Essbase and Oracle. What does the code look like. I assume that we would
use DDO. A sample program would be great !!!!!

6. Creating an HTML doc from SQR 6.1.3, I coded links and anchor within SQR.
When I click to link to an anchor and then click another link to go back to
the top (and anchor), the VCR controls in the top HTML frame are gone. How
do I get them back?

7. I would like HTML output. The layout has a number within a box. The
number needs to be centered within the box and the box needs to be a
standard width (not the width of the number). It seems that doing this with
the HTML SQR tags is the only solution. Any other ideas?

8. CHARTS with color. I created a chart in SQR with a legend. Using the
Create Pallete command, I created many colors to represent each bar within
my graph. The legend came out fine with the proper colors but the bars in
the graph all came out red. Any ideas?


Enough question for now. Thanks for your attention to these issues.

I will be working on these issues and would appreciate ANY feedback on ANY
issues and/or SAMPLE CODE. I will re-publish the answers once I solve each
for everyones benefit.

Thanks

Nick Moscaritolo
Brio Technology
Systems Consultant
15 Crestwood Drive
Ashland, MA 01721
(617) 823-6783