Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: talibm
  • Content: Threads
  • Order by date
  1. talibm

    Select Statement If survey both an Initial and Termination Survey

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

    Multiple If Statements

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

    datetime data type resulted in an out-of-range datetime value

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

    Convert String to Time

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

    Selecting Records within Group Selection Criteria

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

    If Then Statment Not Working

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

    Selecting Records with Different Values

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

    Print values From Detail Section in Footer

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

    Next Date After Maximum Date

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

    Flat File Export

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

    Sum of Group average

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

Part and Inventory Search

Back
Top