Joanne McCoy's Page

"Wow, that's a clever trick I didn't know about.  Thank you, thank you.  That will make life a whole easier."

"Thanks for the reply Stephen.  That has clarified a lot of things for me.  I wasn't sure how the Report Manager tied in with Sage Intelligence.  I think I will use the Report Debugger a lot in future, so thanks for the heads…"

"Sure Lara It is joanne.mccoy@optusnet.com.au Thanks joanne"

"The way that Sage Intelligence (Alchemex) is designed, the join part of the query is typically handled in the container via the Connector module. To apply group by clauses automatically to your query, you can select the relevant column in the…"

"Hi, You cannot have it refering the same name twice, use alias for the table names Option 1: trade LEFT JOIN trans transOrder ON trade.intordref = transOrder .internref   (to get some order info) LEFT JOIN trans transInv ON trade.intinvref =…"

"Hi Joanne, can you giveme your mail address again, I need to get some info from you and the one you gave me over the phone looks like I took it down wrong :( Thanks, Lara"

"What does the error look like & what were you doing when it occurred?"

"I was trying to use SQL in the Administrator.  I couldn't get round the duplicate JOIN error.  Is there something I have missed?"

"Hi Dave Thank you.  I have gone with the 2 separate containers option and it has worked well. Thank you for the help"

"Another options is, instead of using Graphic Join when creating container, you can try SQL join.  "

"Ah, that is different.  You have a couple of choices.  You haven't mentioned which software you are pulling from  but I mainly write from Peachtree so I will assume your structure is as wierd as mine.  If you have a way to…"

"Hi Dave Thank you for your reply.  Unfortunately I am not wanting to join two tables with two fields.  I am needing to access the same transaction table two separate times - once to get order transaction details and another time to get…"

"Hi Dave Thank you for your reply.  Unfortunately I am not wanting to join two tables with two fields.  I am needing to access the same transaction table two separate times - once to get order transaction details and another time to get…"

"I think the reason  SUM(trans.amount5) AS TotPaidAmount gives a zero amount in the last GROUP BY clause is because the trans table is not referenced in the LEFT JOIN instruction. If anyone has more insight it would be much…"

"Hi  I have found the best way is to create 12 fields in Admin - one for each month.  Once you have the 12 fields, it is easy to display them side by side in Excel. Get the correct value into each month by using the following code as an…"