Recent content by KBHere

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=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; height=&quot;200&quot;><tr><td><font size=&quot;1&quot;>&nbsp;</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...