Search results for query: *

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

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

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

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

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

There is a report option to substitute "default" for any null value in the database. "Help" says this is zero. But this doesn't make sense to me for a date field. 1. In a query or formula, what format do I use to reference this default/zero date value? 2. Is there a way to specify a default...

After I ran a report (in Crystal 11) utilizing LastFullMonth as the primary selection criterion I observed that it ran fine and produced correct data; then I published and scheduled a it (in InfoView). One time it ran and selected no data and another time it blew up complaining that...

I have a report where the input parameter passed to the main report is passed down to two subreports. I'm trying to find a way to pass a calculated date instead of the input date, but the "Change Subreport Links" window does not allow me to do that. I don't know what I'm doing wrong. Is there...

How should I format a specific date so I can use it in a formula?

The blurb returned by Crystal's "help" talks about "enforce" as though the person asking what it means knows what it means. I don't. 1. Does "enforce" cause the machine to do more work in selecting records? 2. What difference does it make whether a join is enforced? I have a report...