David Hardcastle's Page

"Any new update on this? I am also experiencing the rutime error. Have you got yours working?"

"Hi Janet, The smtp server for Windows Live issmtp.live.com but because its a web based mail you are going to battle to get it to work as normally it requires a secure connection (SSL) with specific ports which the alchemex email addin does not…"

"Hi Terry,   If you are getting that menu then you are looking at the union report not the child report that it is refering to. if you click on it and look at properties it will indicate the child report id.  in the same folder there is a…"

"Hi Duncan, In the Administrator are you using the auto connection system or have you created another connection? This appears to be an windows authentication problem.  Change the connection to use SQL Authentication and do a test check on the…"

"Also, this error could be as a result of the data not having the same corresponding date records in the Date dimension table.  Did you run the Date dimention tool when setting up the cube?"

"Hi Brentin, Can you run the sales cube report under demonstration in the report manager?"

"Hi Terry,   I got the same error.  I have managed to correct the issue by changing all references to Audit_No to cAuditNumber in the SQL query.  I have not had time to assess what impact it has had on the final results but the…"

"Hi Jason, First thing you need to do is identify the reports your FC pulls from the system to create the reports. This will give you an indication as to where the information is sitting. I would start with the standard Management pack that ships…"

"My pleasure. Regards, David"