Search results for query: *

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

Worked perfectly!! Thanks! :-)

I am using CR XI. I think I have seen this discussed on the forums a long time ago. But I can't find the answer, so I'll ask it again. I have a string that shows a person's name as Lastname, FirstName. I want to display the field as FirstName LastName. Can someone help me with this?

I just got a new laptop which has Vista Pro installed on it. For various reasons, I want to change back to Windows XP Pro. Does anyone know of any real issues of making this change? My plan is to just re-format the hard drive and install Win XP on it. Any suggestions? Thanks

Thanks for your input. I was thinking that it should be no different than any other document that we create with CR. But I haven't actually worked on something that printed checks since version 8.0 and that was being printed to pre-printed forms. This client needs to print more than 4000 checks...

Are there any special issues that would need to be addressed in order to print pay checks using CR XI? For instance: Did these checks print to a ‘Pre-Printed Form’ or was there another CR tool that allowed you to create a template with the lines and boxes? Is there any limits to the number...