Search results for query: *

Hi, I have created a report in Crystal 13. I have a formula that is used to tell how many days between two dates. The "Admit Date" is constant, but the second date could have multiple values. I am using the minimum(second date) in my datediff. The first formula is to get the minimum date...

I have a SQL 2005 database that I want to use a trigger to update a column in one table base on data from the previous day. The data in this table is inserted via a bulk insert command. bulk insert BILLING_TABLE from 'c:\ftpfiles\cur_cens2.txt' There is one column that will be empty upon...

I am using Python 3.1. I am trying to start a process (.exe) on a remote server. I am running the script from another server. When I run this code, the process starts on the remote server and can be seen in the processes in the task manager. I need this process to be visible so I can monitor...

I am trying to do something that I am sure is simple, but I have not work with VBScript much at all. I want to open a text file in one directory and save as to another directory with a new name. When I run this code from a cmd prompt, I do not get an error, it just executes and does nothing in...

Hi, I have an Access 2003 database that uses SQL 2005 linked tables. I have no problem opening the database and viewing the data, but if I want to add a record to the table or update a record, I can not do it. The options to insert a record are grayed out. The SQL tables are linked via ODBC...

Hi, I have a string that looks like this. Patient Transferred to:CSCU I want to split out the data from the right side of the :. I tried this, but it did not works. split(description,":")[1] This returns Patient Transferred to. I want to get CSCU. Can anyone help with this function. Thank you

I have a trigger that I created that I want to update my Billing_Table.DISCHARGE_DT with a value that was inserted into my DISCHARGE_TABLE. The date in the DISCHARGE_TABLE is inserted via a Bulk Insert from a txt file. The trigger parses fine, but it does not update the...

Hi, I have a SQL 2005 database that has an Access 2003 front end. I am using linked tables in Access. What I am trying to do is have the user input data from Access into the SQL server database. The field that they are entering will be stored in one table, but I need it to populate another...

I have an Access 2003 database that created by someone else. When I go to the Database Window, I can not edit Reports or Forms. I can get into design for the tables, queries, and macros. The database is saved as a mdb, not a mde. Does anyone know why this is?

I have a DateTime field that I need to use in my Where statement. I need to use it as a Date. I want to say that a Charge Date is Date -1. That will give me yesterdays date. How do I convert the date time to date? Thank you On Error Resume Next Set...

We are using CE 10. I have a report that has two datasources. There are multiple sub-reports also. The report was created using Crystal 10. I run this report using RAS viewing it in IE. I have an ASP page that was created from the CE example page that contains the login information to the...

I am trying to create a formula in Crystal 10. The database is Oracle 9i. I have a field in my database that is stored as a number. I am trying to create a formula to convert that number to a Date Time. I know that 7599128320 = 01/22/2008 07:52. I just can not figure out how to get my...

I hope someone can help me get started on this. I wish I knew all of the terminology to use for this, but I have limited knowledge of Crystal Enterise 10. I am trying to figure this out as the person who created it is no longer around. He is my problem. I have a Crystal report ( Crystal 10) that...

I hope someone can help me get started on this. I wish I knew all of the terminology to use for this, but I have limited knowledge of Crystal Enterise 10. I am trying to figure this out as the person who created it is no longer around. He is my problem. I have a Crystal report ( Crystal 10) that...

I am trying to figure out how to pass three differnt ODBC logins and passwords so the report can be viewed over the web. I can make it work fine with one subreport. I can not figure out how to make it work with a second subreport from a different data source. We are using Crystal Enterprise...

We are using Crystal Enterprise 10.0. I am having trouble with adding more than one subreport to the report. I have a connection for the main report and the 1st subreport. I do not know how to create a connection for the 2nd sub report. Has anyone ever done this? Thank you

We currently view Crystal Reports via CE 10 using Internet Explorer. We have these ASP pages that contain the login information for the ODBC connections used in the reports. That information is passed in IE so the user does not have to enter login information. We had to modify the ASP page so...

Does anyone know where to turn off auto link in SQL 2005 Visual Studio? I am adding multiple table and it is linking them automatically. Thank you

I am using Access 2000. I have a form that is built to input or select an account number. When that number is selected, the fields in the form are populated with the records asociated with that particular account number. My problem is that if an account number has more than one record...

I am using Crystal 10. The database is MSSQL Server. I have a report that I am modifying. It has a formula that uses the word FORMULA in it. I am trying to copy the formula and reuse it to create another formula. When I copy and paste it, the word FORMULA is not recognized as in the...