Search results for query: *

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

Worked like a charm synapsevampire. Thank-you for your help.

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

Alright here is an example. Anything in Caps is the subreport data that I am looking to return. Group 3 Contains Subreport Custname. This is linked from the Invoiceheader.billing-cust-key to the Custname.cust-key file in the subreport. Each customer record has both a customer code and a...

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

unfortunately I need the subreports to be initiated. The columns in the spreadsheet are as follows Category, Sub-category, Product Code, On hand Quantity, On order quantity, pending sales order quantity, backorder quantity, total available quantity, Expected arrival date (from oversees...

RJFrost, Thanks for the input. Unfortunately I was aware of the memory issues. Was just hoping that there was a way to work around this. I am running the report on a compaq P4 1.4 GHZ machine with almost a gig of ram. The other users are having the majority of the problem. I think like...

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

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

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

Lisa, This is great advice. One quick question? What would be the syntax that I would use as I am not that familiar with the shared num variable commands and also if I were to insert a second detail section in the report that I suppressed and then subtotaled off of that would this work...

Another little helpful hint for export to Excel. When using multiple row headers you can stop one header from "sliding" by simply increasing the text box size. Ex... /Headings below Customer Address City State Zip Contact Phone Fax E-mail In the...

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

How would I get the shared number variable to print in the main report? I would like the shared number variable from the subreport to print in the detail level of the main report and then use that field that the number variable is in to sum etc...

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

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

Rogar, This has been a great help. I am still having a few small problems however. This is working for the positive amounts however it is not grabbing the negative amounts and pulling them into the report. I have three subreports that are gathering this information. One for item disc/chrgs...

Rogar, I am assuming then that I would put a running total formula into each of the subreports that are printing this data. Then fetch the total into the main report and add the positive values for each of the subreports and then add the negative values for each of the subreports and place...

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