Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Memento

  1. Memento

    Case Expression

    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.
  2. Memento

    Case Expression

    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...
  3. Memento

    Case Expression

    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 =...
  4. Memento

    Case Expression

    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...
  5. Memento

    Case Expression

    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...
  6. Memento

    Connection Timeout

    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...
  7. Memento

    Group to appear Even if Null

    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...
  8. Memento

    Sql Help: Subquery

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

    Sql Help: Subquery

    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)) + ' ' +...
  10. Memento

    Supressing Group

    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.
  11. Memento

    Supressing 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...
  12. Memento

    Backing Out Durations Between Dates

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

    Backing Out Durations Between Dates

    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...
  14. Memento

    Backing Out Durations Between Dates

    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)...
  15. Memento

    Liant Relativityv6 and Crystal 8.5

    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...
See more

Part and Inventory Search

Back
Top