Search results for query: *

Thanks for your replies PHV and SamBones. I tried variations of your recommendations and it still won't work. Again, I can easily avoid this by loading the file containing the function, but we are trying to avoid this. Any help is appreciated.

I have a function "fnd" in my .profile file. I have shell script check.sh calling function "fnd" but it doesn't recognize the file unless I load the .profile file. I don't have to do this when referencing variables in my .profile file but can't get it to work without loading the file for my...

lbass, You're awesome!!! It worked! I've delivered migraines over this issue. Can you briefly explain the logic behind the code in the running total? I'm no expert in formulas. ( onfirstrecord or {table.tran_acct} <> previous({table.tran_acct}) ) and sum(@withdrawcnt},{table.tran_acct}) > 0...

lbass, thanks for your reply. I don't have a problem summing the count of withdrawals. The problem I have is that I can't sum the balance. I don't have anything appearing in my detail section. I have one group, account. The balance that appears in this group is a formula. The formula is...

Can someone please help with this problem?

I couldn’t find an answer to my question in any of the posts. So I ask for your help. Crystal 9 Three tables: Account_Balance Account_Transaction Account_Profile All joined on account. I have 1 group (account) on my report and I display the following in the Group Sections., but I only display...

I would appreciate a helpful suggestion to a problem I am facing. Management wants a report that tells how many of our transactions were processed manually vs. automatically for the last year. They want it broken down by month and a Total. This involves reading 1.5 million records from a...

Thanks to all of you! I will try these solutions and see how it works out.

Also I forgot to mention, I only want to do comparison where the SSN has more than one record.

Sorry about that. I just didn't think the query was relevant but here is the real thing. SELECT profile.ssn, profile.name1, profile.name2, profile.name3, profile.name4, addr_profile.addr1, addr_profile.addr2, addr_profile.addr3, addr_profile.addr4, addr_profile.addr_inst...

I need to know if there is any way to do this in Crystal. I have a query that is irrelevant to my question, but I need to compare records based on that query. Here are sample records... GROUP ID SSN ADDRESS City 111 123456789 4906 October Dr. Chicago 111 123456789 4906...

Thanks Bob! Simple solution!

Thanks Bob, but where and how would I code that? Thanks, Rod

I am exporting a report to Excel and everything looks fine, except that I have a field, Social Security Numbers, where it doesn't keep the format once it has been exported to Excel. For example, SSN 0012345678 in Access will export to 1234567 deleting all the leading 0s I checked the data type...

Thank you both PCLewis and PHV. Your questions and comments helped me find out what was wrong. It was in my For Loop logic I only need to scan the array for Array.Length -1 since I am already comparing the last entry in the array when I add i+1. Thank you very much, sometimes the solution is...

PCLewis, Thanks for the reply. It helps to get advice on my programming style. All my variables are initialized to 1, with the exception of 'y'. It is the array length. I have 'Option base 1' so I won't get more confused with the 0s. The problem I have is that even when the values in array are...

PHV thanks for the tip. The problem is that it goes into the first IF statement at all times, whether the values in the array are equal or not. Is there an array property I'm missing? Thanks, Hector

Hi, I am looping through the array and comparing values but it doesn't seem to work? Can someone please help? Ive looked at it for hours and Im sure its something dumb. For i = 1 To y If myArray(i, 4) <> myArray((i + 1), 4) Then For j = 1 To y For k = 1 To 4...

Thanks gol4 for the reply. I understand the whole concept of designing a normalized database and enforcing referential integrity in your tables. But perhaps I am not making it clear, there isn't a need for a well designed database. This is just a temporary table that will act as a dataset for...

Thanks gol4, What will the update query look like? I know my database is not normalized, I dont have a normalized database and neither does it enforce referential integrity. This is just one big table in temporary use. But I really need to know how to successfully update a table field with...