Search results for query: *

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

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

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

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

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

I have this form that updates a table once the user has tabbed to the end of the form and on to a new one. The problem comes when I try and add the data from a multi-select listbox to the field in the table. Instead of adding the data in the same record, it adds a new record with only the...

I couldn't find a concrete answer to my question in any of the other threads. I have a listbox that is supposed to populate a field in my database after the user has selected a choice. It works fine if the multiselect is set to 'None' but I needed to be Simple or Extended. If i do that, when...

Tek-Tippers, I have the following macro. I want to append the 3rd cell from the new record to the 3rd cell of the current record if all the cells in the new record are equal to the cells of the old record(but not cell(_,3). I thought this would do it but I'm getting a runtime error(Type...

Help, I am trying to replace my cdosys.dll file in my C:/Windows/system32 directory but I am unable to. Is there any way to replace it. I tried changing the permissions on the folders but the old cdosys.dll can't be deleted or overwritten. Thanks to all

I am a beginner with Crystal Reports Developer. How can I name a Database "Command". I know I can do this because I have seen other reports where they are named and arent simply "Command", "Command1", "Command2" or so on. Thanks to all

Hey TEk-Tippers, Whats a decent laptop out there. From what I know Toshiba's were always a good choice, but I love Sony's. Any suggestions? Also is buying one at Best Buy a good decision? Thanks to all!

I have the following rows Account Tin Action 111111 4444444 111111 4444444 disregard 111111 4444444 checked I need to keep rows where there is no action. If there is an action and it is fixed, I need to keep that one instead. I have come up with the programming logic...

I am fairly new to programming. Is there a way to delimit the following record by position, or how should I go. The mainframe file is being FTP'd to my machine, VB.net program reads it and for reporting purposes I need the 828, 804 field, can anyone help in how to put this into an array...

I am fairly new to programming. Is there a way to delimit the following record by position, or how should I go. The mainframe file is being FTP'd to my machine, VB.net program reads it and for reporting purposes I need the 828, 804 field, can anyone help in how to put this into an array...