Liveware Publishing Support Forum

Thanks Kathleen,____Your suggestion gave me the syntax that I^ve actually ended up using to create a view within the database, that way the users will find it easier to report on too (without the need for additional RnR knowledge).____Thanks,__Nick

[updated:LAST EDITED ON Jun-30-03 AT 12:26 PM (EST)]Sorry Kathleen, I didn^t say, I^m using SQL version 9.0.007 over Oracle, does this alter your solution?__I^ve never heard of a master FILE before, scope is something I^ve never come across, and I^ve never seen a relation type ^scan^ either. I ...

Hi, I have a client who needs a particular report, and I can^t get my head around the grouping...____One table (LINKS) holds activity records including amongst others unique reference (LINK_NO) and outcome code (LNKOUTM_COD), the other (LNKOUTM, which I assume I will have to join to) holds unique re...

Sorry, I think I posted this in the wrong area initially, anyway, here goes...____Have just started working again at a client site and have discovered that they have installed RnRv9 (replacing Arpeggio). Unfortunately all of their reports are at the moment held within .rp6 libraries, which means tha...

Have just started working again at a client site and have discovered that they have installed RnRv9 (replacing Arpeggio). Unfortunately all of their reports are at the moment held within .rp6 libraries, which means that I cannot now edit reports and save back into the libraries.____Is there any way ...