Jaqyc Niemandt's Groups
-
VIP PAYROLL Business Int…
21 members
-
Pastel Evolution Busines…
83 members
-
Report Designer
99 members
-
Alchemex Certified Profe…
46 members
-
Excel on Steroids
150 members
Jaqyc Niemandt's Discussions
Urgent Report Manager Trainer needed for client in Midrand
3 Replies
Hi,I urgently need a Report Manager Trainer for a client in Midrand.(Pastel Partner) Please e-mail me (I only check mails on Blackberry).info@flauntworx.co.za Thanks!Jaqyc Continue
Started this discussion. Last reply by Admin Mar 3, 2011.
Historical Sales
2 Replies
Hi,Is there an easy way to get 2 years sales history on Pastel Partner.Perhaps a table that stores this info?I get current FY sales, but I want the previous year aswell.Or is the only way to use the…Continue
Started this discussion. Last reply by Jaqyc Niemandt Jan 31, 2011.
Parameter/Filter/Date/Column Conundrum
3 Replies
Hi Everyone, I am writing a Stock report, and need to have the LAST 3 MONTH'S sales in the report. So in January, I would need December, November, and October's sales. Is there a way to achieve this…Continue
Tags: Columns, Macro, Filter, Parameter, Dates
Started this discussion. Last reply by Jaqyc Niemandt Jan 31, 2011.
Can you write BIC reports for Evolution without having it installed?
4 Replies
Hello,Can you write BIC reports for Evolution, without having Evolution installed on the machine?The intention is to them move the reports to the Evolution server once done.Thanks,J. Continue
Started this discussion. Last reply by Jaqyc Niemandt Jan 14, 2011.
Jaqyc Niemandt's Page
Latest Activity
Admin replied to Jaqyc Niemandt's discussion Urgent Report Manager Trainer needed for client in Midrand"Hi Jaqyc,
Inspired by your post, this group has been created: The BI Community Notice Board Group >>
You can post Idea and listings such as this one for more detailed and frequent responses in the area.
Have a Great Day,
Leo…"
Jaqyc Niemandt replied to Jaqyc Niemandt's discussion Urgent Report Manager Trainer needed for client in Midrand"Hi Tyrone,
I contacted them, but they are not willing to assist to train this client. They requested I contact Alchemex directly. Is there a trainer that you know of, that will be willing to train this client in Midrand?
It…"
Tyrone Le Fleur replied to Jaqyc Niemandt's discussion Urgent Report Manager Trainer needed for client in Midrand"Hi Jaqyc
I have sent details of trainer to your above e-mail address and have also supplied them below.
Nirvana Training is a company based in the JHB area. You can speak to Vasan on 0861113373…"
Jaqyc Niemandt posted a discussionUrgent Report Manager Trainer needed for client in Midrand
Hi,I urgently need a Report Manager Trainer for a client in Midrand.(Pastel Partner) Please e-mail me (I only check mails on Blackberry).info@flauntworx.co.za Thanks!Jaqyc See More
Jaqyc Niemandt replied to Henning Buitendag's discussion Database consolidation / combining"Hi,
You can also explore the PICLISTM command to select multiple companies.
J.
"
Jaqyc Niemandt replied to Jaqyc Niemandt's discussion Parameter/Filter/Date/Column Conundrum"Thanks a bunch Darryl. I have tried this before, and it doesn't seem to work when I add a SQL Expression. It either complains about syntax, or gives me an error regarding the joins on the tables :/"
Jaqyc Niemandt replied to Jaqyc Niemandt's discussion Historical Sales"Thanks S - the Sales master does combine the data in a pivot, but it's still exporting all the individual transaction lines. I was hoping that there might be a table with LAST1 LAST2 etc. type data already without having to use the detail…"
Stephen Coull replied to Jaqyc Niemandt's discussion Historical Sales"Run the sales master for 2 years i.e. strat date >= 1 Jan 2010 and end date <= 31 Dec 2011
Perhaps I am missing something, but it is as simple as that.
SHould you be referring to GL related sales info, the Management Pack extracts 2…"
Jaqyc Niemandt posted a discussionHistorical Sales
Hi,Is there an easy way to get 2 years sales history on Pastel Partner.Perhaps a table that stores this info?I get current FY sales, but I want the previous year aswell.Or is the only way to use the header info and sum each period up?ThanksJ.See More
Darryl Smith replied to Jaqyc Niemandt's discussion Parameter/Filter/Date/Column Conundrum"Hi Jaqyc
In the Administrator Tool (or Connector module) just add an Expression to your container and choose type "SQL Expression" then add this as the SQL for the Source SQL of the expression DateDiff("d",…"
Jaqyc Niemandt replied to Jaqyc Niemandt's discussion Parameter/Filter/Date/Column Conundrum"I have a SQL statement that might be able to do this - but I am not sure where I'll need to add this.
DateDiff("d", "DDate", GetDate()) => 60
Can anyone direct me??
Thanks,
J.
"
Jaqyc Niemandt replied to Charles Sivewright's discussion Pivot Tables"Hi,
It will give an error when there are cells in the range that either does not contain a date (in other words, a number or text), OR if the dates are not in the same format.
So you'll have to check your base data first.
Glad it…"
Jaqyc Niemandt replied to Charles Sivewright's discussion Pivot Tables"Hey,
On the pivot table. Right click the column heading where the dates are, and select group.
J."
Jaqyc Niemandt replied to Charles Sivewright's discussion Pivot Tables"Hi Charles,
Have you tried grouping the column containing your dates? I find that this helps when working with dates in Pivot tables.
J.
"
Jaqyc Niemandt posted a discussionParameter/Filter/Date/Column Conundrum
Hi Everyone, I am writing a Stock report, and need to have the LAST 3 MONTH'S sales in the report. So in January, I would need December, November, and October's sales. Is there a way to achieve this using a parameter or filter? If not - I will then have 12 month's sales in my report. Any suggestions on how I can use a macro to delete the irrelevant columns? Example: …See More
Profile Information
- Website
- http://www.flauntworx.co.za
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
