Dave Smith
  • Male
  • Pompano Beach, FL
  • United States
Share on Facebook
Share Twitter

Dave Smith's Friends

  • Ann Pebworth
  • Breck Chatrou
  • Cheryl Manmohan
  • Arthur de Breyn
  • Bron Dorrofield
  • Loren
  • Ruth Gray
  • Admin

Dave Smith's Groups

Dave Smith's Discussions

Adding fields from MS Access to a PBI report is causing Duplication

Wrote & delivered a report which is connected to a Peachtree 2012 database.  Client wants to add 2 fields to this report which reside in an MS Access database.  1st time working with Access.  I…Continue

Started May 12

N of M for Shipping Labels
4 Replies

I have a client who does not have BI and so I began writing with Crystal.  During this process, I uncovered a roadblock. I was writing Shipping Labels (attached) for a client who wants a label for…Continue

Started this discussion. Last reply by Dave Smith Jan 11.

System Variables
4 Replies

System Variables are quite handy as you develop creative reports.  Have any of you created your own system variables?  I know which .ini to put the code in, but I do not know the syntax.  If I saw…Continue

Started this discussion. Last reply by Colin Beattie Apr 13.

2 Sets of Records in Data Valuation Pull-Down

Delivered a report that had 5 Data Valuation fields.  Upon closer inspection, I noticed that the look-up list included records from database that report was built in as well as records from client's…Continue

Started Oct 4, 2011

 

Dave Smith's Page

Latest Activity

Dave Smith replied to Thelma Troskie's discussion Parameters on sub reports
"Hi Thelma, A SQL Query Container does not allow you to set a common parameter in Report Manager as I mentioned above. I have not tried this with a SQL Query container.  Perhaps if you copy the container code beginning with the FROM clause into…"
Friday
Dave Smith replied to Alan Melville's discussion Possible to Rename DB name in Pervasive SQL DB Name Manager?
"Hi Alan, Not familiar with the Name Manager, but you should be able to rename the connection in the Connector with a right click.  You may not be able to rename the actual container if it is locked.  If you are in the Connector & are…"
Thursday
Dave Smith replied to Thelma Troskie's discussion Parameters on sub reports
"Hi Thelma, As an example for Date Range, in the container for the subreport whose parameter comes up 1st in Report Manager (aka the one at the bottom of the list when you double click your green Union Report icon), add two Pass Through Variables…"
May 15
Dave Smith posted a discussion

Adding fields from MS Access to a PBI report is causing Duplication

Wrote & delivered a report which is connected to a Peachtree 2012 database.  Client wants to add 2 fields to this report which reside in an MS Access database.  1st time working with Access.  I used Graphical Joins to connect 3 tables so as to access the new fields and also bring through Job ID and Date so as to consolidate with the current Job report.  When run out, some of the rows are duplicating.  What can I do to eliminate the duplication?See More
May 12
0 Comments
Dave Smith replied to YESHMEETA PETERS's discussion One Free licence - Account Groupings?
"Hi Justin,  I missed the word free in Yeshmeeta's original post.  Mainly because there is NO free Report Manager license for the small biz Sage software's I support.  You do not need a Connector, but you probably DO need a…"
May 8
Dave Smith replied to Joanne McCoy's discussion How do you add two JOINS to the same table in Administration
"What does the error look like & what were you doing when it occurred?"
May 8
Dave Smith replied to Michael Bass's discussion Twelve month sales by customer
"Hi Michael, I have done this recently and what I did was just place the Month field in the Column Labels area of a pivot table.  See my attached example.  Once you follow Joanne's formula and get your month field into RawData, just…"
May 5
Dave Smith replied to Joanne McCoy's discussion How do you add two JOINS to the same table in Administration
"Ah, that is different.  You have a couple of choices.  You haven't mentioned which software you are pulling from  but I mainly write from Peachtree so I will assume your structure is as wierd as mine.  If you have a way to…"
May 5
Dave Smith replied to YESHMEETA PETERS's discussion One Free licence - Account Groupings?
"Hi Yeshmeeta, If you have the Connector and customize a container, then subsequently create a report from that container; then export the report and send it over to your client, when they import your report, the container will import right along…"
May 4
Dave Smith replied to YESHMEETA PETERS's discussion TWO LICENCES - WHERE DO YOU ENTER THE SECOND LICENCE?
"Hi Yeshmeeta,  Take a look at your License Manager.  That screen should allow you to ADD the 2nd user.  Dave"
May 3
Dave Smith replied to Joanne McCoy's discussion How do you add two JOINS to the same table in Administration
"Hi Joanne, The statement below is what I use if I am joining two tables with two fields.  Use the AND operator. LEFT JOIN "InventoryCosts" ON "JrnlRow"."PostOrder" =…"
May 2
Dave Smith replied to Kristi Deiuliis's discussion Assembly cost on sales report in PT 2012?
"The "canned" Sales Analysis report does not account for assembly item costing.  That is actually quite involved.  Have not actually done it yet, but it could be achieved by creating a container for each sub assembly level.…"
Apr 25
Dave Smith replied to Shwu Hua Gan's discussion Using Data Validation - List in Excel 2007
"Hi Shwu, When I use Data Validation, the user is free to select from the list and if you use the same list on another Data Validation cell, nothing that I know of would restrict the user from selecting a value the same as the other cell's…"
Apr 23
Colin Beattie replied to Dave Smith's discussion System Variables
"I am trying to do this. but they are not appearing in the list of system variables? Have I done something wrong or could there be more than one alchemex.ini file?"
Apr 13
Dave Smith replied to Gary Olynik's discussion Expanding a Spreadsheet to the Right in the group Excel on Steroids
"Hi Gary, A single Invoice would typically not be a column but could often be a row.  Is that what you meant?  If you can attach an example of the spreadsheet, it may help me to form a picture. If you really did mean column, it should…"
Apr 11
Dave Smith replied to Craig Newton's discussion Just a little help.
"Fortunately there is a section in the Peachtree Help module that clearly defines the Peachtree data structure.  It is the "must-have" for writing reports from the Peach db.  In Peach, go to HELP | PEACHTREE ACCOUNTING HELP.…"
Mar 23

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours
Simply Accounting, Sage Peachtree Intelligence
Website
http://www.phaseonecomputing.com
About Me:
Certified Consultant > Peachtree & DacEasy & Simply Accounting > Also write Crystal Reports
How long have you been using the above solution?
1+ year
Where did you hear about us?
Invitation

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 Problem - Grouping by Custom Account Groups

Problem - Grouping by Custom Account Groups
2 Picklist for Accpac SQL databases

Picklist for Accpac SQL databases
3 Possible to Rename DB name in Pervasive SQL DB Name Manager?

Possible to Rename DB name in Pervasive SQL DB Name Manager?
4 ODBC Driver selection when entering data connection details

ODBC Driver selection when entering data connection details
5 Combining Accounts in SMI financials

Combining Accounts in SMI financials

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!