Search results for query: *

Oh, and here's my formula: StringVar statusCodes; //WhilePrintingRecords; if OnFirstRecord then statusCodes:={Command.CYCLE_HISTORY_STATUS_CODE} else if //(not OnFirstRecord) and {Command.CRIMINAL_CYCLE_ID} <> previous({Command.CRIMINAL_CYCLE_ID}) then...

Report has detail plus two group levels. My formula concatenates string values from detail level such that at the end it contains every value from the column in a single string. It is working absolutely perfectly ... only on the detail lines. Problem is, the formula evaluates again between the...

Woohoo!. You are da man!!!!! Thank you. Thank you for being so SO patient, and re-explaining so this dense old coot finally GOT it.

Well, here's a sketchy example. Above the line of equal signs represents my main report. Below that represents what the user now wants to see as a recap in addition to the main report. FBI DCJS Corporation-1 Trans-1 1 1 Trans-2 0 4 Trans-3 1 0 Trans-4 1 0 Corp-1 subT 3 5...

Thank you. OK. I'll talk with a techie to find out if there's a way to attach a picture, screen-shot or file. (Have a nice week-end, LBASS.)

No. What I mean is that it shows the corporation name and for each corp. it shows the sum of the dollar values. But it omits column for DCJSFEE subtotals and for FBIFEE subtotals.

Tried that just now. It looks perfect except that it doesn't have any DCJSFEE or FBIFEE amounts.

Thank you LBASS. My row is a field called corporationname. My columns are numeric fields called DCJSFEE and FBIFEE. My summary is the sum of those two fee fields. The main report groups on corporationname and lists the fees for each individual associated with that corp. Then it has a...

thread766-1488292 My problem is very similar to what the user described in the cited thread. I have a 2-group tabular report containing sub-totals at the bottom of each group. User wants a recap of all the sub-total lines. I know I can easily do that as a sub-report, but to the best of my...

If it's a matter of a particular widget being counted once in more than one row but counted only once in the totals row, then wouldn't the total in that column be less than the sum of the rows of that column? And wouldn't the grand total be less than the sum of the row totals? And, if Crystal's...

The sum error problem is where a single column adds up to 1 count less than what Crystal shows as the columns total. Since every row of the column has the same formula as their total row, I don't see how it's possible for Crystal to add them wrong. I also cross-checked every single row, and...

1. Well, the numbers certainly should be integers as they are supposedly plain vanilla "distinct counts". 2. I can't comprehend how the way the crosstab is set up can possibly have anything to do with whether a count of zero can ever be more than zero percent of anything. Are you saying you can...

Problem #1. In the report totals row, Crystal adds 154 + 1 + 50 +126 +8010 +618 and claims the sum is 8958 instead of 8959. Problem #2. Throughout the report, counts of zero are shown as being a non-zero percent of the row total. Since the report merely counts, and all the tallies are...

Thank you very much. "dateadd" is exactly what I needed. (As for the "yyyy" parameter I was trying to use in the datepart function, that was specified in Crystal's "help" document.)

User wants to compare data in a current period to data in the same period a year earlier. Current period is defined by begin and end parameters. What's a good way to calculate the begin and end of the prior date range? I tried the following (for the begin date) but Crystal complains that...

Thank you. Here's what appears to be working right: WhilePrintingRecords; local NumberVar t; if OnLastRecord then t:=9; if t=0 and //(not (nextisnull({FINGERPRINT_TRANSACTION.TRANSACTIONID}))) and {FINGERPRINT_TRANSACTION.TRANSACTIONID} = next({FINGERPRINT_TRANSACTION.TRANSACTIONID})...

Thank you for your patience. It's very complicated. Any input transaction can have any number of joined rejection rows. User wants to count all distinct rejection events in the time period in addition to all initial transactions in the time period. Distinctness of the rejection event is...

Thank you. (I didn't even know there was a nextisnull function.) The formula I designed says something like this: IF FID <> NEXT(FID) THEN 0 ELSE IF DATE IN BEGINDATE TO ENDDATE THEN 1; So adding "OR nextisnull(fid)" to the first IF would yield invalid results if the fid isn't duplicated and the...

What results are returned for IF fid <> NEXT(fid) when there is no "next" row? thatis, the fid is already in the last/final row? I tried pairing the above inequality with "not OnLastRocord" but it behaves like I might expect if the NEXT(fid) part was returning a null resulting in an...

View SQL query shows me a query which specifies a hard-coded date range (from 2004) even though there is no explicit criteria specified either in the ADD clause or in record/group selection. I don't know how that query got there, and I need to either modify it or else delete the whole thing...