Prabha VIRAH SAMMY
  • Female
  • Lethbridge
  • Canada
Share

Prabha VIRAH SAMMY's Groups

Prabha VIRAH SAMMY's Discussions

Unable to get add property of the workbooks class
2 Replies

Hi,I know there is a thread about this from 2013 and I used the fix suggested but it seems to fix the problem and then when the user runs the report, it breaks again. So that the user would have to…Continue

Tags: BI, 2018, 300, sage, Excel

Started this discussion. Last reply by Prabha VIRAH SAMMY Dec 15, 2017.

Extracting data from an Excel file
3 Replies

Hi everybody,I have only worked with SQL databases to generate BI reports. Is it possible to extract data from an Excel file to generate a BI report?If yes, can you please tell me what I would need…Continue

Tags: workbook, Excel

Started this discussion. Last reply by Prabha VIRAH SAMMY Jul 7, 2016.

Automatically send a report to every salesperson about their orders
4 Replies

Hi,I need to automate a report which need to be emailed to each salesperson. Just gives them details of their orders from the current date to last year that same date.The report will be run every…Continue

Started this discussion. Last reply by Shwu Hua Gan Mar 22, 2016.

Automation Error
5 Replies

Hi,I have a report which uses a view. That report has been working fine for a couple of years now and suddenly I get an "automation error" after the "rendering data" line. Then a little window pops…Continue

Started this discussion. Last reply by Prabha VIRAH SAMMY Jun 2, 2015.

 

Prabha VIRAH SAMMY's Page

Latest Activity

Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"That's awesome Shane! My client does not have that update on his machine. Tried to uninstall a couple of other updates related to VB Basic since that is the first error that comes up before the "property" error but still no-go. Even…"
Apr 24
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"It does not look like anybody from Alchemex is looking into this issue. :( I still have not provided a fix to my client and I posted into the forum last year."
Apr 12
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Still no resolution found."
Jan 4
Prabha VIRAH SAMMY replied to Prabha VIRAH SAMMY's discussion Unable to get add property of the workbooks class
"Well it works fine on another computer so got me a little bit stumped. Tells me it has something to do with Excel or his environment."
Dec 15, 2017
NATE replied to Prabha VIRAH SAMMY's discussion Unable to get add property of the workbooks class
"Good day This seems like an issue with the template itself as there should not be a reason for you to run te fix more than once. "
Dec 15, 2017
Prabha VIRAH SAMMY posted a discussion

Unable to get add property of the workbooks class

Hi,I know there is a thread about this from 2013 and I used the fix suggested but it seems to fix the problem and then when the user runs the report, it breaks again. So that the user would have to run the fix each time he wants to run the report.This is only happening on one machine. Not sure if it was a Microsoft update or something.What are your recommendations?Thank you.See More
Dec 12, 2017
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"So I spoke too soon yesterday. It seems that the fix fixes the issue and the report runs the first time. If you run it the second time, it gives you same error."
Dec 9, 2017
Prabha VIRAH SAMMY replied to Michael Davis's discussion Unable to get Add Property of the Workbooks Class
"Helped me!"
Dec 7, 2017
Prabha VIRAH SAMMY replied to Prabha VIRAH SAMMY's discussion Extracting data from an Excel file
"Thank you guys! Will use the BI connector for Excel as Nanah and David suggested."
Jul 7, 2016
David Bryant replied to Prabha VIRAH SAMMY's discussion Extracting data from an Excel file
"- You will need to use the ODBC Driver for excel (within the connector) - Make sure your excel file with the data has named ranges (the connector will then assume them as tables) - Using the driver, browse to the excel file - Choose to add a data…"
Jul 7, 2016
nanah replied to Prabha VIRAH SAMMY's discussion Extracting data from an Excel file
"hi Prabha, have you tried connecting your database into the connector module, once you have done that import a report against your new connection? thanks"
Jul 5, 2016
Prabha VIRAH SAMMY posted a discussion

Extracting data from an Excel file

Hi everybody,I have only worked with SQL databases to generate BI reports. Is it possible to extract data from an Excel file to generate a BI report?If yes, can you please tell me what I would need to have? The client has the full Sage BI package - connector, analysis and report designer.Thank youPrabhaSee More
Jul 4, 2016
Shwu Hua Gan replied to Prabha VIRAH SAMMY's discussion Automatically send a report to every salesperson about their orders
"Hi Prabha, This is what I have done where we need to email each salesrep their allocated invoices. 1. In Sheet 3, I have all the AR Sales invoices and there is a salescode related to each sales rep. 2. Let's say I have Sales Rep Peter and…"
Mar 22, 2016
Peter Scully replied to Prabha VIRAH SAMMY's discussion Automatically send a report to every salesperson about their orders
"Hi Prabha. I don't think there's a more elegant solution than the one in Carmen's webcast. One idea I had though is that if you trust your Sales Reps not to be too concerned with each others information then you can create one…"
Mar 18, 2016
Prabha VIRAH SAMMY replied to Prabha VIRAH SAMMY's discussion Automatically send a report to every salesperson about their orders
"Great video! very helpful. BUT That means all of the salespersons need to be setup in advance on the workbook. If they add a new salesperson you would have to fix this report and add another worksheet for the new salesperson and go through the whole…"
Mar 17, 2016
Chloe replied to Prabha VIRAH SAMMY's discussion Automatically send a report to every salesperson about their orders
Mar 17, 2016

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Accpac Intelligence
Website
http://www.asyma.com
About Me:
Certified Sage Accpac and Sage CRM consultant
How long have you been using the above solution?
1 year
Where did you hear about us?
Search Engine

Comment Wall (1 comment)

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

Join The Sage Intelligence Community

At 11:19am on June 24, 2011, Ruth Gray said…

Hello and welcome to the BI Community. For access to videos, user guides, data dictionaries and much more. Join the Sage ERP Accpac Intelligence Group. http://community.alchemex.com/group/sageaccpacintelligence

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service