Here is the rest:
begin-procedure subquery4cust
begin-select
!field to select that select 1 retrieves...
from sales_dim a, customer_tracker b
where b.sales_date >= to_date('01/16/01','mm/dd/yy')
and b.sales_date < to_date('01/17/02','mm/dd/yy')
and b.sales_id = a.sales_id
and...
Try something like this:
begin-program
do cust
end-program
begin-procedure cust
begin-select
yy.customer_id ()
yy.sales_amount ()
do subquery4cust
from sale_dim xx, customer_tracker yy
where yy.sales_date >= to_date('04/16/02','mm/dd/yy')
and yy.sales_date <...
Does anyone know if it is possible to use recursion in Brio procedures?
I have attempted this, but the next function call removes any record of the previous instance of the procedure that called it.
I need it to represent a parent-child self referencing table structure, so I can generate a...
When I use Brio Report's Table of contents command
TOC-Entry Text = &bName level=1
the following html is generated.
table cellpadding="0" cellspacing="0" border="0" height="200"><tr><td><font size="1"> </font></td></tr></table>
<a...
I would expect to specify a parameter such as
ask NumberID
I would then expect to use it by including the parameter for {NumberID} when the Brio Report is called.
SQR myreport.sqr connectivity flags 78
where 78 is the required value for NumberID
I hope this helps, At least with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.