Recent content by manrique83

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