Search results for query: *

Hi: My customer is using our software, which uses the Crystal Viewer to view reports. When trying to view a report, they can not even open it. They get the error: "An unknown error has occurred in the report engine. The error code is 997." They don't have Norton Anti-virus...they use CA...

Hello: I have created a report where I am displaying fields from the database: Sequence #, Account, Amount, Site ID. However, I need only the ones that have more than one record with combination of Sequence # and Account (ex. Seq # 202 with Account 34567). First, I wrote a formula (@SeqAcct)...

Hello: I edited a working report in Crystal Reports 8 by changing the groups to add one in as Group 2 and move the other groups down (Group 2 became Group 3, ect). Other than that and making a subtotal for the new group in the footer, I didn't change anything. The old working report does...

Hi! I am trying to redo an old report. My report is grouped by endpoint (suppressed), lists account numbers and associated amounts in details A section, and has an item total and amount total at the botton of each page in a details B section. Using this format, I tried to make a count formula...

Hi! I am trying to count records but can never get my totals right! I am trying to count records except for those whose RunTable.DebCred = P, but resetting at P or a new endpoint. The #PageCount used below counts the records and evaluates RunTable.DebCred in "D" and "C&quot...

Hi everyone! My report has a parameter called ReportType. ReportType is set equal to a field called StatusCode, which has three values to select from: 'C', 'R', and 'P'. My problem is that when I select 'P', I would like to see data for 'P' and 'R' both on the report. So in effect, with my...

I have a field called Account, which is also my Group 1. Unfortunately, the same account number has been keyed in normally (ex. 52001) and with zeros (0052001). Crystal Reports sees this as two different numbers and so the same account appears twice on my report. How do I write a formula...

I have written a report with a formula that counts the Amount field and resets when it hits a certain number. My problem is I need to have this certain number print with each amount except on the last record in the group (which would print the remainder). To clarify: assuming this...

I need a formula that will count a field (Amount) and reset when it reaches the number in a field (Page Count), or if it does not exceed the Page Count it will show it's count. The report is grouped and I must do this within those groups. Example: (The Page Count is equal to 155) GROUP 1...

My boss is trying to unistall CR version 8 because it's conflicting with another program. But, she it will not let her uninstall because it insists on having the install CD, which was lost long ago. Please help!

Hi, I have fields ExpenseID and Amount where a certain ExpenseID corresponds with a certain amount. I would like to sum the amounts that are only for certain ExpenseID's (for example, 13-15). I am using version 7. Any help is appreciated.

Hi, I need to create a version 7 report that will show me data for today (I guess that would be currentdate) and for Month To Date, which would need to reset at the first of the month. I will have one field which will show me how many items I have today and how many I have month to date and...

Hi, I have an amount field that is supposed to be summed according to an item field. The item field is the number of items on one page and the sum (formula) is supposed to reflect the total amount for that page. I have the item field in the details section and that is where I will place the...