Re: printing in Brio, Brio/ASP problem

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

You could try using the chr() function. For example when I am working in ASP
and I want to delimit a text field that has an apostrophe in it like
O'Kelly, I will delimit it with chr(39) rather than "'". The same kind of
thing might just work with the ampersand, since in vb script it is the
concatenation char.

ac

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Sarah Urbanowski
Sent: Thursday, November 01, 2001 2:59 PM
To: SQR-USERS@list.iex.net
Subject: printing in Brio, Brio/ASP problem


I am having a couple of problems with Brio...

The first is with printing - some of the reports I have created display a
little picture of a printer at the top when the report is in preview or
print preview, and you can click on the printer and the report prints in
pdf format.  I did not put any code specifically for this, I believe Brio
formatted it this way.  Some of the reports do not have the picture of the
printer, and I don't know how to make it appear.  Here is an example of the
code:

Begin-Setup
 Declare-Layout Default
  Orientation = Landscape
  Paper-Size = (Legal)
  Top-Margin    = 0.500
  Bottom-Margin = 0.500
  Left-Margin   = 0.500
  Right-Margin  = 0.500
  Line-Height = 1
  Char-Width  = 1

 End-Declare

 Declare-TOC Default
  Entry = VS_TOC_Proc
 End-Declare

End-Setup

Begin-Heading 24 For-Tocs=(default)
  Graphic (21,1,936) Horz-Line 20
 Alter-Printer Font=901 Point-Size=16    ! [SQR.INI] 901=MS Shell
Dlg,proportional
 Print 'Table of Contents' (16,807,17)
   Print-Direct printer=html '%%TOC-Title Table of Contents'
 Alter-Printer Font=901 Point-Size=10
End-Heading

Begin-Procedure VS_TOC_Proc
   Print-Direct printer=html '%%ResetColor'
   Print-Direct printer=html '%%ResetBorder'
 Alter-Printer Font=901 Point-Size=10    ! [SQR.INI] 901=MS Shell
Dlg,proportional
 Let #indent-size = 24
 Let #indentation = 1 + (#indent-size * (#sqr-toc-level - 1))
 Print $sqr-toc-text (12,#indentation)
 Print #sqr-toc-page (12,523)
 Next-Listing Skiplines=4 Need=14
End-Procedure

Begin-Program
 Use-Printer-Type html
 Do Get-Input


Does anyone know what I am missing?  I have this same code in a report
where the printer does work, so I don't know what the problem is.



The second problem I am having is with passing parameters between an ASP
page and the Brio report.  Specifically the problem is when one of the
fields being passed has an '&' in it.  The '&' works fine just in Brio, so
that's why I assume the problem is with passing the fields.  For example:

http:
//nbrws1201/servlet/WebClient/run/MCD/hours%20by%20gfr%20line%20item?Param_1

'Total%20Career%20Development'&Param_2='Finance%20'&Param_3
='Financial%20Forecasting%20&%20Planning'&Param_4=2001

I think the '&' in &Param_3 is being confused with the '&' in
(Financial%20Forecasting%20&%20Planning').  It is being passed as below,
for example in &Param_3, so I don't know even know how you can tell there
is an '&' in it before you even pass it, or what you could do about it if
you did know:

<form action="http://nbrws1201/servlet/WebClient/run/MCD/hours by gfr line
item?Param_1='<% = rtrim(GFRSearch)%>'&Param_2='<% = GroupSearch %>'
&Param_3='<% = TeamSearch %>'&Param_4=<% = FYSearch %>" method="post"
target="_top" id=form1 name=form1>

Do anyone have any ideas on either of these things?


thank you!
Sarah



This message is for the designated recipient only and may contain
privileged or confidential information.  If you have received it in error,
please notify the sender immediately and delete the original.  Any other
use of the email by you is prohibited.