Recent content by T1na

Thank you for your help.

I have got a time which displays in Mins (1590) but would like it to display Days, Hrs and Mins (1 Day, 2 hrs, 30 Mins). How do I change it? Thanks

Thank you for your help, my report is now working.

Thank you. I have tried this, I am getting the correct start date but the end date is showing 20/07/2009 which is from the wrong record (record 3). The record that I require is blank (record 1).

When running the report I will select the Base via a parameter {Base_Name). I then want the most recent record for that base. I can get the correct start date to pull out using north largest but can not get the correct end date.

Having problems getting the results that I need can anyone help? I have got a School attendance report which runs between dates. Between the dates I want the School history pulling out for the School that has been selected. It seems to work for all students apart from the ones that have been...

In Crystal 11 I would like to calculate the date and hours between a start{datetimefield} and end {datetimefield}. I know about the datediff but need a little help with the time.

We have a surname field that has two names in it e.g. Bob Jones the space is causing problems in validation. How do I take the space out and replace the space with a – so will receive the following result Bob-Jones.

It is the only thing I can think of doing? Anyone got any other ideas? Got a test machine so it really does not matter if I do mess it up.

I am running 8.5. Could I replace some dll from 6 or 7 so the export will work? If so does anyone know which dll's?

I am also having this problem. When I export to word everything is in text boxes. The user needs to make changes to the report and it is very hard with the text boxes. Can anyone please tell me how I can still export to word, keep the same format and get rid of the text boxes?

I did not explain myself very well. By putting in the last.Stud_ID I was not referring to a field I meant that I want to pull out the record that is greater that the last number entered into the system. The only tracking that I have is the stud ID. Every time a new student is added they are...

Having problems with SQL, what I want is sql alert that pulls off students that are year 6 and new to our system. Is there any function in SQL that I can pickup students that are greater than the late student.id that is in the system So far I have got: SELECT STUDENT.FORENAME...

Thank you for replying. I seem to have sorted this out using true and false and suppressing the paragraph if false. Thank you for your help Tina

I am using the if then else function but the string that I have put in is to long and I receive the following warning: There are too many characters in this string. I have tried to split the string but don’t seem to be having any luck. Please help