Search results for query: *

Thank you LB. Worked like a charm.I really appreciate you help' talib Stay safe and healthy

The report is group by program value and client PATID number. summaries are for each client and program in the respective group footers. thanks

Thanks guys for you response and I apologize for the lack of details. We have a crystal report that has two table, episode_history and worker_rating1. The episode_history table contains program data and the worker_rating1 table contains the survey data. The database is Cache. The...

We have created a survey data collection form. The Survey type field is single select field. It has values initial, 30 day, 90 day, 6 month, 9 month and Termination. I am trying to select just the data for Surveys that have an initial and termination surveys. We have calculated scoring for each...

Hello LB, Your suggestion worked like a charm. You're the best. Thank you very much!

The {Answer.QuestionUid} = 9993 and {Answer.Answer} = "1" represents the number of years the client has been employed. I need to be able to combine the number of HS-GED or No-HS_GED responses with the corresponding number of years. These are the actual formulas I need to combine and then...

Hi All, I have a Crustal Report (2013 that pulls data from a sql database. I have created several formulas that I need to combine calculate the number of client that have a high school deploma/ged and clients that do not have a high school diploma/ged. {Answer.QuestionUid} = 10039 and...

Hello Skip, The answer.answer field that I am try to convert to datetime is a varchar data type that allows nulls. Any suggestions? thanks

Hi All, I am a novice at sql and would appreciate it if someone can help me with a view that am trying to create us ms sql 2005. I am trying to convert a varchar field to convert it to time field using a datetime. the syntax check validates the view, but when I try to execute the view I get an...

Hi Pete, Thanks for your help. I apologize for my lack of information at the outset. The tables that i am trying to get the data from were created from a web application. Each question has a tag/row and the response to all questions is collected in the answer field which is a memo field. Having...

the section names represent the tab in the web page when the data is input. The Preamble section in the first section where the interview begins and the Motivation section is where the end time is located. The modified formula that i posted works. It give me the correct times, but I cannot get...

I am trying to explain. Maybe not well enough. Anyway thanks for your time. talib

Hi guys, Maybe I need to take a step back and give you more background info. The data that I have is entered via a web application that was created for us by a 3rd party. There are 3 tables that I am using. The interview table, the question table and the answer table. The interview date , start...

Hi guys, The reason for the start time and end time reflect the office hours for this program. 8 am to 5 pm. The building opens at 8 and closes a 5. First let me say that all the times show as am, except 12:00 to 12:59, when I converted the string to a time field. So that time period is omitted...

Hello guys, one last hurdle. My datediff formula, DateDiff ("n", {@end_date_time}, {@start_date_time}), is returning 0.00. What am I missing here? thanks talib

Hi Pete and Skip, I took Skip's suggestion and it worked just the way I had hoped(see below). Thank you for the time and knowledge . Now if I can get my datadiff formula to work I'll be in business. Thanks again, talib Interview start time: if {@start_time} >= Time(01,00,00) and {@start_time}...

Hello Pete and Skip, I tried the concatenation that you suggested Pete, but I can't convert that to a time filed. The reason for the conversion is that I need to calculate the total time of the interview. So I have an interview start time and and interview end time. I am trying to convert the...

Hello Pete, The data comes from a web application we use for interviewing clients. The field, tag q4, is a string that has the time 1:00 and another field, tag 4a, has the prefix am or pm. I have converted the string for the time using ctime only using q4 and not using qa for the prefix. ctime...

Sorry about that. So for example the string is "11:30" should be 11:30 AM and ctime give me that, but when the string is "1:00" ctime give me 1:00 AM and I want it to show 1:00 PM. For all the fields before noon ("12:00) we need AM and from "12:00" on we need PM. thanks talib

Hi All I have created a report using Crystal Reports XI. The database was created using sql. The time field is a string and I converted it to a time field using ctime. the problem is that it displays 1:00 as AM when it is actually PM. I tried unsuccessfully to correct this using Format Field...