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

Thank you all so much for your replies. I am not a programmer nor have I had any training in Crystal Reports so I found COSpringsGuy suggestion on grouping and LBass' formula (except change to: count({@SeqAcct},{@SeqAcct}) < 1) to be the simpliest solution for me. I am very happy to say it...

Thank you for your reply. No, I want to display only the items where the Seq # and Account (first two fields) are duplicates and then list each duplicate record. The other two fields I listed in the example can be unique. The way my suppression formula is now, it does elimate the unique...

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

Thanks for responding, Ido! I put the whileprintingrecords in my formula and I tried putting my other formulas in the sections you recommended but it still isn't working right. For some reason, the report has a problem resetting every time it hits P in the DebCred field. If the report hits a...

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

K, Here is some sample data: 090123345 5235-4543 $45.50 090123350 6566-8646 $322.54 090124500 9867-8868 $78.36 090135650 7632-0989 $32.75 4 Items The records are numbers assigned to an item, the account number for the item, and amount of item. DebCred is Debits and Credits...

Hi K, and thank you very much for responding! :-) I apologize....I am trying to alter someone else's report and haven't given all the info you needed. I was testing the aforementioned count formula in the Details A section next to the records being counted to see where I was going wrong, but...

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 &quot;D&quot; and &quot;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...

Thanks so much! It worked! [2thumbsup]

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

Hooray! I have some formulas in there and I have the numbers counting the amounts and resetting at the value in the Page Count field! Unfortunately, I still need to figure out the code to make the remainder appear and then a code used in Details under Suppression to make only the count = Page...

Thank you both for your responses! The output will look like the example above--even if there are pages of amounts. I appreciate your theory, SV, and it sounds exactly like what I need to do. However, I have very little knowledge of code so I need to look up how to say what I want. By the...

To answer synapsevampire's question, the Page Count is a number field that is usually set by a client in their database. I need to count the Amounts until they reach whatever is in the Page Count field (the example was 155) and then have the count reset and continue counting. If what is left...

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!

Thank you both for your help. My report is finished! :-D