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. pjrlion

    Viewing main and subreport data in access

    I have created variables to successfully bring sub-report data into the the main report but have not been able to export the complete report including its sub-report data to a text or Access file. Any ideas from anyone. I am running out of ideas on this one. Pete
  2. pjrlion

    Crystal Reports from the web

    DirtyB, If possible could you send (PReeder2001@yahoo.com) the code to me as well. I am late in getting in on this conversation but my company will soon need such a distribution method. Thanks
  3. pjrlion

    Export main and subreport data to access

    When I display sub-report data in the main reports detail section I see and can print the main and sub-report data. When I try to export the main and sub-report data the subreport data will not export, only the main report data. How can I export the entire report (main and sub-report data)...
  4. pjrlion

    Dictionary not found after running query from designer

    I create a query in query designer. I run from the report designer. I add parameters, save, and exit. And when I reopen the v7 Crystal file, I get the message: dictionary not found... The query was in a folder separated from the report. That does not seem to be the issue in that I put a copy of...
  5. pjrlion

    Taking Data From One DBF file and Matching up to Another DBF

    You are correct that I was working from the Goldmine database at work. This is a consulting job and I will not be back in the job until after the new years. However, I am testing the query at home with access as my test database. Using Access data I created dummy records.Two records were...
  6. pjrlion

    Taking Data From One DBF file and Matching up to Another DBF

    To try to say the issue another way, I want all accounts that have no (account) contacts called on. The contact records that are greater than 1 year should not be returned if another contact in the same company (account) is being visited-called-or emailed by another sales rep. Conceivably our...
  7. pjrlion

    Taking Data From One DBF file and Matching up to Another DBF

    Contact1 tables pertinent fields are companyname, companycontact, contactphone, accountnum. This table links to a Contacthistory table by way of accountnum field. Contacthistory tables pertinent fields are accountnum, SalesRep (known as TsgUser), ContactActivitydate, Contactactivitytype (Call...
  8. pjrlion

    Taking Data From One DBF file and Matching up to Another DBF

    I need more clarification with how to solve an issue similar to the "Use a subreport approach" issue Idomillet addressed. I have been asked to produce a report, working within a dbase database (goldmine contact mgmt dbase), that shows only records of accounts that have not been called...
  9. pjrlion

    In need of database tabledata to practice with

    Is there a sample database and associated tables that I could download. I am searching for a database for which to practice report writing, forms, and complex query skills.

Part and Inventory Search

Back
Top