Search results for query: *

Hello, I just got a task to edit/update the current clipper program and i do not know anything about it and after searching online i thought i would ask this forum for some guidance on where to start with regards what do i need to install to open the current program in editable mode and what do...

I have column that stores pipe delimited data like below and i want to split and create array and dispaly each index value in details section A1="test|fdsfas|testasdfa|asdfas" details test details fdsfas details testasdfa details asdfas how should i go about doing it? any ideas? Appreciate...

Hello I have dynamic parameter field that is based of County field (string type) and i would like to add additional value to show in the selection when the report is run. Currently County field has 10 values and i would like to add two additional values so user can select it. Values in County...

Hello, I have below data in a field and i would like to extract 100 mg/ml from it field data desired output drugname 10 mg/ml testname 10 mg/ml drug23 name test 0.1 unit/ml name 123 0.1 gram/ml is there pattern to match to use or other way of...

Hello, I am trying to write section expert formula to suppress any records that matches below pattern in name field. It is regular expression that matches on drug concentrations like 5 mg/ml 100 mg/ml "\d*\s?(mg)\/\s?mL" The name fields has below data values testname1 100mg/ml testname2 1...

Hello, Suddenly my formula popup to edit is not showing, it seems like it is hiding because when i click on other controls it gives me bang sound and nothing happens. I tried reset all toolbar on next restart it did not help. I sincerely appreciate it if someone can assist. Regards

Hello, Below is the formula and i am getting a number is required here error, can someone point me to the error. Whileprintingrecords; Local NumberVar topNode:=0; Local StringVar array comments:=""; Local NumberVar i; Local NumberVar InstLines := 0; If ToText({Client.Instructions})="" then...

Hello, I have two parameters ID and Name and i set default value to be one space and i would like to return results based on values entered for parameters, but user can only enter value for one parameters then the report should ignore second parameter and return results only based on one...

Hello, I have a field with pipe delimited and i am splitting it into array to loop through them. I need to display each element on one line on the group level. The group i have is ID group. ID is of table patient and Address is also of table patient which pipe delimited. for each ID i wanted...

Hi I have below incoming string and needs to be parsed and placed it in reverse order Incoming String labname1^labresults1^labname2^labresults2^labname3^labresults3 Output String labname3^labresults3^labname2^labresults2^labname1^labresults1 Appreciate feedback Regards

Hello I have to determine new clients based on the service date. If the client's minimum service date is greater than 1/1/2010 then they are considered new clients and they do not have any service prior to 1/1/2010 My table has below information ServiceRowId, ServiceDate...

Hello I am getting below when access list of providers on my web app, i really appreciate if any one can assist in troubleshooting this. Server Error in '/testsystem' Application. -------------------------------------------------------------------------------- Failed to enable constraints. One...

Hello I have Intel DQ35JO motherboard with XP home and as i plug lucent agere internal modem the pc does not boot. the boot stops after flashing bios screen. If i remove the modem the pc boots fine. I checked the device modem and there is no modems listed on it. I really appreciate your...

Hello I am trying to recover DBA password but not having any success. How do i know what encryption algorithm used to encrypt the password? Regards Armani

Hello I have four string field that i am trying to concatenate and it is not giving any value after doing so. No errors when saving it, but no result when displaying it. My formula is Field1 & Field2 & Field3 & Field4 I also tried using WhilePrintingRecords. If i remove Field3 and Field4 then...

Hello I am trying to find a column that i can use to join to other table but it is not showing, but the column appears when i try to drag and drop it on the report. The column type is crystal is showing as Memo and in sql server it is ntext. I see the column in sql server and also under...

Hello I have a field that contains data in below format {FFFFFFFF-0000-0000-0000-000000000463} {FFFFFFFF-0000-0000-0000-000000000463} {FFFFFFFF-0000-0000-0000-000000000463} {FFFFFFFF-0000-0000-0000-000000001576} {FFFFFFFF-0000-0000-0000-000000001576} {FFFFFFFF-0000-0000-0000-000000000606}...

Hello I need help in building pattern match for the strings given below. I need to look this up in input string and parse the string out based on pattern that will match below string. It does not need to be one pattern for all below it could be one pattern for each then i can put an or...

Hello I have a package that extracts data from 10 database that are have same structure and i am dynamically changing the connection in a foreach loop, but the package fails as soon as it encounters any errors and i would like to continue with next and log the errors in a flat file. I have sql...

Hello I have a string field that contains data like below med1 100mg med2 10mg med3 50mg i am interested in creating the formula called strength and extract 100mg, 10mg, 50mg etc from above data. mg is key here and get 3 to 4 characters on left of mg that will give me a number. regards...