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!

Register Log in
  • Congratulations dencom 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: Barock21
  • Content: Threads
  • Order by date
  1. Barock21

    Comma Delimited from Crystal 11

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

    Grouping Formula

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

    How to set selection criterion for a specific range of datetime

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

    Hiding passed values from subreport

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

    Fixed Length on SubReport

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

    Eliminating characters on a field

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

    Fixed length on numeric field

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

    Sorting by Calculated Field from Totals (That is also calculated)

    I have created a sales report that is quite complicated from the beginning. I grouped the report by branch and then by item. I had to calculate the sales of those items within certain time period using "WhilePrintingRecords" running total. Here's the reason: I sold 1 item at $1000 for qty of...
  9. Barock21

    Sorting by Calculated Field from Totals

    I have created a sales report that is quite complicated from the beginning. I grouped the report by branch and then by item. I had to calculate the sales of those items within certain time period using "WhilePrintingRecords" running total. Here's the reason: I sold 1 item at $1000 for qty of...

Part and Inventory Search

Back
Top