Search results for query: *

lbass: Yes, I'm trying to suppress a record if one specific field is not equal to zero. Do you have an example routine in which I could see?

lbass: This one is turning out to be more tricky then what I thought. In my Group Header, I originally had the following: ({?SHOWDETAIL} = False and ({?SHOWINSBALANCE} = False and {?LASTFILED} = False) In my Group Footer, I originally had the following: {?SHOWDETAIL} = True OR...

This one I thought was easy and self explanatory however I cant seem to get this to go. In my report, I have a GroupBy ({aaVisitStatus;1.GroupBy1}). I want to suppress a specific group header and a group footer when this field = '(none)' So I inserted the following suppress statement on both...

In my SQL query, I have a field named 'pv.visit'. It pulls a patients visit date and displays in this manner: '2007-10-26 14:54:00.000' I took this and added in another field that displayed this date as 'October 2007'. This was named [VisitDate](sql code below): SQL Code DateName(Month...

Month of October too ... oops So those 3 months get out of order due to starting with a '1'

George ... Boy how did I miss that last one ... so obvious after I read your response. I tried a different approach ... however it does what I want it to (to an extent). Months of November and December get put out of order due to the month # starting with a '1'. Any thoughts on a workaround...

I'm getting January 2008 for all ... ?

I would like to add in another field based off the pv.Visit Example: Currently, the query is reporting a date as such: '2007-10-25 10:15:00.000' I would like a Field that converts this into one field 'October 2007'. This would allow me to do easier work in Crystal. Any help is appreciated...

Using Crystal 10. I currently have a Employee List Report that groups employees by their postion.The majority of the information from the report is coming from the employee and postion tables. Ex. Coordinator Status Smith PB Gonzalez FB Jones...

lbass: I went in a re-formatted the SQL: Declare @ApptDate datetime Select @ApptDate = a.ApptStart FROM Appointments a WHERE a.AppointmentsId = 1095 SELECT '290.PatientName'=IsNull(pp.First,'') + ' ' + isnull(pp.Middle,'') + ' ' + isnull(pp.Last,'')+ ' ' + isnull(pp.Suffix,'')...

George - Today, you are my hero! It works like a charm and I am truly grateful for your time and help. I would also like to thank anyone else who gave their time to help.

George, How can I step around this? Convert it into a Varchar? If so, how can I do that? Sorry for the ignorance and thankyou all for explaining this so well. Your help is truly appreciated.

George, Your help is deeply appreciated! My new Code: Declare @ApptDate datetime Select @ApptDate = a.ApptStart FROM Appointments a WHERE a.AppointmentsId = 1095 SELECT [290.PatientName], [291.PatLast], [292.PatFirst], [293.PatMiddle]...

I have a client using Peachtree 2007 along with Crystal Reports 9.2.3. I've created many reports testing for zeros and other information but in an older version of Crystal and Best Software. What we want to do is supress zero information based off of testing on one field. If field <> 0 then...

I want to Add in a Case Statement to my Stored Procedure to Identify 5 classifications: A: Birth to 6 yrs old B: Female 7 yrs to 18 yrs C: Male 7 yrs to 18 yrs D: Female over 18 yrs old E: Male over 18 yrs old Any help is appreciated! Declare @ApptDate datetime Select @ApptDate = a.ApptStart...

If I displayed the age field in the detail section for my test patient (DOB 11/01/2007) it would display as: "8 wks" I wonder if I should create something different in SQL to make this easier ... ?

LBass: I created a new formula @AgeinYrs //{@AgeinYrs}: if right({SB1001_main.PatientAge},3) <> 'yrs' then 0 else truncate(val({SB1001_main.PatientAge})) Then in each of the detail sections I replaced {@Age} with {AgeinYrs}. With my prior patient (my test patient), it still pulls the MALE...

If I displayed the age field in the detail section for my test patient (DOB 11/01/2007) it would display as: "8 wks

PLEASE DISREGARD LAST POST. It is working as needed.

I got it.... disregard