Search results for query: *

I'm using SSRS 2008 and have a report where I need to calculate cycle time between ticket times for each truck. I have the following expression working, but it is not working when the vehicleid changes. I do not want a cycle time for the first load picked up by a truck, but a time between first...

I am new to SSRS from years of Crystal Reports experience. I'm moving a report from CR to SSRS that shows by plant, sales volumes for current day, yesterday, mtd and ytd. I simply can't get this to work in SSRS. Is it even possible or do I have to do all of this date grouping in the query...

I am using SQL Server 2008 and CR XI. I have a crosstab report that includes plant, prodid, proddesc, custid, custname,matlunits, dollars, and a calculated field - ASP. I want to sort in descending order by prodid based on the sum of the matlunits. Done... I then want to pick the TopN 5 based...

Using SQL Server 2008 Below is the select statement I have working to determine Years of Service from an Employee table. Now, I've been asked to determine the leave time based on YOS and criteria like 1 - 4 years PTO = 80 hours; 5 - 9 = 120 hours and 10+ = 160 hours. I THINK that the first step...

I am using SQL Server 2008. I'm trying to write a fairly simple query that got complicated when asked to include the Years of Service based off the last day of the year. This is the query I have: SELECT Employee,LastName,FirstName,PRGroup,PRDept,EarnCode, CONVERT(CHAR(10), HireDate, 101)...

Using Visual Studio 2010 and SQL Server 2008 Database. I'm very new to SSRS and in the process of moving years worth of Crystal Reports to Reporting Services. I have formulas that create fields in many of my Crystal Reports that use begin and end date parameters to provide Daily, Weekly, MTD...

Using CR XI SQL 2008 DB I have new report development that includes date range parameters to provide weekly/monthly/yearly reporting. It includes ONE Group, Plant ID. Database fields include Production,RapTons, and Shingle Tons that were placed on the detail line and summarized at group and...

CR XI SQL I have a report developed that has 4 entities in a group with group totals. I need to combine 2 of those entities into a subtotal. EX: These are all in ONE of 3 Groups on the report... Entity1 - abc 10 This is at Group 3 Level def 10...

I have a workbook that serves as a weekly costing report. Data is entered in several fields, other columns calculate based on the input. There are several columns that span two pages. My issue is that sometimes, I don't notice that the cell width is too small to display the value...I get the...

Using Crystal XI SQL Server DB I have been asked to modify a report that includes 4 groups: Company, Location, Location2, Material...built on stored procedure. Location A ProdID LTMUsage EndInv UnitCost Value >12MosUsage Value 375 0 44 18.25 803 44...

I have a workbook with multiple worksheets. I have a summary sheet that finds the minimum value in those 25 worksheets by cell. How would I be able to identify which sheet holds the minimum value for each row on the summary sheet? I'm not very familiar with Excel functions so any help would...

WSS 3.0 - and I am new! I have several sites under my Top Level site and they DO NOT inherit permissions from the parent site. I have set up Sharepoint Groups for owners, members and visitors to a site for Reporting. I have put all the users who should be able to access the site into one of...

CR 11 SQL DB I have a report that has 3 groups...Co, Location, and Material. I have subtotals at each group. On the Location group, I have a calculation to determine External Sales as a % of Total. I only want to include locations where the % is >= 20%. I can't use the formula in the...

I have been "selected" to administer security on our SP sites. We use a combo of AD and SP groups. I have set up a site and have owners, contributors, and readers. I thought the owner of the site would be able to add users to the predefined groups but all that is available is to add a New...

I am using CR 11 and SQL Server 2005 DB. I am working on a report that looks at today, yesterday, WTD, MTD, YTD, and TODate volumes by plant. On today's date, I need to count the number of loads shipped. Seemed simple enough to say if RUNDATE = CurrentDate then RTTicket.ID, slap into the...

I am VERY, VERY new to Sharepoint and do not know where to start with a task I've been assigned. I am the SP administrator for our intranet site using WSS 3.0. My only experience has been with permissions, creating sites and subsites, and uploading Excel documents to Shared Documents. My...

I am very, very new to Sharepoint as the admin for our local Intranet. All I have done is assign permissions and create a couple of new sites. I've been asked to add a new site, post a form in Shared Documents folder on that site, and then, find a way to automatically e-mail a group of people...

I am new to RS...moving from CR...and I am having problems with a very simple report. I am using BIDS 2005 and an SQL DB. I have a simple table report showing Plant,Plant Name, Product, Product Description, Price Code, Price, and Price effective date. I have groups on Plant, Product and...

I am using CR XI and SQL Server DB. Table structure gives plant_nbr,vehicle_nbr,ticket_number and ticket_date. During a business day, we may have one vehicle that picks up product from our plants and delivers to job sites several times, creating a record in the TicketTable each time. The...

Can anyone recommend an online class or tutorial to get me up to speed fairly quickly on VB and VB for Excel?