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 wOOdy-Soft 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. trialbyfire

    Listing Sub Report Data

    I have several reports where I have a subreport that returns multiple lines of data from the subreport for one line in the main report. Ex... SKU ABC QTY 16 BIN 47 LOT 6 DT 6-9-05 6-10-05...
  2. trialbyfire

    Using Replace Funtion trying to replace everything behind "-"

    I am trying to take a string similar to 524-0982 or 62341-90823 and displaying just the digits before the dash. However the wild card operators do not appear to be working for me. Formula is as follows, Replace ({custname.cust-code},"-*","") If I remove the " from...
  3. trialbyfire

    Returned Information from Subreport based on Selection Criteria

    I have a report where in the main report I am breaking down sales dollars and pieces by sales rep then by month, then by billing customer. (Billing customer is the main billable account. Ex Walmarts billing customer would be Walmart Coorporate and the Store would be Wal-Mart Store.) The...
  4. trialbyfire

    Error detected by database dll or not enough memory to complete operat

    I am getting an error on an inventory report that I designed using crystal 8.5. The report used to work and now everytime we run the report it is taking approx. 3 1/2 hrs to run and gives me an error stating either "error detected by database dll" or "Not enough memory to...
  5. trialbyfire

    Need help Summarizing a Shared NumVar!

    I have had a lot of posts back on a previous posting stating to just create another formula field that summarizes the shared numbervar. I tried that before I made the original post and it didn't work. Here is what I have. -In group header #2: /whileprintingrecords; /shared numbervar...
  6. trialbyfire

    Data Extract from Progress 9.1C

    I am trying to write a data extract that would be comma delimited and sent to a standard text file. I want to use this information to build a cognos powercube. The problem I am having is trying to pull the information from multiple tables. Can this be done with a simple progress utility or do...
  7. trialbyfire

    Returning Numeric Values from Subreport

    Here is the deal. In the detail section of the report I have 4 seperate subreports. One detailing open dollars, one detailing booked dollars, one detailing picked dollars and one detailing sold dollars. Two groups exist above the detail. The first broken down by month the second by customer...
  8. trialbyfire

    Gathering Information from Sub-Report to Main Report

    Here is the Deal. I am using a multi grouped drill down report to display open order, in pick, and sales information. Sales and open can be pulled from the same tables. In pick I have to run from a subreport. I need to be able to grab the information from the subreport to use in main report...
  9. trialbyfire

    Pulling Values from Subreport at Print time

    I am trying to pull in negative and positive values from 3 seperate subreports that normally only print the sum of all of the discounts and charges. An example being order charges subreport. May have several lines of discounts and one charge for shipping. I am trying to seperate the values in...
  10. trialbyfire

    Subreports containing negative and positive values

    I am using crystal reports to connect to an odbc database to print invoices for our company. In the database file there are two types of charges/allow. Header and Item allowances/charges. These allowances and charges each print as seperate records when the subreport kicks off. However I need...

Part and Inventory Search

Back
Top