Search results for query: *

We are using Crystal Reports 9. I have a report in Crystal Reports 9 which runs in our "Test" environment, which is used for developing reports. However, I need to change this report over to our "production" environment. The report is a SQL command that has been dropped into the command...

I am using CR9 against a database on a SQL server. I have a report where I list a starting time (a DateTime field). I need to add the duration to that DateTime field to create an ending time. The problem I am encountering is that the duration is two separate number fields (created with...

We are trying to come up with a number of cases "pending" at the end of a month in our legal organization. We are using CR9. We use a complicated system of "statuses" which contains "Open, Re-Opened, Closed, Re-Closed, Collection, Request Date, Received, Transferred in, Transferred out, To FO...

What is the syntax for "no record found" in Crystal"? We are writing a pending report and the pending formula is returning one record when there is none. We are trying to suppress various things in our checkbreak such as OnFirstRecord and OnLastRecord, else... However, we need the syntax...

I am attempting to write a SQL expression so that I can group results in a report by "months open," i.e., 0-6 months, 6-12 months, etc. I am getting an error when I attempt to save this. Any suggestions what I am doing incorrectly? Somone gave me this SQL expression, but it's not working...

I am working on a report in CR9 where I have written a formula to pass a variable from a subreport to my main report. This is working and the information is displaying correctly. I now need to write a formula? to limit my records returning in the main report to those that have $$ associated...