This would most likely be due to User Access Control being active on the machine.
Please have a look at the below links to see the issues that this could cause (yours being one of them):
- Understanding UAC
- UAC in Vista
- UAC in…"
This could be as a result of the companies not being in the Tenant cache or in the consolidation list.
If they do not display in the Tenant Cache (check by opening Report Manager, click on Tools and thereafter "Tenant Cache"…"
Connecting Excel to a DB to capture an image may not work unless the file type is recognized by Excel.
Excel natively understands raw data and as a result, this connection would most likely result in some scrambled characters being displayed…"
You'll have to get Sage Intelligence to output the data you need to Excel as Crystal Reports and Sage Intelligence do not exchange data.
You'll need to add a query in the Connector module to pull the data you wish to see in the…"
Do these invoices exist in the raw data brought back from the system?
It could be that the underlying data isn't available...You can check this by unhiding the data sheets in Excel and looking for those specific invoices.
If the data…"
That certainly is strange!
I'd recommend contacting your ERP support desk to assist with this as there's definitely something weird going on.
Out of curiosity, is the company name exactly the same as it appears in the tenant cache…"
You'll firstly need to know were (which table) this data is contained and thereafter write the relevant SQL to extract that data. This can also be done by creating a container in the connector module and adding the table were all…"
The company would need to be in the tenant cache for this to work as the transaction drill-down queries the DB with supplied parameters.
You'll be able to see if this exists by opening Report Manager, clicking on the "Tools"…"
This can be achieved by use of a "pass through variable" in your container. You'll can use this variable to filter data in the report to a specified date range. You can find more information on how to set this up at the below…"
The only way to do this without the Connector module would be to create a Union report were one of the Standard reports contain the PO number.
Have a look at the link below for free additional reports which may help surface the PO…"
I had a look at the .tre file and the contents was corrupt. I've managed to fix the .tre file which should eliminate the error you've been experiencing as Sage Intelligence should now identify the file as a report tree.
The easiest way to get this back would be to go into Excel and click File>>Options>>Add-Ins.
Select Excel Add-Ins in the "Manage" drop down at the bottom of the page and click "Go...".
Look for the…"
The best people to answer this would be the Pastel Partner team who you can contact on 011 304 3000.
This forum deals with Sage Intelligence related issues exclusively and as such, would not have the specific information you…"