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.
"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.
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
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…"
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…"
"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…"
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…"
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…"
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