Search results for query: *

Is there a way to reset running totals incrementally? If several transactions for the same person total or exceed $10,000, it's simple to do a running total but if I need to reset the running total to 0 for that same person after the first $10,000 is received and arrive at a second running...

Did you try 'Save As' in Excel to convert your xlsx file to xls format?

The SQL expression is trim(nvl("Table.Division",' ')). I tried this as a {@Division} formula also with the same result. No default value for the parameter, only one value allowed. No leading spaces in the parameter. I see that brackets give me the correct result {%Division} in [{?Division}]...

Crystal XI, Oracle. I'm seeing a different result with these 2 selection statements. {%Division} = {?Division} {%Division} in {?Division} The first one gives me all Athletics division records when 'Athletics' is entered as the parameter. But the second one gives me all Athletics records plus...

I found the answer to my question. There is an export option for editable rtf. Unfortunately this format does not recognize page breaks in the letters, creating another problem.

I haven't seen a recent comment on this although I know there was trouble with previous versions of Crystal. I upgraded to Crystal XI, using Oracle 10g. I want to export letters to Word format that allows some editing. My output no longer has the dreaded frames that I saw with Crystal 9 but...

Crystal 10. Oracle 10. I'm producing thank you letters as a Crystal export to pdf. The detail is variable and sometimes the white space is too large to suit the higher up. Is there any way of having a text block display in a larger font size if another text block is small? Or conversely...

I need some kind of flag for each record to say if their spouse is also in the record selection.

Crystal Reports 10 and Oracle. In a selection of records intended for mailing, all records are individuals not couples. Their spouses may or may not have been selected. Each record has an ID and a field for the spouse ID. How would I identify the existence of the spouses that have their own...

Crystal 10, Oracle. I need to produce a csv export to be compatible with another system. I knew about problems with page headers repeating and so I am suppressing report header and page header. When viewed in Crystal preview, each row is distinct at the group footer level (sort name). When...