Search results for query: *

I believe that's the part you did not understand in this issue. What I have been trying to explain is that in this file as the end result I can not have the invoice number line repeated for each line item. The invoice line will only show once and followed by the line items on the next rows...

No it doesn't and yes I suppressed the group header. When I moved the header down to the detail section - I got repeated invoice numbers for every single line item (which is expected). 1 invoice may have many line items. Even if I had 1 line per invoice - it is still showing the even row...

Nope, doesn't work. Thanks though.

Guys, I currently am using Crystal 11 Professional. I am trying to export a very simple report to a comma delimited file. But when I opened up the report it is showing extra commas. Here's how the report look like: Group Header 1 InvoiceNo InvoiceDate blankspace Cust ID Detail CustPO...

I'm currently working on 1 view - sales_history_view. Both fields - sales_price and sales_cost are from the same view. Item Mo 1 Pr Mo 1 Co Mo 2 Pr Mo 2 Co ABC123 100 50 150 80 XYZ123 0 0 200 120 DEF123 250...

Hello, I am currently creating a report on Crystal 11 and I have created a bunch of an if then formulas. I ended up with 4 formulas: Price 1, Price 2 Cost 1, Cost 2 What I did on Price 1 formula was (and this pretty much applies to the other formulas accordingly): IF period = 1 THEN...

That works very well. Thanks a lot.

Hello all, I am currently using crystal 8.5 and am trying to create a delivery report. This report will be printed everyday. However, it needs to retrieve information from 11:46am the previous day through 8:45am today. As far as, Monday - I need to have it from 11:46am Friday to 8:45am...

LB it worked perfectly. You are the best!!! Thanks a lot. DT

Thank you all for your reply. Yes, I'm using the shared variable function to do this. Currently there is no group on the main report only the usual report header, page header, detail, report footer and page footer. I have a static text on the report footer and the total for whatever...

Group it by ID - insert summary for that group and do count on that summary on Prod.

I am on crystal 8.5 and I am trying to pass a total value that is on a subreport to the main report. I was able to do so sucessfully. I have the subreport in a section before the value that I want to show on the main report (detail section) and have the passed total value in report footer...

Here's the formula I did on the subreport: NumberVar RequiredLength:= 9; NumberVar CurrentLength:= Length (TOTEXT ({#BID Count}, "0000000000")); IF RequiredLength < CurrentLength THEN TOTEXT ({#BID Count}, "0000000000") [1 TO RequiredLength] ELSE ReplicateString ("0",RequiredLength -...

I currently am using crystal 8.5 but can use version 11 if need be. All the subreport has is just 1 line count of number of sales. I did the formula to make it fixed length text on the subreport. Can you please elaborate on how to return value from the subreport to the main report? This may...

I need to create a fixed length flat file. Unfortunately, part of the information is from a subreport. I tested this and export it on a .csv file and the subreport information is not showing on the .csv file. Is there a way for me to get around this? Thanks in advance.

I am trying to report a phone number, however the phone numbers stored on the database are set up XXX-XXX-XXXX. I need to get rid of the dashes and get the result as XXXXXXXXXX. Is there an easy way to do this? Thanks. B21

Works like a charm. Thanks.

I have created a formula to get a fixed length character that I can dump to a flat file. It works great for characters however, it doesn't do well with numbers. For example: I have inventory qty of item ABC and it is 2500 eaches. Here's the formula I created: NumberVar RequiredLength:= 11...

Thank you for your reply. I believe you are referring to have the sales price on AVG. Yes that actually may work for that one specific transaction. However, it is not going to work when I would like to subtotal all these transactions since each transaction may show different profit. Thus, it...

Thank you for your reply. I really hate to make this so complicated, but the price I referred to was calculated field not from the database. The $1000 scenario came from this: 1st Formula - Extended Price: ({wbw_line.UT_PRICE} / {wbw_line.SALES_SIZE}) * {wbw_line.MULTIPLIER} *...