"Hello, thank you for this excellent post. I was wondering if you could elaborate.
In this part of your tutorial you show the arguments section. What I would like to do is pass through todays date as the date parameter. In this example shown below in…"
Leo Demarce's Discussions
Security Not allowing Macros to run
2 Replies
Hello, I have an environment that the system is set up to ask every time we open an excel file with macro’s “do you want to enable the files”? My question is, is there any way to create in the macro…Continue
Started this discussion. Last reply by Colin Spooner Mar 7.
Stored Procedure not publishing
1 Reply
Hello,I have a stored procedure that I have succesfully attached to in the connector but when I go to add an expression there is no result for me to add. That is, the box "Choose Published Fields"…Continue
Started this discussion. Last reply by Keith Govender Feb 14.
Report converts text to numeric
I have a simple list report of territory codes that is a text field in SQL but when it lists the data in excel it formats numbers as numeric dropping leading zeros IE: 01 is brought into the report…Continue
Started Jan 21
Year -1 in filter based on a pass through variable
5 Replies
Hello, I have a union report that I have created a pass through variable as the fiscal year parameter. I have created the variable in the sub report that is rendered 1st (last report on the list) and…Continue
Started this discussion. Last reply by Terence Hinrichsen Dec 12, 2011.
Leo Demarce's Page
Latest Activity
Leo Demarce replied to Tyrone Le Fleur's discussion Scheduling an alchemex report to run on Windows Server 2008
Colin Spooner replied to Leo Demarce's discussion Security Not allowing Macros to run"Hi Leo
You do not specify which version of MS office. In Excel 2007, you can digitally sign a macro and then import that certificate into the trusted certificates of the other workstations. Any macros signed by this certificate will then run whilst…"
Allan Smallie replied to Leo Demarce's discussion Security Not allowing Macros to run"Hi Leo,
My experience with this has been that the files need to be 'trusted' on each workstation that opens them. This translates to users having to click on the "enable" option, and they would not be prompted again. You can also…"
Leo Demarce posted a discussionSecurity Not allowing Macros to run
Hello, I have an environment that the system is set up to ask every time we open an excel file with macro’s “do you want to enable the files”? My question is, is there any way to create in the macro a way to enable them....lol it sounds rediculous I know.I just thought through this and have decided that to remove the macro from the AI page to run them at the end of generating the report might do the trick, and have the user run the macro manually after the report generation is done.If there is…See More
Keith Govender replied to Leo Demarce's discussion Stored Procedure not publishing"Hi Leo,
Let me know if this does help you.
Stored Procedures
Sage Accpac Intelligence supports the use of Stored Procedures as the source for Data Containers for certain Database systems. For a list of the supported systems please go to…"
Leo Demarce posted a discussionStored Procedure not publishing
Hello,I have a stored procedure that I have succesfully attached to in the connector but when I go to add an expression there is no result for me to add. That is, the box "Choose Published Fields" pops up but there are no fields to choose.What do I need to do with my stored procedure for that to happen?Is there any guidelines as to what the stored procedure should be using as output?CheersLeoSee More
Leo Demarce posted a discussionReport converts text to numeric
I have a simple list report of territory codes that is a text field in SQL but when it lists the data in excel it formats numbers as numeric dropping leading zeros IE: 01 is brought into the report as 1 How do I stop this and bring the data into the report as text?CheersLeoSee More
Terence Hinrichsen replied to Leo Demarce's discussion Year -1 in filter based on a pass through variable"Absolutely. Nice solution btw."
Leo Demarce replied to Leo Demarce's discussion Year -1 in filter based on a pass through variable"Thanks Terrence, thanks for the feedback.
What I ended up having to do is modify my source view to change the fiscal year from a CHAR to a NUMERIC value using a convert function.
Why I use this approach is because I need to be able to use the source…"
Terence Hinrichsen replied to Leo Demarce's discussion Year -1 in filter based on a pass through variable"Hi Leo,
And if you switch to SQL Output mode (on Home Object, Right-click and select Switch Output Mode) In Report Manager, then at least it will give you the SQL query being passed and then you should be able to see what is being passed.
What I…"
Leo Demarce replied to Leo Demarce's discussion Year -1 in filter based on a pass through variable"Thanks for that Stephen,
I tried that and still no success, the result is no data so it's not passing on the right value, and I don't have any way of discovering what value is being passed on.
"
Stephen Coull replied to Leo Demarce's discussion Year -1 in filter based on a pass through variable"Leo,
I would think that the variable type should be numeric type so that it can handle the arithmetic of -1.
"
Leo Demarce posted a discussionYear -1 in filter based on a pass through variable
Hello, I have a union report that I have created a pass through variable as the fiscal year parameter. I have created the variable in the sub report that is rendered 1st (last report on the list) and the variable is a CHAR type, I have called it @FiscalYearParam@ and the default is @YEAR@.In that 1st sub report I then have the filter as FiscalYear = @FiscalYearParam@ and this works great. The issue is that on the second sub report I want Last Fiscal Year, so the filter needs to be FiscalYear =…See More
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Sage Accpac Intelligence
- About Me:
- I am a Certified Consultant with Accpac
- How long have you been using the above solution?
- Weeks
- Where did you hear about us?
- Invitation
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
