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

LOL!! That's a good way to put it! I am very uncomfortable with the new requirements because they want stuff so fast I don't have time to think through it. I appreciate you getting me on the right track with this particular project. I wanted to include the finished code I have for right now...

djj55 - Thanks for the tip...I will give that a whirl, although I think it's going to be more complicated after receiving more requirements. gmmastros - understood. I am going to try to take an on-line class or something to bone up on writing more advanced SQL queries. I'm a bit intimidated...

I was going about that all the wrong way! I was trying to do the CASE statement in the select. I've got much to learn in order to do this they way they are asking for things now. I probably couldn't even be qualified as a mediocre SQL coder based on this! It did work and I do appreciate it...

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

Thank you so much! That got me where I needed to be. Maybe I'll finish this query on time after all. Only a couple more little caveats to worry about:-) SELECT Employee,LastName,FirstName,PRGroup,PRDept,EarnCode, CONVERT(CHAR(10), HireDate, 101) AS...

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

Thanks, Dave. I was just thrilled that it didn't error out on me! I simply want to provide calculated fields on my report for Daily, WTD, MTD and YTD amounts. This is a breeze for me in Crystal Reports. I simply write a formula using the date parameter values and ask to return the PRODQTY if...

Tah-Dah!!! This finally worked!!! I like CR MUCH, MUCH better! Of course, after almost 20 years of working with Crystal...it should be easier:-) Again, thanks for all of your help and support. I liked the links you sent me and that is where I actually found this idea...

This is the error message that I'm getting. Error 1 [rsCompilerErrorInExpression] The Value expression for the field ‘=IIF(Fields!TKTDATE) >=(Parameters!WTDSTARTDATE.Value) and Fields!TKTDATE) <=((Parameters!REPORTDATE.Value),Fields!PRODQTY, 0)’ contains an error: [BC30516] Overload resolution...

I tried that and I'm still getting an error. I'm going to keep working with it, but it's totally frustrating! I never really worked much in Access or VB so I'm starting over. It seems to me that it should be easier than what I've done with Oracle and Crystal Reports, but it hasn't been so far...

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

I wanted to let you know that I wound up writing a stored procedure to accomplish what I wanted. I did all the summary for the values by plant in the SP and then placed those values in the detail line, created the formulas I needed. I then could group on the AllRecycle% value and sort...

Thank you both for your suggestions. I've not had a chance to try either today because I've been in meetings all day. I will post when I get a chance to try and get one of these working.

I can try that and see...I am willing to try anything at this point to get this project off my desk:-) It's very frustrating to get so close to the finish and get stuck on something like this I don't know how to handle. I really appreciate your help!

Yes, I am using a start and end date parameter from PlantDay.Date and a plant pick from PlantId.Plant. I had read in some of your other posts about this that you couldn't use parameters in the SQL Expression and I don't know if there is a way to do this by just removing the parameters and...

{vDailySummary.RAPTons}+{vDailySummary.ShingleTons}

Sorry...you asked me that the first time. It is the sum of RAPTons + ShingleTons...