"Hi Ruth,
There a 2-3 blank rows at the end of the data. But even removing them and then refresh Pivot Table does not help.
The data did come through to Pivot Table (in Tabular format). I see all data eg:…"
-
Shwu Hua Gan
- Melbourne, Victoria
- Australia
- Blog Posts
- Discussions (95)
- Groups (1)
- Photos
- Photo Albums
- Videos
Shwu Hua Gan's Discussions
Pivot Table Label not displaying
2 Replies
Hi, Job Category Job No AccpacItemNo Job Description SalesAmount OrderAmountMUL B1111 B1111 Job Region B1111 100 …Continue
Started this discussion. Last reply by Shwu Hua Gan May 19.
Alchemex lookup value - is there a limit?
Hi, Does Alchemex has limit of displaying lookup value?I have a lookup value with the following for Sage Accpac Intelligence.SELECT DISTINCT ITEMNO, [DESC] from ICITEM ORDER BY ITEMNOWhen I run the…Continue
Started May 18
Report Designer Container
Hi, I see the similar questions raised in Sage Mas Intelligence and I am facing the same problem in Sage Accpac Intelligence. 1. In order to use Report Designer, must I use the same container for…Continue
Started Apr 27
Using Data Validation - List in Excel 2007
2 Replies
Hi,I have a very simple Excel, which I used Data Validation and Set the List of items to select.See Worksheet "Budget Item" in the attached Excel file.You can see that there is duplicate items.1.…Continue
Started this discussion. Last reply by Shwu Hua Gan Apr 23.
Shwu Hua Gan's Page
Latest Activity
"Is the field coming through and it is blank or is the header Job No not coming through either?
Are there any blanks in your raw data?"
Shwu Hua Gan replied to Paul palmer's discussion date time conversion"Try this.
CONVERT(datetime,CAST([GLPOST].[JRNLDATE] as nvarchar(8)),106)"
Shwu Hua Gan replied to Paul palmer's discussion date time conversion"Which container do you use and what are the fields?
If you are using the standard fields, then you need to check whether those are formula fields that based on Parameter Year and Period.
If so, the error would probably means there is no parameter of…"
Shwu Hua Gan replied to YESHMEETA PETERS's discussion Designing Reports - Error"When you open it up in Excel, did you see the message "Macro has been disable" Enable Content?
If so, click on the Enable Content button."
Shwu Hua Gan replied to Joanne McCoy's discussion How do you add two JOINS to the same table in Administration"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 =…"
Shwu Hua Gan replied to Joanne McCoy's discussion How do you add two JOINS to the same table in Administration"Another options is, instead of using Graphic Join when creating container, you can try SQL join.
"
Shwu Hua Gan posted a discussionReport Designer Container
Hi, I see the similar questions raised in Sage Mas Intelligence and I am facing the same problem in Sage Accpac Intelligence. 1. In order to use Report Designer, must I use the same container for Report Designer that come out from the box or can I create a new container? 2. I have tried with creating a report based on the report that come out of the box and I try to filter with Year, but the only filtering option is Equal to.Why is that so? See More
Edwin replied to Shwu Hua Gan's discussion Pivot Table Sorting"Hi,
Uploading the spreadsheet will help to resolve the issue at hand."
Shwu Hua Gan replied to Shwu Hua Gan's discussion Using Data Validation - List in Excel 2007"Hi Dave,
Thanks for replying.
I used data validation, so that users can select from the list.
However, there will be chances where users could have select one value more than 1 time unknowingly, unless they sort it ascending and…"
Dave Smith replied to Shwu Hua Gan's discussion Using Data Validation - List in Excel 2007"Hi Shwu, When I use Data Validation, the user is free to select from the list and if you use the same list on another Data Validation cell, nothing that I know of would restrict the user from selecting a value the same as the other cell's…"
Shwu Hua Gan replied to Kathy Walker's discussion Steps to Transfer Pre-built reports to Customer"Just a note thou.
If you create the report based on the standard/existing Container and you have added new fields in your Container during the report development, you might receive a message saying that the fields is not…"
Shwu Hua Gan replied to Jaime Schmulson's discussion SAI vs. Crystal performance issues."Hi Jamie,
I think, even that Alchemex turned off all calculations, when you refresh the formula in Excel, it will still take time for populate/update the file.
It is always quicker to have the work done in database level, ie, either base your…"
Shwu Hua Gan replied to Maree Palmer's discussion Accpac AR Invoices and Customer Optional Fields"Have you tried creating SQL expression field using subquery - sql syntax. Note that in your syntax, you need to put in Bracket.
Eg; Create an SQL expression field call OptDistrict
The syntax will be…"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- SAP Business One
- Website
- http://www.microchannel.com.au
- About Me:
- I am a certified SAP Business One consultant and experienced report writing specialist with MicroChannel Services Pty Ltd , which is a leading, multi-award winning business systems solution provider of SAP Business One, Sage Accpac and Microsoft Dynamics GP in Australia.
- Where did you hear about us?
- Other
- If other, please specify
- MicroChannel Services Pty Ltd distribute Sage Accpac and SAP Business One, which works with Alchemex.
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
