Search results for query: *

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

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

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

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

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

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

I am using CR 10 and SQl 2000. I have installed CR 10 and when I try to open up one of the sample reports that are included with the software I get this error message: "crw32.exe has generated errors and will be closed by Windows" I have already: (1) rebooted the machine; (2) Tried to repair...

I am using CR 8.5 and have a report that is grouped by salesman with his orders in the detail section. I want to use this report to do QA and check data entry accuracy. Therefore, I want to select a certain percentage of records for each salesman. For instance, if I use 10%, then I want to...

I have an information form that I am building within a table. I got everything working except that I need a drop down box that will give the system year plus 6 additional years based, of course, on the system date. I can't figure out how to make this happen.

Using CR 10. Oracle 9i. I have a report that is grouped by manager name with details under each manager (this may be several pages long). I need to email the info for each manager to him. Is there a way to do this in CR 10 without using an outside product?

I still have trouble figuring out variables! I am using CR 9.0 and SQL 2000. I have a group1=Dept and Group 2 =Employee. My only time field is totalhours. So to get the regular hours I have a formula that says: if Sum ({table.totalHours}, {table.Employee})>= 40 then 40 else Sum...

I am using CR 9.0. I have a field that shows the date an item was purchased (DTPurchased)e.g. 10/25/1991. And a field that tells me the number of months in the loan (Mths)e.g 60. I need to calculate when the loan will be paid off based on these 2 fields. Any ideas? Thx

Using CR 8.5 with SQL. I have a chart that I have developed and am using a legend along the bottom of the chart. Now I want to make the chart larger. So I have enlarged the group footer and enlarged the chart to fit inside the footer. My problem is this...when I enlarge the chart, the legend...

I am using both CR 8.5 and CR 9.0 with a SQL database. A question that has bugged me for a long time. Does anyone know how to conditionally begin a new page on a group footer ONLY if the footer is, for example, the last line on the page or less than an inch from the bottom for example. If i...

I am using CR 9.0 and a SQL database. My problem is this: The report is grouped by Location. Under each location I have a field called final liability. I want to use this field once in each site pulling the last final liabilty record no matter how many days the report is run for. So if the...

I am using CR 9.0. I have a report with parameters of ?StartDate and ?EndDate. I want to limit the acceptable range to 2 months. Is there a way to have a message pop up if the user puts in an end date that is more than 2 months ahead of the start date? I know that I can limit what actually...