Search results for query: *

Hi Products: Office 365 Enterprise E1 ,NHSmail 2 , Windows 10 and Community cloud using Azure Investigating Office 365 for a NHS CCG. They are using NHSmail2 and will no doubt be using this until 2020. I am investigating benefits and deployment of O365 having own tenancy on a community cloud...

GM 9 office 2007 word Hi Clients double clicks on GM template, prints off document , doesn't save. But word is creating a obscure number file name with file type as dotx in My Documents Any ideas how to turn this off your help is most appreciated

MYSQL 5 Hi everyone Wonder if you could help me have a table with 5 field startdate, enddate, dose, equipment, patient Data is set out as such startdate - enddate - Dose -- Equipment - Patient 01/01/2010 01/02/2011 15 iv 101A 01/02/2011 01/03/2011 15...

Hi Everyone CR 11 MySQL Have a report where a person attends 2-3 appoinments every week, they must attend on the correct days of the week ie Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. I have 3 fields with the relevant day in Shift1, shift2, and shift3. ( if they only...

Hi MYSQL 5.2 I have two queries that pull dates out from different table One date comes from ob_table the other from HB_table both dates look for an interval from now to -91 days both queries work well. I now need to join the queries together to get the HB date where there is an...

Mysql 5.2 Good Afternoon all have a field which is a string that I need to convert to a number. in crystal I would convert the field as such val({doses}). I can use the VAL() statement to strip out the non numberic characters. can this be done in mysql the characters I want to strip out are...

Hi Everyone Crystal Reports 11 MYSQL 5.2 Created a sql query that joins two areas together. Have created set variables that work perfectly in MYSQL but when putting into crystal they are not liking them. Please you tell me what I am doing wrong. Thank you for all your time. The set@i create a...

Good Afternoon Crystal 11 MYSQL 5.2 In mysql to declare a set I use @ at the beginning, problem I have there is Crystal doen't understand this, what do I use instead of @ my code as follows set @i = -1; set @StartDate = '2012-07-01'; set @EndDate = '2012-07-31'; ##Combined Data SELECT...

Hi Everyone Crystal Reports 11 MYSQL 5.2 Created a sql query that joins two areas together. Have created set variables that work perfectly in MYSQL but when putting into crystal they are not liking them. Please you tell me what I am doing wrong. Thank you for all your time. The set@i create a...

Hi Everyone Crystal Reports 11 MYSQL 5.2 Created a sql query that joins two areas together. Have created set variables that work perfectly in MYSQL but when putting into crystal they are not liking them. Please you tell me what I am doing wrong. Thank you for all your time. The set@i create a...

Good Day Crystall 11 I have multple data from different formulars that need to be shown on four line only. I have created the formulars for each entry if {Command.Mode} <> 'HD' or {Command.Mode} <> 'RIP' and {@PTHTest} = 1 Then 'PTH' else '' this gives me 30 fields, yes I could create a...

Crystal reports 11 Mysql 5.2 vital plus system within vital plus system using crystal reports viewer have patients record open and run a report against this patient for prescriptions The report looks for patient then links to their medication table and only shows the drugs they have been...

Good morning everyone your help would be most appreciated in the following problem I am having. HD_OBs (FK_oid is the main link this is the Patientid) select oid, fk_oid, DIDAT as HDDate, haloc as location, access_used from p_anthropometry order by didat desc; -- HD_Prescription...

Crystal Reports 11 MYSQL 5.2 Hi Everyone -- HD_OBs (FK_oid is the main link this is the Patientid) select oid, fk_oid, DIDAT as HDDate, haloc as location, access_used from p_anthropometry order by didat desc; -- HD_Prescription (FK_oid is the main link this is the Patientid) select...

Crystal 11 using sql commands Have a 3 page report 1st page always gets printed Page 2 only gets printed if Patient = HD Page 3 an extended page only gets printed if user requires it 1st page is simple #2nd page will depend on a formular, but what formular do I need to use for printing #3rd...

-- HD_OBs (FK_oid is the main link this is the Patientid) select oid, fk_oid, DIDAT as HDDate, haloc as location, access_used from p_anthropometry order by didat desc; -- HD_Prescription (FK_oid is the main link this is the Patientid) select oid, fk_oid, HWDATE, HWOACC from...

A big thank you for everyones help Have data that is recorded several time each month. need to be able to pull out month difference I know I can put them into a detail(as there can be 10-15 different entries each month), then group on date field monthly but I need to be able to show the weight...

Have data that is recorded several time each month. need to be able to pull out month difference A big thank you for everyones help I know I can put them into a detail(as there can be 10-15 different entries each month), then group on date field monthly but I need to be able to show the weight...

Hi all Crystal 11 using a sql view and crystal command I have a report that show dates and weights need to be able to show the difference in weight loss or gained. (IDEALLY Would like it to take the pre date first and then show + or - from Post weight before the date of the pre weight from...

Hi everyone, newbie to this as you can see from my last correspondence. have a table which show rows 'patient id', 'date' , 'weight', 'post or pre' need to do a query that show last date entry, pre weight at the time of that entry, also the post weight of the entry before, then I can...