Meg McDonald
  • Female
  • Maputo
  • Mozambique
Share

Meg McDonald's Friends

  • Krithika Raju
  • Carmen Griessel
  • Sandra Smith

Meg McDonald's Groups

Meg McDonald's Discussions

Save Repeat Labels on a pivot table - Excel 365
1 Reply

I have created a report that requires the labels on the pivot table to have the repeat label option enabled. I save the report with it on but each time I rerun the report it drops the repeat label…Continue

Tags: Steroids, on, Excel

Started this discussion. Last reply by David Bryant Feb 27, 2017.

Excel Question for a Combined report
3 Replies

I have hit a blank and would appreciate any wisdom or idea's.I have drawn three separate reports and created a union report and on the report created 3 Pivot Tables with the same headings from…Continue

Tags: combined, pivots, Excel

Started this discussion. Last reply by Jim Smith Oct 16, 2018.

X3 with Oracle Database - Report Designer Errors
1 Reply

We are experiencing an issue with Sage Intelligence on X3 with an Oracle Database. It is unfortunate that Sage Support does not support Oracle and I am hoping that someone has had the same experience…Continue

Tags: Exception, Path, Empty

Started this discussion. Last reply by nanah Dec 5, 2016.

Pastel Partner Sales Report off Sales Master using Date Slicer
1 Reply

HiI have tried to add a two date slicers onto the sales master in order to show certain years and certain months, however each time I save the template the date slicer changes back to whole dates and…Continue

Tags: filters, Slicers

Started this discussion. Last reply by Nigel Naicker Jul 26, 2016.

 

Meg McDonald's Page

Latest Activity

Meg McDonald replied to Simbarashe Muchanyu's discussion Sales Master Monthly by Product in the group Free Reports Group
"Hi Simarashe Muchanyu What Sage Accounting package are you using? There are a number of Report writers available. You are welcome to email me on meg@customconsultingsa.co.za, I am a recommended Report writer. Look forward to hearing from you"
Feb 11
Jim Smith replied to Meg McDonald's discussion Excel Question for a Combined report
"When you first save your template for your file, you are given a choice - "There are Pivot Tables in this workbook that use the 'Save Data with Table Layout' option. This can make your reports very large and is not recommended. Do you…"
Oct 16, 2018
Paul replied to Meg McDonald's discussion Excel Question for a Combined report
"This is essentially what I am attempting to do. I thought I would be smart and use data queries inside Excel to achieve this. In Excel it works beautifully but when I save the template to Sage Intelligence then run it again all the data query…"
Oct 14, 2018
Leroy Gordon replied to Meg McDonald's discussion Report Manager Screen
"It is a wonderful thing to have these resources remain as someone out there at some point will have a similar issue and need a resolution. This was most helpful even more than three years after initially posted. Thank you Nanah & Meg."
Dec 27, 2017
Meg McDonald replied to MARDUS GROBLER's discussion Sales report 5yr-Pastel Partner in the group Free Reports Group
"Thanks Peter - Yes it should be standard "
Oct 3, 2017
Meg McDonald replied to MARDUS GROBLER's discussion Sales report 5yr-Pastel Partner in the group Free Reports Group
"Hi Mardus Have you changed companies? Can you not see all 5 years sales within your sales report that we can add graphs to? I am a custom report writer for Pastel and I am sure we can help you.  Please feel free to contact me on …"
Sep 27, 2017
Meg McDonald replied to Annelize Burger's discussion Open Purchase Order Detail - Evolution in the group Free Reports Group
"Hi Annelize,  If you are wanting some help with a report like this, we can help you. Please email me on meg@customconsultingsa.co.za - I have a consultant that only works with Evolution reporting."
Sep 19, 2017
David Bryant replied to Meg McDonald's discussion Save Repeat Labels on a pivot table - Excel 365
"Hello Meg Have you ensured the option to "preserve cell formatting on update" check box is selected?"
Feb 27, 2017
Meg McDonald posted a discussion

Save Repeat Labels on a pivot table - Excel 365

I have created a report that requires the labels on the pivot table to have the repeat label option enabled. I save the report with it on but each time I rerun the report it drops the repeat label field option. Any Idea's on how to get this to stay when saving the report?See More
Feb 24, 2017
Sandra Smith replied to Meg McDonald's discussion Excel Question for a Combined report
"Hi Meg,  This is a good question. Not sure if this helps but I've found instructions on how to calculate a value from 3 Pivot Tables which works well but I have yet to determine how to combine the data.  Basically, use the Consolidate…"
Dec 15, 2016
Meg McDonald posted a discussion

Excel Question for a Combined report

I have hit a blank and would appreciate any wisdom or idea's.I have drawn three separate reports and created a union report and on the report created 3 Pivot Tables with the same headings from different data sheets.I now need to create a combined sheet that will read the data out of the 3 Pivots, being sure that each month the varying number of transactions will go  to this combined sheet. ThanksSee More
Dec 14, 2016
nanah replied to Meg McDonald's discussion X3 with Oracle Database - Report Designer Errors
"HI Meg, the bi components wont allow you to create a layout without the task pane. are you currently using Sage intelligence for x3 or are you using the standard 7.3 software and connecting to a x3 db? thanks"
Dec 5, 2016
Meg McDonald posted a discussion

X3 with Oracle Database - Report Designer Errors

We are experiencing an issue with Sage Intelligence on X3 with an Oracle Database. It is unfortunate that Sage Support does not support Oracle and I am hoping that someone has had the same experience and can help me.When running the report design template after changing all the connectors to Oracle Syntax, we get the data on this hidden sheets however when we try to use the Layout generator  we get : "Empty Path name is not legal" or we get " Initialization of…See More
Nov 22, 2016
Nigel Naicker replied to Meg McDonald's discussion Pastel Partner Sales Report off Sales Master using Date Slicer
"hi Meg for your slicer question, i find opening the report in design mode, then adding a dummy row of data and then re-doing the grouping for years and months, then save, usually does the trick.  For your filter question, that is tough one, if…"
Jul 26, 2016
Meg McDonald posted a discussion

Pastel Partner Sales Report off Sales Master using Date Slicer

HiI have tried to add a two date slicers onto the sales master in order to show certain years and certain months, however each time I save the template the date slicer changes back to whole dates and not grouped years and months. Anyone have this same issue or any idea's of how to stop this from happening.Also there is a filter on the pivot and this is cleared at each save and needs to be re selected. Is there anyway to save the filter choice but still have the option to change it to another…See More
Jul 26, 2016
Meg McDonald replied to Hamse Osman Hassan's discussion Can i get Report Designer for Sage ERP Accpac 500 version 6.0A
"Hi Hamse Yes I can help you with 300 Report Designer but it will not work with a 500 system.  You are welcome to contact me at meg@customconsultingsa.co.za - You will find all me details under the report writers info…"
Apr 27, 2016

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Pastel Intelligence Reporting (Formerly BIC)
Website
http://www.customconsultingsa.co.za
About Me:
Custom Consulting SA -

Specilizing in Sage Intelligence reporting
How long have you been using the above solution?
4 years
Where did you hear about us?
Other

Comment Wall

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

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service