Recent content by Memento

A little more info. I have to have the service provided and the frequency in two separate fields. The OutPatient query returns the Frequency, but then I have to also deliver the service name.

Otto, I think your right, but I couldn't apply the structure you supplied with what I had. I think my problem is I would like to use the "AS Outpatient" furth down my SQL staement. For example: SELECT A.cl_id, A.cl_ln, A.cl_fn, ((SELECT COUNT(*) AS OutCount FROM eventstb E WHERE...

I think I'm doing a poor job of explaining what I need help with. Sorry for that. How do I write the above case statement with variables? For example...This doesn't work because the A.cl_ID is before the Select. How do I get this to work? DECLARE @OutPatient varchar(1000) SET @Outpatient =...

Monksnake, I would like my code to be like this: CASE WHEN @OutPatient>0 THEN 'Outpatient Therapy' WHEN @OutPatient=0 and @MedCheck>0 THEN 'Outpatient Medical Services' WHEN @OutPatient=0 and @MedCheck=0 and @PsychRehab >0 THEN 'Psychiatric Rehab Services' END as Column1 The...

Here's the goal: CASE WHEN @OutPatient>0 THEN 'Outpatient Therapy' WHEN @OutPatient=0 and @MedCheck>0 THEN 'Outpatient Medical Services' WHEN @OutPatient=0 and @MedCheck=0 and @PsychRehab >0 THEN 'Psychiatric Rehab Services' END as Column1 Here's how it looks in it's working state...

Windows 2003 Sql Server 2000 Tablets with Windows XP Tablet Edition We have a wireless network with an application that runs off of SQl Server 2000. Periodically, the tablets we have loose conncetion from the network. If they are in the application while their connection goes down and a...

Goal: I need a calculation to occur even if no data is returned. I'd also like the group by deapartment to appear even if no data was returned. Problem: I have an overhead report that does hard-coded calculations for several departments. Sometimes, a department will not have any activity for...

Thanks! Excellent explanation. I found it very helpful. I've been racking my brain on this since last Friday.

SQL Server 2000 Here's my SQL: Set Nocount On DECLARE @STAFF INT SET @STAFF = '100' SELECT planev.pl_staff, (CONVERT(VARCHAR(10), planev.pl_date, 101)) + ' ' + (CONVERT(VARCHAR(5), planev.pl_time, 8)) as FirstTime, (SELECT Min((CONVERT(VARCHAR(10), planev_1.pl_date, 101)) + ' ' +...

I figured it out. >>I've tried Crystals: "How to suppress a section in the main report that contains a blank subreport". I did work, but not on all the groups on the main report. I had accidently included the Suppress shared variable in the second subreport group.

Crystal Reports 8.5 to XI I have all of the above. I'm currently using 8.5, but I can use any version of you can get this work. I have a report with a subreport. I want the Main report to only be visible if subreport data is returned. As it is now, the main report is returing data even if...

Catadmin and Gmmastros, I'll try both of your suggestions. I won't be able to try them until Monday. Thanks alot!

Imagine the schedule in Microsoft Outlook. Someone blocks out time from 8am to 12pm that they are free(non-billable). At some point people start arriving and the person creates an ad-hoc appointment for 9am to 10am. The new appointment in our system simply "overlays" over the non-billiable...

SQL Server 2000 Windows 2003 Server Goal: I need to “Back Out” non-billable time from billable time. I really only need a total time for the week. This is for an Hours Report with 40 hours a week being the standard. Tables: BillableTime(BT) StaffID(int), StartTime(datetime)...

k5tm, >>Clearly the two versions are behaving differently in their use of the datasource. v8.5 is using SQLDriverConnect, while the later versions are using SQLConnect. These two API calls are not identical. This got me thinking. I went to Microsoft's website and found the following...