I'm trying to make a printed manifest. It has a header from three or four tables and then down below it has rows of data that are from another three or four tables. If I build it in RunRev I just make individual SQL calls for each element, or sections of elements, store them in arrays or listso of text and put those in different places on the RunRev card as I need them. If something is missing I just do another SQL to get the missing field and put it in. <div>
<br></div><div>The reports feature of Valentina Pro seems to require just one SQL to get every data field you need. I would like to at least divide it into two SQL, one for the header (which doesn't repeat down the page) and one for the repeating elements.<br>
<br><div class="gmail_quote">On Sun, Nov 9, 2008 at 4:12 PM, Ruslan Zasukhin <span dir="ltr"><<a href="mailto:sunshine@public.kherson.ua">sunshine@public.kherson.ua</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
On 11/9/08 10:06 PM, "william humphrey" <<a href="mailto:shoreagent@gmail.com">shoreagent@gmail.com</a>> wrote:<br>
<br>
Hi William,<br>
<div class="Ih2E3d"><br>
> Is there a way to make a report with a collection of multiple SQL instead of<br>
> one long complicated SQL?<br>
<br>
</div>* You mean here new feature Valentina Reports?<br>
or something else?<br>
<br>
* why you think you need complex SQL?<br>
<br>
Please describe your task.<br>
<div class="Ih2E3d"><br>
<br>
> -- ok send me to some WIKI page. I hope there is an example to follow.<br>
<br>
</div>--<br>
Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
<br>
<br>
_______________________________________________<br>
Valentina-beta mailing list<br>
<a href="mailto:Valentina-beta@lists.macserve.net">Valentina-beta@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-beta" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-beta</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><a href="http://www.bluewatermaritime.com">http://www.bluewatermaritime.com</a><br>
</div>