Search results for query: *

Thank you for the idea, but this didn't work with the Command. I tried... If you have any other ideas, I'd love to hear them!

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

Thank you - it took me a while to get back to this, but it worked perfectly!!!

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

WHOOOOO HOOOOO! Success. Thank you Thank you Thank you!!!

Thank you for all of your assistance. I do truly appreciate it! I have two groups – GroupHeader 1) for a court name, and GroupHeader2) for a concatenated {filename and filenumber} group. My reset formulas are in GroupHeader 1. My GroupHeader 2a contains the guts of the report, along with...

I do have reset formulas in place in the correct location. However, when I apply your fomula, I suppress the subreport figures. I need to supress the main report information also. I actually have two subreports, amountsaved1 and amountsaved 2. If both of these subreports come back with...

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