Search results for query: *

CRv11 I want a Crosstab for each Person Identified in a survey giving a summary of how they were evaluated on 10 questions. This should be easy but.... The 'Person' is identified by a multiple select in Question1. The table looks like this: RESPONSES(Question, Answer, Respondent)...

I have two tables linked appropriately to return all records from the Primary(Table A)& just matching from Secondary(Table B). I gives me exactly the records I need. But, now I need to evaluate based on the field(singular) that I am pulling from Table B. since its niether NULL nor valued, I...

How do I convert a DateTime to an Unseperated string? 2006-03-30 07:00:05 to 200603300700(yyyymmddhhmm) I got a DateTime to 20060330 by Convert(nchar(8),table.field,112) but now I need to include the time.

Using CR8.5 Main report shows OR Case info sorted by StartDateTime for all ORs in a given daterange. I need to compute Room turnover time. Tried a SubRpt linked by date & room and was able to compute Turnover's with a Start-Previous(End) formula. But could not pass it to the MainRpt tied to the...

I'm trying to adapt code from thread183-1089209 but dont seem to be getting it. Basically, I'm trying to show multiple shift assignments on a single row. I have two tables: NURS with the ID STAFF with the SHIFT Assignments My adaptation is dorked: SELECT N.ANSOS_ID,N.NURS_NAME...

I had to write a report in CR9 to get the CrossTables with %percentages, but the distribution (CE9) is not available to the User. Do I have to re-write everything from scratch in CR8.5 . Or is there any shortcut. I cant believe theres no "Save As" older version functionality

I'm sure this must be easy...but I'm loopy How can I determine the number of Day(2)(Mondays) in a date range. I had a RunningTotal of Day(2), but it misses the day if there is no datarecord on that day.

I want to create a parameter in CR8.5 that allows the User to select which Quarter(daterange)...can I use a Function like 'Calendar3rdQtr'?

I can do a crosstab that gives count of each ans' for each question. However I need to give the counts per employee, who is a multiple-answer for Question 1. So a response could have two or more employees listed. Response table-ie: RespondentID QuestionID AnswerID AnswerText 3...

New CE setup...just got NT authentication working, but now I've got @20 blank User Folders with my ID in CMC. The system seems to create a new folder each login. In CMC, when attempting to Delete any User Folder it says: "Update Error: Invalid operation on Favorites Folders'. HELP ME GET THIS...

OK, I can query data from SQL for a report, but can the user then enter text(not to any db field)such as comments at the bottom? To compound the question, if the user only has the runtime version & not the Designer software....can they run the report then enter text?

I'm sure this must be simple, but cant seem to figure it out. How can I get a report of TableNames, LastModified, & RecordCount for the database?

My report is grouped by DATE & STAFF, & shows each EVENT assigned. How do I show only those STAFF with more than one EVENT on a DATE?

Am I dreaming or is there a way to enter a function in a report that will execute an export of data to flat file. (Instead of making user go thru the export process each time)

I am compiling a report for a user that has previous distributed reports(no Crystal app installed). The users pc shows numbers w/2 decimal places...mine does not. Tried variations of TRUNCATE/ROUND/FIX statements to force the format to whole number...no joy. Any suggestions?

The field contains 1-3 5-char codes delimited by 'cr/lf'. How can I display the contents on a single line?

Here's the scenerio: Table has: TestID(unique), ClientID, TestType, TestDate, Score. How do I query to get just the latest score for specific TestType? My report already pulls other client data from other tables, but now I need to add latest test scores. Please advise. Thanks

In a sub-report, I have one field running total working & eliminating duplicates using a Next statement, but now I need another field counted...but its not sorted in order like the first. The data duplicates in this field every 2nd or 3rd record........How can I get a check of the 2nd or third...

Patients are grouped by Impairment(in my case "mentally"). Impairment is in table with 3 records/patient(one for each Assessment type). The third Assessment type always leaves the Impairment blank. How can I include the third Assessment in Group along with the rest of its assoc patient...

Here's the jist: One-to-many relationship PATIENT to ASSESSMENT tables. ASSESSMENT Table has eighteen fields(ie: WALKING, STANDING, EATING, SLEEPING...) Each Patient has two or three assessments(Admit, Discharge, Followup). I need my report to look something like: Walking Admit...