Search results for query: *

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

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

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

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

I'm using a Liant Relativityv6 ODBC Driver with Crystal Reports 8.5, and keep getting a Logon Box pop up. I can click "ok", and it loads the information. It's annoying. I can't seem to figure out a solution to get rid of it. I know it has something to do with opening the connection because I...

I have SQL Server 2000 that has a five databases on it. I have a vendor who needs access to this server since his database now resides on it. We have a VPN connection to allow him through, but I am unsure on what security precautions I need to take care of before I give him access. I also now...

Sql Server 2000 In the Enterprise Manager under Security, Logins I have an existing user using Windows Authentication. The first tab, General, there's a Defaults section with either Database or Language. Problem: I have two databases School and SchoolII. School was the old database, and...

Is there ever a situation where it is acceptable to store data like Goals1, Goals2, Goals3, Goals4, Goals5? I've always been taught NEVER to create fields that have numbering because you might run into a situation where you need a Goals 6,7,8,9, etc... As it is now, I create another table...

CR8.5 I have a shared variable returned from a subreport to the main report that's not returning correctly. I have the subreport linked to the main report by ClientID. I have a True/False Shared Varible I want returned from the subreport to the main report. The subreport "IS" above the...

I have a legacy database that used the old "Numbering" method to store values. ie. Item1, Item2, Item3, Item4, and Item5 I imported the old flat-file database into SQL Server 2000. I have an Items and Orders table. The Items table has the PK - ItemID, and has all the info on the items. The...

The following SQL is my solution to a query a user had, but I'm unsure if this was a "Best Practice" SQL solution. I used a subquery to find what they were looking for. The user wanted a list of people who made donations in 2004 but haven't yet in 2005. They didn't want to send reminders to...

VB6 Goal: Load all the directory file names into a treeview. End Product: I'm going to have a Drag and Drop of Reports on Treeview one to Treeview2. I have the code for this part, but not how to get a directory into a treeview. Here's what I have so far. I can't seem to figure how to...

Crystal 8.5 "Error formatting cross-tab object" I've noticed this occurs when my crosstab goes beyond 7 3/8 inches (up/down) AKA Height. If I resize a field in the crosstab that makes the crosstab less than 7 3/8, it works. Anything beyond 7 3/8 returns the above error message. Bussiness...

When you start a report with parameters, a box pops up and allows you to input your parameters. When you have a date range, and click on the Calendar Control, the Calendar opens maximized filling the whole screen. The Calendar Control is VERY different than it was in the previous versions. So...

The following code works, but only for ONE Supervisor level. I need to include all that apply. Goal: I'd like to have the Director on the Parent level with the Supervisor(Under the Director) next as a child, and the final level with the people under the Supervisors Team(based on the Supervisor...

I'v been designing applications to fit a 1024 by 768 resolution. I don't know if this is standard practice, but I choose that resolution because people complained about having to scroll from left to right too much. A minority, maybe 10 to 15 people, have bad vision and have trouble reading the...

I have versions 8.5(currently using), but I also have 9,10,11. I'm trying to find the best way to find overlaps in time. Example, TimeSheet Start End 8:15:00AM 8:30:00AM 8:45:00AM 9:15:00AM 9:00:00AM 9:45:00AM <==Overlaps the previous time 10:00:00AM 11:00:00AM I'm currently using...

Is it possible to add comments "//" to the Selection criteria and save it? Everytime I add a comments "//" in selection criteria, Crystal fails to save the fields I had commented out. I'm trouble shooting a selection criteria problem, and decided to comment out the fields in question. When I...