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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.