Search results for query: *

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...

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...

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 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...

Hi all, Last August I created a report using Crystal Reports XI. The report is one that displays the payers for each client. A client can have multiple payers. What I am trying to do is select all clients with payer #5000 and clients that have both #5000 and #1000 payer. The report has a date...

Hi All, I have created a report using crystal 11. This report calculates (sums) units billed and not billed. Billed units have a claim # and a 500 billing code. The not billed unit do not have a claim number and do not have a 500 billing code. I used the formulas below. The first formula works...

Hi all, I have created a report using Crystal Reports XI. The report is one that displays the payers for each client. A client can have multiple payers. What I am trying to do is select all clients with payer #5000 and clients that have both #5000 and #1000 payer. The report has a date range...

Hi All, I have created a report that contains treatment information in the detail section. I would like to print this information in the group or report footer because I need to have all the treatment services appear in a table like a cross-tab report even if they are not select in the input...

Hi All, I am attempting to create a report that displays the most recent assessment date (Maximum) and the next date after the most recent assessment date. I used the Running total to create the field. I summarized the activity service date. Type of summary Maximum. I used this formula to...

I am trying to create a flat file for an electronic data conversion to a new software system. I am using crystal x and our database is ms sql server 2005. Each field has a specific start position, length and data type. They must be in order e.g., {case no}, {lname}, {fname}, {dob}, etc. The file...

Hi all, I am trying unsuccesssfully to create a formula to sum the average of a field. I have created a worker productivity cross tab report which is based on services provided to our clients. One of the services we provide is group counseling. In a group there may be 10 clients and the total...