MANY questions about SQR / Portal

[Nicolas Moscaritolo <Nicolas.Moscaritolo@BRIO.COM>]

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