Search results for query: *

Thanks lbass! That was it. I should have figured that one out... I appreciate your time!!

I saw various entries on converting number to time (but nothing specific to minutes)... I am using Crystal 2008. I have a number value {Location_Appointment_Type.Lead_Time_Length} that I want to subtract from a datetime value {Appointment.Start_Date}. Specifically, it is to create a begin...

Excellent, that did it!! Thanks again lbass.

lbass- What if I want the final value (on my main report) to be a datevar instead of a stringvar? I tried to just covert via CDate, but this isn't working. I need to be able to evaluate the date to see if it is in a specific date range. Thanks!

This seems to be working lbass (except my report keeps crashing) so I may need to get back to you on this. I'll report back either way. Thanks! You are "the master"!!

Thanks lbass (you have helped a few time before :)), Q. Please explain the location of the sub in the main report--what report section, and how it is linked to the main report--on what field(s). A. The subreport is in Group Header #5a (Group 1 is Unit, Group 2 is Worker, Group 3 is Case ID...

I am using Crystal XI. I have a report pulling contact dates into the main report from a subreport. In the main report, I wish to evaluate the contact date(s) to see if they are within a service authorization range. If they are in the range then will be assigned hours to determine a workload...

I figured it out myself (I knew it was simple). Go into the Group Expert, click on group you want to repeat, then the options tab and select repeat group header on each page.

I want to repeat one of my headers am using the formula: If InRepeatedGroupHeader Then 'Continued...' Else '' but it's not working. What else do I need to do? DS

I am using XI. The subreport is in Group Footer #4 (the client grouping) and is linked to the main report by a client ID parameter. The headings are not in the subreport. I did try to suppress null values in subreport from entering the main report, but this did not help and in fact removed some...

I am trouble shooting an old report I inherited. The report has 4 Groups: 1. Unit 2. Worker 3. Case 4. Client A sub-report is providing details. The worker & unit groups keep showing up with headings but no data (having no data is fine, but if it is empty I don't want the headings). I don't...

Works great! Thanks Andy

I created a date parameter (named Service Start Date) that corresponds with the date in an existing field({TCL_SRVC.BGN_DT}) . In the formula editor of the select expert I have: Month({?Service Start Date})= Month({TCL_SRVC.BGN_DT}) and Year({?Service Start Date})= Year({TCL_SRVC.BGN_DT})...

I apologize for being vague. It actually was another formula in the record selection that was preventing the desired result. Thank you to all! Derik

Still not working Andy. Its strange! If you have any more ideas that would be great, but I do appreciate your time.

Unfortunately that didn't work maybe because I have multiple conditions I'm trying to meet. Here is the actual formula I have written: {TCLIENT.LEGAL_CUSTODY_STATUS}= ["CPA LGL ADPT","DSS LGL ADPT","KIN ADPT","NONKIN ADPT"] However an unwanted value named "DSS LGL" keeps finding its way into...

This may already be on the site, but I can find it. I am using the Select Expert to filter (something like below): {Table_nme.field_nme} in ["Pea Pods"] Somehow I am also getting values in "Pea" (which I don't want). I tried: ({Table_nme.field_nme} in ["Pea Pods"] and...

I would like to select the lowest value from related fields in two different tables. I can get the lowest value from each field by using Minimum, but how can I get Crystal to evaluate both fields and determine which is lowest? Any input? Thanks- Derik