Herman van Noordwyk
Herman van Noordwyk
  • Male
  • Jhb, GP
  • South Africa
Share on Facebook
Share Twitter

Herman van Noordwyk's Friends

  • Jaqyc Niemandt
  • Bron Dorrofield

Herman van Noordwyk's Groups

Herman van Noordwyk's Discussions

Pass Through Variables for Reports run in Batch Mode

Hi all,My pass through variables work only for the report where it was specified, despite the fact that every container and report contains the same two Pass Through Variables, being AutoYear and…Continue

Tags: variables, through, Pass

Started Jul 21, 2011

System variables - creating ones
2 Replies

Hi all,How can I create a system variable for a client's Period ie their financial year starts in July, so they are in period 6, and we would like the dashboards etc to roll forward automatically,…Continue

Started this discussion. Last reply by Darryl Smith Dec 7, 2010.

Add a picture from a folder into a report
2 Replies

Hi all,I've got a client who would like to load a picture for a stock item from a Windows folder. I have found VBA code to generate a comment, but cant seem to find how to just populate it with a…Continue

Tags: AddPicture, VBA

Started this discussion. Last reply by Herman van Noordwyk Nov 9, 2010.

Delete/clear sheet macro not working
2 Replies

Hi all,I have a dashboard with a huge amount of sheets, with quite a bit of info, making it impossible to e-mail it, and the HTML published document is too limited as well.To address this, I have…Continue

Tags: hidden, module:, Module, 2, in

Started this discussion. Last reply by Herman van Noordwyk Sep 17, 2010.

 

Herman van Noordwyk's Page

Latest Activity

Profile Icon
Herman van Noordwyk replied to Lori Black's discussion 'Scheduled report to "output file"'
Hi Lori,   I only run reports on client servers, and the user who logged on has got admin rights, BUT I never use a .bat file, instead I use Windows Scheduler. As long as the user is logged in, everything runs like a charm, incl saving .xls…
Oct 19, 2011
Profile Icon
Herman van Noordwyk replied to Yolanda Botha's discussion 'Layout generation error'
Hi Yolanda,   I would run the stock standard management accounts again, this time select the balance sheet you want, modify it and copy it into the current template. You wont need the menu again, and because you're not generating any new…
Oct 19, 2011
Profile Icon
Herman van Noordwyk replied to Leo Demarce's discussion 'use SUMIFS with a date range that is referenced'
Hi Leo,   Have a look at my example. Your date format might be the issue?
Oct 4, 2011
Profile Icon
Herman van Noordwyk replied to Shwu Hua Gan's discussion 'Sumif - inconsistent output'
Hi Shwu,   I would make column A values and change the SUMIFS to just >=1001. SUMIFS does not necessarily like the text, although it should work. But instead of trying to figure out why, I would use this.
Oct 4, 2011
Profile Icon
Herman van Noordwyk replied to Kevin Naidoo's discussion 'Excel cannot complete the task with available resources....'
Hi Kevin,   I have noticed the exact same issue, and it was due to large amounts of data (with calculations inbetween as well), which has to update, and then populate a Pivot Table. Perhaps try using SQL expressions for calculations, to stop…
Aug 22, 2011
Profile Icon
Herman van Noordwyk replied to Yolanda Botha's discussion 'Assign Macro to a Button in Standard Pastel BIC report'
Hi Yolanda, Why do you even want to create a button? Just delete the MENU sheet, and leave the relevant Income Statement and Balance Sheet sheets visible, this should do it.
Jul 21, 2011
Profile Icon

Pass Through Variables for Reports run in Batch Mode

Hi all,My pass through variables work only for the report where it was specified, despite the fact that every container and report contains the same two Pass Through Variables, being AutoYear and AutoMonth.Surely once captured, it should stay in memory for the next report?See More
Discussion posted by Herman van Noordwyk Jul 21, 2011
0 Comments
Profile Icon
Herman van Noordwyk replied to Greg Dales's discussion 'Emailing Add-in error'
Hi,   Have you tried copying and pasting the Add-in line from a successful report? And Can you access the file in the folder where it has been saved to?
Jul 18, 2011
Profile Icon
Herman van Noordwyk replied to Hagashen Govender's discussion 'Excel'
Has the template perhaps got quite a bit of data Alchemex needs to delete? Do you perhaps have a lot of sheets, with quite a bit of "links" between them?
Jul 18, 2011
Profile Icon
Herman van Noordwyk replied to Kevin Naidoo's discussion 'Refresh All Pivot Tables crashes excel'
Hi,   How many Pivot Tables exactly, and which version of Excel are you running?   Have you tried a macro, to refresh every Pivot table?
Jun 29, 2011
Profile Icon
Herman van Noordwyk replied to Charles Sivewright's discussion 'Pivot Table with multiple sources' in the group Excel on Steroids
Hi, Right, here goes for Excel 2010:   Create the list (columns) in Excel, underneath each other AND highlight your list Then click on File, then Options (just above Exit) Then click on Advanced Scroll down all the way to bottom, where you will…
Mar 23, 2011
Profile Icon
Herman van Noordwyk replied to Charles Sivewright's discussion 'Pivot Table with multiple sources' in the group Excel on Steroids
Hi Charles,   I was able to sort the pivot table as follows: (In Excel 2010) I ticked Refresh data when opening file (although this shouldnt matter) Then imported a custom list to sort on Then click on the first heading, which is Contract…
Mar 18, 2011
Profile Icon
Darryl Smith replied to Herman van Noordwyk's discussion 'System variables - creating ones'
Hi Herman What system is this for, Pastel Evolution, Pastel Partner...? I may have a more dynamic solution for you using "Connection Variables" but need to know what system and version you are on to check whether this would be available…
Dec 7, 2010
Profile Icon
Jaqyc Niemandt replied to Herman van Noordwyk's discussion 'System variables - creating ones'
Hi H, Try this doc :) Hope it helps. J.
Dec 7, 2010
Profile Icon

System variables - creating ones

Hi all,How can I create a system variable for a client's Period ie their financial year starts in July, so they are in period 6, and we would like the dashboards etc to roll forward automatically, not require a monthly prompt for a new period?Thanks!See More
Discussion posted by Herman van Noordwyk Dec 7, 2010
2 Comments
Profile Icon
Herman van Noordwyk replied to Veeshal Annatooah's discussion 'Purchases Master Error'
Hi Veeshal, In Report Manager, have a look at the Parametres set, you might have set something "funny" in there.
Nov 10, 2010

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours
Pastel BIC
Website
http://www.bullseye.co.za
How long have you been using the above solution?
New to it
Where did you hear about us?
Search Engine

Comment Wall

You need to be a member of The BI Community - Powered by Alchemex to add comments!

Join The BI Community - Powered by Alchemex

  • No comments yet!
 
 
 

Follow Alchemex on twitter

Like Alchemex on facebook

This Weeks Top Content 

1 Sage MAS Intelligence Report Designer and 13 fiscal periods

Sage MAS Intelligence Report Designer and 13 fiscal periods
2 SQL Join using 2 fields

SQL Join using 2 fields
3 Create and Link does not save account mapping

Create and Link does not save account mapping
4 SMI Consolidating companies w/different fiscal years

SMI Consolidating companies w/different fiscal years
5 Pivot table from sheet 1 and sheet 3

Pivot table from sheet 1 and sheet 3

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!