Search results for query: *

Is it possible to have a case statement as such; Case When Field_1 = x then Field_2 = n END

I need to display a count of 1 hour time blocks available from a block of time minus the duration of transactions scheduled within the block of time. For example, a staff member has 2.5 hours blocked off (2:30pm to 5:00pm) as available time in the dbo.Schedule_Staff table. However, in the...

I have a clients served report in CR 2008 that I run each quarter. I enter a start datetime and an end datetime. The counts are cumulative and are grouped by a fiscal year formula based on the months within the date range entered. I'd like to be able to enter the current fiscal year date range...

Is it possible to have my crosstab only count the records that are not suppressed? I am displaying records that have a group count great than 1 and I'm suppressing those that are less than 1. My crosstab is counting all the records.

How can I write a comparison formula where the group avg font color is based on the variance between the report avg and the group avg?

I need to compare month last fiscal year to current month and fiscal year. I don't want to count the months for last year that are less than the Last full month for the current fiscal year. So I don't want a count for April, May, June of 2012. How can I modify this count formula? if...

I am comparing the past FY (July-June) to the current FY. How can I pull in only the matching months for the current fiscal year to date? I don't want to see any months beyond the current month for the past fy. MED MEDEVAL FY12 FY13 +/- Seen FY12 FY13 +/- Seen Jul 656 61% 1066...

I have added a column to my cross tab as a calculated member"% Seen". The calcuation formula is formula= sum(formula),group/distinctcount(field),group It's only pulling in the very first % for all the months. How do I get it to calculate for each month?

How would I write an expression to count if X = Y?

Is there a formula that can be used to group the months of a date range??

I have to identify clients with 3 consecutive appointments. The client had to have shown (Status="SH") or completed (status="CO")the appointment for it to count. The tricky part is I need to skip the count for appointments that were canceled(status="CA") because of any reason other than a late...

I have to identify clients with 3 consecutive appointments. The client had to have shown (Status="SH") or completed (status="CO")the appointment for it to count. The tricky part is I need to skip the count for appointments that were canceled(status="CA") because of any reason other than a late...

I can't figure out why the 3rd "if" statement will not work..It works in a separate formula but not when combined in this one. I need it in one formula so I can group by it. Any ideas??? if sum({@Inter Ref Count},{Patient_Assignment.patient_assignment_id})=0 and...

I have a shared variable formula in my subreport as Shared numberVar ClientsServed :=DistinctCount ({Patient_Clin_Tran.patient_id}, {@CSPP}) The formula is placed in the group footer of the subreport. The formula in the main report is written as Shared numberVar ClientsServed; When the...

How would I get a count of the the med names for each row? med_name1 med_name2 med_name3 med_name4 Buspirone Tenex vyvanse vyvanse Buspirone cyclobenzaprine vyvanse Carbatrol Cymbalta Invega Lamictal Risperdal Clonidine risperidone Vyvanse

I have a Crystal rpt that displays appointment dates and times. I would like to have the report highlight any new appointments created after the previous run date/time. Is this possible with Crystal 8.5??

I have a field that has Sweetser_1\ preceding the employee name. How do I trim these characters so I have just the employee name?

How do you write a Crystal formula so when a fiscal year parameter is selected it calculates the time period for that fiscal year without having to manually update the formula for each FY period.

How do I write this so it will work? Not isnull( Aged0To30Days({tblIncidents2003_2.Inc_date}))