Recent content by pleashelp

OK..I am returning the correct data to this point using gmmastros query. That's great! Right up to the last part where I need to add in the other fields that I want to return. First of all, I apologize..I am using SQL 2005 not 2000. So..I don't quite understand that last section you gave. In...

Thank you sooo much..I am going to work my way through this to be sure that I understand it, and if not, I'll ask additional questions. [dazed]

I saw a thread last week that was similar to this, but didin't really answer my question. So, I'll try to explain my particular problem and see if anyone can help me. I am using SQL 2000 and this is my problem. Suppose I have these 5 customers and their orders. They can order many different...

I appreciate your quick response. Maybe I didn't give quite enough examples. But I tried that, and because it is possible that the patient could have meds, office visit AND Therapy, this query returns too many results. I only want to see the patients who only have meds OR meds and Office visit...

I am Using SQL2005.. My query so far is this: Select Customer.Name , Service.service , Customer.IsCurrentPatient from customer Inner Join service on Customer.person_id= service.person_id Where Customer.IsCurrentPatient=’Y’ This Returns: Sally Jones Meds Sally Jones Office Visit Tom...

Thanks for your reply. This: select convert(varchar, DateOfReferral,120) gives me 20100301. I really need it to be 03/01/2010 if that is at all possible.

New to SQL codes. Using SQL 2005. I have a varchar field that is a date. I need to convert this to an actual date field. I was given this piece of code dbo.fn_datetodisplaydate(dbo.fn_chartodate(DateOfReferral)) where DateOfReferral is the field name. The problem is that this code give me a...

Using SQL 2005. Have a char field called 'StartTime' that shows a time such as '0815' or '1430'. It seems like it should be a simple thing to convert this field to an actual time field so that it displays '8:15 am' or '2:30 pm'. Any help in doing this would be greatly appreciated. Thanks

Thanks for your help!!! :-)

So sorry I didn't explain myself better. Here is what I did . Group Header 1: date field grouped by each week (This header is displayed) Group Header 2: same date field grouped by each day (This header is suppressed) @accum variable (suppressed) Group Header 3: Person Name (Suppressed) Detail...

Thanks so much.. BY putting the reset formula in the footer for the week I was able to just have the days for each week total and not accumulate for the month. This is exactly what I wanted it to do. Now one more thing along the same lines....Is there a way to take that weekly total and get...

This is another question to an old problem. Is there any way within Crystal Reports Server to burst a report? I want to send each manager's section of the report to them individually. I will be scheduling my reports to run using the version of Crystal Reports Server(Info View) that comes with...

Using CR XIR2 with a SQL database. I have grouped my report by a date field by the week. I am displaying a distinct count of persons by the week. This part works fine of course. Now I want to add those weekly counts. I don't just want a distinct count of the month since that gives me a...

Thanks! I just put that into my slection formula, and it worked great!

I am using CR XI. This is what I want to do. I have customers and their appointment dates. I am trying to get a list of appointments for the following day. But I only have appointments on Monday thru Friday. So, if tomorrow is Tuesday thru Friday, I want to return my appointments for the next...