Re: Multiple querys in a report - is it possible?

[Juan Alvarado <juan@GYSSA.COM.GT>]

In Brio Report Builder (visualSqribe) you can multiple querys via
subquerys.  But Always have only one principal query.  But in Brio
Report Builder 6.0 you can have many master querys like you want.

In the language sqr you can have many querys as you like.

Juan Manuel Alvarado
E-BUSINESS UNIT
Brio/Microsoft
Gerencia & Sistemas , Guatemala

"E-SPC IS E-BUSINESS"



-----Original Message-----
From: Prince, Paul [mailto:Paul.Prince@TRILLIUMGRP.COM]
Sent: Tuesday, June 13, 2000 1:22 AM
To: SQR-USERS@list.iex.net
Subject: Re: Multiple querys in a report - is it possible?


I'm not sure if this helps as I've not used 5.1 however, I've done this
many
times in SQR4/Oracle

Build a second (third, fourth ......etc) in a separate procedure then
call
them in order from your program.

You can also nest the second query in the first by calling the second
procedure from within the first (between the selected columns and the
where
clause).

When nesting the 'do procedure_name' don't forget to indent it from the
margin.

Regards,

Paul Prince
paul.prince@trilliumgrp.com

> -----Original Message-----
> From: Davi Cabral [SMTP:dcabral@RECSA.COM.BR]
> Sent: 12 June 2000 21:08
> To:   SQR-USERS@list.iex.net
> Subject:      Multiple querys in a report - is it possible?
>
> Dear Sirs,
>
> windows / Sybase / Brio Report Builder v. 5.1
>
> I need to put two separated querys in a same report with the
VisualSQRibe
> 5.1 (Brio Report Builder).
>
> Is it possible or not? How can I do it?
>
> Thank you for the attention.
>
> Davi


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.trilliumgrp.com
**********************************************************************