Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. grcrystal

    Backup problems Year end wizard

    Try deleting the following files in the company's data folder if you do not use the Action Item System in Peachtree: Alarm.dat Alert.dat Eventlog.dat When you open your Peachtree company, you will be asked if want to create a new Alarm or a new Alert or a new Eventlog. Say "Yes" and create new...
  2. grcrystal

    THIS YEAR'S UNIT SOLD VS LAST YEAR'S UNITS SOLD

    So the prior post should have included two questions: 1) How do I get the report to only include the items I've asked for in my selection ({LineItem.ItemID} <> "M10920" and {LineItem.ItemID} in ["M10055" to "M999800"])? 2) How do I get the correct formula so the report displays the units sold...
  3. grcrystal

    THIS YEAR'S UNIT SOLD VS LAST YEAR'S UNITS SOLD

    Don't know if I should start a new post, or just post the additional question here, since it is the same report. My report is not pulling the transactions for Last Year. My selection formula: {JrnlRow.Journal} = 3 and //this pulls sales transactions {LineItem.ItemID} <> "M10920" and...
  4. grcrystal

    THIS YEAR'S UNIT SOLD VS LAST YEAR'S UNITS SOLD

    Thank you LB! I made the changes and now there are no errors. Thank you so much!
  5. grcrystal

    THIS YEAR'S UNIT SOLD VS LAST YEAR'S UNITS SOLD

    I am using Sage 50 (Peachtree) Quantum 2013, Crystal Reports 2008 and PSQL is the database engine. I am designing a report to show Units Sold for Inventory Items for a specific date range and Units sold for Inventory Items Last Year (which is specific date range less one year). I am getting an...
  6. grcrystal

    Peachtree Accounting Complete 2007 RDP/Local Access

    I've been supporting Peachtree since 1988. As far as I know you need a dedicated workstation in order for the remote user. Peachtree should be able to install on the server where the data is stored. There are many times you may have to troubleshoot a problem and having the application on the...
  7. grcrystal

    Making a report available to any Lytec database

    Thank you for this information. It's exactly what I needed to know.
  8. grcrystal

    Making a report available to any Lytec database

    I'm using Lytec 2010, a MS SQL database and Crystal Reports v9. I want to have reports I create for Lytec available for any practice. If I have created an ODBC connection with the default database as Lytec Tutorial, how do I make other databases or medical practices have the ability to run the...
  9. grcrystal

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    Thanks so much for this information. I was able to create an ODBC connection with the information you supplied in the previous post.
  10. grcrystal

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    I have created ODBC connections before, but not with Lytec. I was hoping I could follow someone's step by step instructions. There are a lot of fields on each window for setting up a connection. I'm assuming I would use the System DSN tab to start creating, but after that I don't know...
  11. grcrystal

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    I was interested in how to connect to the database, like with an ODBC connection. Can someone help with the steps to create the ODBC connection?
  12. grcrystal

    CR v9 or CR 2008 Connecting to Lytec 2010 database

    Lytec 2010 is a medical specific software and uses Microsoft SQL as the database engine. There are canned crystal reports that come with Lytec, but I want to create a new report. Do you know how I can connect crystal reports v9 or crystal reports 2008 to the Lytec 2010 database?

Part and Inventory Search

Back
Top