Ian Mc Evilly
  • Male
  • Westville, KZN
  • South Africa

Ian Mc Evilly's Friends

  • Krithika Raju
  • Carmen Griessel
  • Learning Services
  • Jaqyc Niemandt
  • Geoffrey Hickley
  • Remon Naidoo
  • Mathew Bland
  • Mike Perks
  • Hal Hiramatsu
  • Glynnis
  • Pielle van Pletzen
  • Deon Nel
  • Roux Crafford
  • Silvan Baard
  • Stephen Coull

Ian Mc Evilly's Groups

Ian Mc Evilly's Discussions

Using VIP Connection with Web Solution
2 Replies

Started this discussion. Last reply by Barbara Willis Nov 12, 2012.


Ian Mc Evilly's Page

Latest Activity

Ian Mc Evilly replied to Johnny Wagner's discussion Project Report (Income v/s Expenses)
"Hi Johnny, I have one that has been used by some clients, you can contact me on ian at repxl.com. Thanks, Ian"
Sep 13, 2016
Ian Mc Evilly replied to Bob Zuckerman's discussion Can I import a report with a modified container to a system that doesn't have the connector module?
"Hi Bob, When you import you may get a screeen saying the conatiner already exists should you use the existing or create a new container, click "NO" to create a new container. Your custom expressions should be there. Thanks, Ian"
Sep 22, 2015
Barbara Willis replied to Ian Mc Evilly's discussion Using VIP Connection with Web Solution
"Thanks Ian, nice to see the solutions posted as well.  "
Nov 12, 2012
Ian Mc Evilly replied to Ian Mc Evilly's discussion Using VIP Connection with Web Solution
"To answer my own question and hopefully help some else. You need to check that the ODBC is NOT using mapped drives and change the path and the search to a UNC path. Once that is done you are sorted. Ian www.repxl.com"
Nov 7, 2012
Ian Mc Evilly posted a discussion

Using VIP Connection with Web Solution

Hi,I am using the Web Solution to connect and run reports out of a VIP Premier db. The reports I created in the report manager and they run out perfectly. When I try run the same report in the Web Solution I get this error message.It was not possible to connect to the database.The error returned was :[Transoft][TSENG32]Cannot open UDD file V:\VIP\odbc\Comp009.uddSQLState = C1000The Alchemex Request Service is using the domain administrator account. The Web Solution and VIP db are…See More
Nov 7, 2012
Ian Mc Evilly replied to Lori Black's discussion E-mail address limit?
"Yes there is a limit have had the same issue. I found it better to setup Groups on your Exchange with relevant addresses in the group.   This Can be easier to maintain."
Sep 23, 2011
Ian Mc Evilly commented on Ruth Gray's group Pastel Accounting Business Intelligence Centre (BIC)
"Great News, Reporting Excellence has officially launched their website, www.repxl.com. We are hosting a collection of reports, for Pastel Partner, looking at different aspects of your business, Purchases and Sales has been our primary…"
Aug 24, 2011
Ian Mc Evilly replied to James Tang's discussion Character Limit on e-mail To Address? in the group Sage ERP Accpac Intelligence
"Hi James, Best to create a group in your Exchange easier to manage then a bunch of names in a text field. There is a limitation not sure how many buts its less the 30 users. I was emailing about 15 when they wanted more I told client to create…"
Jul 7, 2011
Ian Mc Evilly replied to Leon Spies's discussion Custom Report for Pastel Partner - How do I show the Report Date
"Ok not sure if pastel stores desciptions of these periods in a table somewhere. Might be easier to hard code a sheet in the report with 112 | 1 - 28 February then you use a vlookup in excel to get this desciption to your header.   Let me know…"
May 20, 2011
Ian Mc Evilly replied to Leon Spies's discussion Custom Report for Pastel Partner - How do I show the Report Date
"Hi Leon,   You should find your date parameters on sheet2 in the workbook you will also find the time and date when the report was run. Let me know if this helps ?   Regards,   Ian <a…"
May 19, 2011
Ian Mc Evilly replied to Tansy's discussion VBA Code written but not refreshing
"Hi Tansy,   Is your macro running correctly when the report is complete ? The reason it is not refreshing could be either the macro is not executing after the report has finished or a small error in the construction of the macro. To get a macro…"
May 16, 2011
Ian Mc Evilly replied to Diane's discussion Sales Report
"Hi Diane,   There are 3 ways to do this: 1. The Best way (Do it this way when possible) you use Sql to calculate your new field. You will need the connector license to be able to create and manipulate sql expressions.  2. The Excel formula…"
Jan 11, 2011
Ian Mc Evilly joined Geoffrey Hickley's group

Alchemex for Sage 50

Alchemex for Sage 50 (V11 and later) is a software solution, powered by Alchemex, offering Excel based Business Intelligence for Sage 50 Accounts, Accounts Plus and Accounts Professional users.See More
Nov 16, 2010

Profile Information

Where did you hear about us?


Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service