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 Chriss Miller 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: *

  • Users: SteveBell
  • Content: Threads
  • Order by date
  1. SteveBell

    How do I group by one field and sort by another?

    I have an inventory report that looks at every inventory transaction and sums the transaction quantities in a complex formula. The details section shows every inventory transaction, and it's suppressed. Group 3 is the item number, and the sum of the transaction quantities is displayed in that...
  2. SteveBell

    Here's a simplified version of my t

    I'm using Crystal Reports v8.0, Crystal Enterprise v8.0, and the interface to Baan ERP on Oracle. I need some help figuring out the best way to massage my data into the proper report format. Here's a simplified version of my table: ProblemID Person1 Person2 Person3 Action1 Action2 Action3...
  3. SteveBell

    Anyone created Crystal design tools / aids?

    Has anyone created any worksheets or design tools/aids to help with development of Crystal reports? I'm halfway through writing an Excel spreadsheet that documents columns, fields, formulas, ...; but I'd rather not recreate the wheel. I'm looking for something that I can use to simplify the...
  4. SteveBell

    How to find transactions that have NOT occurred

    The database table looks like this: Shipping {Item#} {Date} How do I show every item whose latest shipping date is more than 90 days ago? Our DB guy said he'd do it in SQL with a HAVING clause. We're using Crystal Reports v8.0, and the report will be published in Crystal Enterprise. The...
  5. SteveBell

    How to run the same report with different parameter defaults

    I have a report that I'd like to schedule in ePortfolio to run on the 1st of each month with a date range of the previous month. I'd also like to run it on demand with a parameter prompting for a date range. Is this possible? Steve Bell There's nothing better than a friend, unless it's a friend...
  6. SteveBell

    How to run a program without logging in?

    I've got XP up and running fine. I created accounts for my wife and me. I left the guest account for my brother-in-law when he visits. Now I'd like to get my webcam working again. How do I make the webcam software run at reboot, even when no one's logged in? (Especially when no one's logged in...
  7. SteveBell

    User can't view reports -- server connection reset error message

    I have a new CE user who gets this error message when trying to view any report: Internet Explorer cannot open the Internet site http://dntapp03/crystal/enterprise/ePortfolio/en/viewrpt.cwr?id=661&init=actx:connect The connection with the server was reset He can log in and change his display...
  8. SteveBell

    How to chart based on formulas using summary fields?

    I'm using CR v8.0 connecting to Baan ERP via the DLL interface. I've developed a report that:Retrievesrelevant inventory transactions for each part from the transaction history (to establish a usage level for the last 12 months) part-specific info (standard price, safety stock level) from the...
  9. SteveBell

    What should I ask Seagate about Crystal Enterprise for Baan?

    We're a Baan ERP shop, and we're interested in Crystal Enterprise for Baan I have a video-conference scheduled with Seagate later this week to get a demo and go over pricing and technical issues. What questions should I ask? Steve Bell
  10. SteveBell

    What should I ask Seagate about Crystal Enterprise for Baan?

    We're a Baan ERP shop, and we're interested in Crystal Enterprise for Baan I have a video-conference scheduled with Seagate later this week to get a demo and go over pricing and technical issues. What questions should I ask? Steve Bell
  11. SteveBell

    How to retrieve only one row from a table

    I'm writing a report to calculate margin on our parts. The costs for each part (materials, labor, overhead, subcontracting) are rolled up periodically and stored in a different table. My problem is how to retrieve only the data I want. I have a set of tables that look like this: Invoice Table...
  12. SteveBell

    values repeat from last line of one page to first line of next page

    My report uses a combination of sums, running totals, and formulas in a group footer. When I suppress or hide the details section, the values from the bottom line of each page are duplicated in the first line of the next page (replacing the correct values). When I unhide or unsuppress the...

Part and Inventory Search

Back
Top