Search results for query: *

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

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

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.

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

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.

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.

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")

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

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.

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.

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

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

Perfect - thank you!

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

Thank you so much. Works like a charm!!

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

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

Tried that but oddly enough this doesnt work?

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

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