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 Chriss Miller 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. mbDutch

    Line break in CSV export?

    Sure. The way it shows in crystal is for example: Details a: "Customer", "Part Number", "PO Number", etc Details b: "Customer", "Part Number", "Container #" etc Right now when we export it to csv it will all be on one line like: "Customer", "Part Number", "PO Number", "Customer", "Part...
  2. mbDutch

    Line break in CSV export?

    Not sure if this is possible but, I have a report where everything prints on the detail line. The detail section is broken up in 2 sections and the 2nd section will only print if a condition is met. The thing is, when the second section does print and we export it to CSV (our only option for now...
  3. mbDutch

    using a shared variable to summarize data

    Shared" Variables are primarily used to pass data from a sub- report to main report. "SummaryPercentGMP" is the name of the variable. I would check for a sub-report, open it and look for that variable. It should show you the calculation.
  4. mbDutch

    exclude fields that are null or have 4 blank spaces

    For the blank spaces you can use trim({table.field}) <>
  5. mbDutch

    How to display leading zero in the string

    To add to that - If you will use the CSV file for anything other then Excel, that formula will more then likely give you problems.
  6. mbDutch

    How to display leading zero in the string

    You could create the following formula: "=" + '"'+ {table.field} + '"' When you export that to CSV and open in Excel, Excel should assume it's a text field and not crop the zeros.
  7. mbDutch

    How to display leading zero in the string

    You can convert your string field to a number field and then convert it back to a string with a leading zero e.g. cstr(tonumber({table.field}), "000000")
  8. mbDutch

    What else could it be. If it isnt Nul and its not a space.

    Did you try trim({table.field})? This will remove any blank spaces the field may contain.
  9. mbDutch

    Linking 2 tables question

    It defaults to an inner join. All you have to do is right click your link and make it a left outer. Then if there is no matching record the paycode would show as blank. Then you can just write a formula with an IF statement to make it say whatever.
  10. mbDutch

    Balance sheet using array fields

    Hi LB - Yes it's one instance of a field. The field is called "Cur-Balance" which is basically 12 balances (arrayed) in one field.
  11. mbDutch

    Balance sheet using array fields

    I need to write a balance sheet type of report that shows by tax year and period, the account number and the balance for that account number. However, let’s say that whoever runs the report selects tax year 2008 and period 5, they will want to see that period, as well as the previous 12 periods...
  12. mbDutch

    Combine descriptions into one

    Hello - Not sure if this is possible but: I have a single table that contains a part number, an operation number and a memo description. Detail records look somewhere along the lines of: Part # Operation # Description BC-10 10 Pull from freezer BC-10...
  13. mbDutch

    Everything before last &quot;-&quot; in a string

    Perfect - thank you!
  14. mbDutch

    Everything before last &quot;-&quot; in a string

    Hello (again) - I am in need of a formula that returns everything in a string that comes before the last - (dash). For instance, if a part number is EX-P002-AB I want it to return EX-P002. If a part number is EC-V003 I just want it to return EC. Many thanks in advance, Marco
  15. mbDutch

    Combine records into one?

    Thank you so much. Works like a charm!!
  16. mbDutch

    Combine records into one?

    Hello - Not sure if this is possible but: I have a table that contains a part number, an operation number and a memo description. Report is grouped by Part Number (1) and detail records would look somewhere along the lines of: Operation # Description 10 Pull from freezer 20 Cut...
  17. mbDutch

    Display records based of field value

    I have a table called PKG (packaging). This table contains a field called "Total Boxes". What I'd like, if at all possible, is to have an amount of records based of the value of that field. So lets say that Total Boxes for packing list #abc is 4, then I would like to have 4 detail/record lines...
  18. mbDutch

    print once per group

    Tried that but oddly enough this doesnt work?
  19. mbDutch

    print once per group

    Hello - I have 2 groups. Group 1: Station and Group 2: Parts. The data is printed in group footer 2 and looks something like this: Station Part Job 100 Abc 001 100 Def 002 100 Ghi 003 200 Abc 001 200 Def 002 Now I want the Station...
  20. mbDutch

    record selection formula

    Thank you. Unfortunately that's not an option for me. All I have is a crystal reports odbc to a progress database.

Part and Inventory Search

Back
Top