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

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

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

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

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

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

The following code is part of a stored procedure that will show worked day versus when the worked time was entered into the system and the difference in days. They have added a new requirement that I can't seem to incorporate into what I have. They want to exclude clients 9012 - 9021 only for...

I need to write a report that looks for any missing clinet/matter fields. They want the ability to choose to run it on many fields. They want a check box on the front end to choose the fields they want. They want attorney information and they want to be able to choose whether a client is...

I need to create a report that tallies up the headcount of attorneys. Attorneys can have three different types of headcount(pay, work and count). They want to be able to run the report for whichever headcount type they choose. The simplest example of the select statement is as follows select...

I have a table called MonthlyData with the following columns: Name Date Prelim Received All Received Comments I also have a form that the user inputs data into. If they select "No" for the All Received column, I need the current record to be copied and inserted into the table, but only...

I have a report that needs to show the Partners, Paralegals and Associates even if one of those titles has no data (the row would be blank except for the title). I have the the sql statement below, but can't figure out how to make a title show up in the results when no data exists for it. ANy...

I have two workbooks that are linked. My links don't refresh unless I have the source data workbook open. Shouldn't I be able to open the workbook without opening the source data? I am using Excel 2003. Any insight would be appreciated.

The stored procedure below now needs to reference the actual period instead of M1, M2, etc.. So, for example if @Period1 = 200802 then the column would be named 200802 instead of M1. CURRENT - SUM(CASE WHEN p.period = @Period1 THEN t.tworkhrs ELSE 0 END) M1 NEED TO BE - SUM(CASE WHEN p.period...

I need to create a stored procedure that adds a new column every month. I have never done anything like this before so I am hoping someone could help me. My current stored procedure looks like this: CREATE PROCEDURE dbo.TIME_IPLC_MAPct @BeginPeriod int, @EndPeriod int AS SELECT tk.tkinit...

I'm new to javascript and I need to create a function that will change a period parameter into a date. Example would be 200804 would need to be shown as April 2008. I was given an example of a function to do this which is listed below. function Period_to_LongMonthYear(iPer) { var sPer; var...

I need to calculate the number of full months between two dates. For example, 11/1/07 and 2/29/08. I need the number of full months between these two dates to show as 4. Using the standard datediff formula only shows 3 months. I also tried the following formula that I found online...

I have a table that list all the clients and matters with the billing attorneys and billings per attorney. I need to show a list of clients and the billing attorney with the most billings. However, if there are two billing attorneys with the same billing total, I need to show both. Here is...

I have two tables that I need to get data from. One table has client information and billings for the last 10 years based on the billing attorney. The other table has client information and billings for the last 10 years based on the originating attorney. The same attorney can be in both...