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