Search results for query: *

I am new to conditional formatting the format property and maybe I can't do what I am trying to do. I have a stored procedure that contains a type field and monthly values which are formatted as money. In SSRS, I need the format property to look at the type and decide which type of formatting...

The cursor worked like a charm. Thanks so much!

Thanks for the quick reply. I will give this a try and let you know how it works out. Appreciate the help.

Our year goes from November to October. So, if I am trying to calculate for this year, I only look at dates between 11/1/2011 and 10/31/2012. In the example above, yes I only want to include the following months in my calculation: 2/2012 7/2012 8/2012 9/2012 10/2012

The data looks like this: LeaveID EmployeeID LeaveTypeID LeaveBeginDate LeaveEndDate IsPaidFlag 296 1928 Other Leave 10/10/2011 1/29/2012 TRUE 345 1928 Other Leave 3/12/2012 6/11/2012 TRUE

I should also state that we not only want to exclude the hours from the months on leave, but the calculation requires we count the number of months not on leave.

We are trying to exclude all the months a person is on leave in a calculation. Our year runs from November - October. This year we want to exclude any leaves between 11/1/2011 and 10/31/2012. Leaves can overlap years. There can be multiple leaves for one person. What would be the best way...

Here lies one of the problems. I don't have access to see what account the reporting services runs as and the person who does has no idea what he is doing. Can you tell me how to check so I can tell him step by step what to do?

We have an Access 2007 database that is used as a datasource for a SSRS report. When previewing the report in Visual Studio, the report renders fine. When trying to run the report from Reporting Services, we get the following error: An error has occurred during report processing. Cannot...

I need to be able to determine all the dates a worker receives a payment based on the start date of payment and the number of months the worker is supposed to receive the payments over and insert those dates into a table. The form shows the employe number, the payment amount, the date...

Unfortunately, when I suggested calculations on the fly in the report, it didn't go very well. They want to store the data so they can go back and look at prior years if they ever needed to. They also want to be able to make edits (for example if someone terminates and they pay out before the...

Using Access 2007. Requirement: Access database that tracks what dollar amount worker must receive every month based on start date, bonus value, and number of months. A worker can receive a bonus to be paid over a number of months (the max is usually 60 months). The input screen contains...

I have been asked to provide a sql script of the data in the attached excel spreadsheet. Someone else will be creating a sharepoint page with the formatted data. I am able to get all the data in columns A & B in a relatively simple sql statement. I am having issues with the boxed in portion...

Here is sample data. client_code client_name client_status matter_code matter_name matter_status 10000 client1 op 00001 matter1 CL 10000 client1 op 00002 matter2 CL 10000 client1 op 00003 matter3 CL 10000 client1 op 00004 matter4 CL 10000 client1 op 00005 matter5 CL 10000 client1 op 00006...

There is a client table that contains client_code, client_name and client_status. There is also a matter table which contains matter_code, matter_name and matter_status. The two tables are linked through the field client_uno. The status field contains values such as CL for closed, op for...

Thank you so much for the advice on this one. I have tried the two solutions you gave examples of and both work for me. Thanks again.

I'm using SQL 2005. The most leaves I have seen so far is 3 per an employee. Not to say they can never have more than that, but so far that is all they have. Thanks for the advice on the dates. Makes sense.

The data will be published in a report on our reporting site. It is called Expert Report Center by Aderant. The report designer is not that great so I was hoping to do this in SQL.

They want to see this information on a report.

I have the following stored procedure to obtain information on attorneys who have been on leave during a specified time frame. My problem is some people could have been on leave multiple times and I'm not sure what the best way to combine the information on one line would be. The procedure is...