Recent content by jmk418

Thanks for the help guys. I did not know about the [] in the formatting section. Makes doing these calculations much simpler. Thanks again. Jeremy

Thanks for the response. I can get that far. But I want to be able to format within a single cell. I have real numbers. For the example above when I convert them to general format they are 40110 and 0.6. Here is an example of what I want to do: A B C D E...

UPDATE: I am able to simply combine the two fields together and get a datetime column with custom formatting m/d/yyyy h:mm. I would like to be able to calculate the difference in hours without having to create 2 additional columns in the spreadsheet then taking difference in hours from those 2...

Hi, I have two columns in excel one has a date (ex 10/24/2009) and the other a time (ex 14:24). I want to combine those fields into a datetime format so that I can compare it to another datetime and calculate the hours and minutes difference between them. I thought this would be pretty simple...

Thanks for the reply. I do not have separate field for each month to specify. I am using the below code to calculate the percentage: =Sum(Fields!County1.Value) / Count(Fields!Casenum.Value) Each month is calculated using the above code and grouped by the month and year group at the top of the...

Hey all, I am using Reporting Services 2005. I have a matrix that lists months across the top and counties down the side. The report shows the percentage of referrals for each month. Example below: Jul Aug Sep County 1 20% 30% 25% County 2 40% 20% 25% County 3 40%...

Hi all, I have a hover menu that shows from and image that is on a modal popup. The hover menu contains a grid view that is populated depending on a field on the modal popup. For certain fields the hover menu extends off the screen and there are no scroll bars to see the bottom of the list. I...

OK thank you for the direction

web application I am using visual studio 2008 web developer

Hi all, I have a hover menu that shows from and image that is on a modal popup. The hover menu contains a grid view that is populated depending on a field on the modal popup. For certain fields the hover menu extends off the screen and there are no scroll bars to see the bottom of the list. I...

I was not able to get this to work but I think it was because I was using nested queries and not just pulling all the data from a table. I ended up getting the results I wanted in Reporting Services using the RunningValue function. Thanks for the suggestion though.

Hi all, Does anyone know how to justify the text in the legend to one side or the other? Seems like it would be fairly simple to do but I cannot find the setting anywhere. Thanks in advance Jeremy

Hi Using the convert function you can look at just the time piece of a datetime field. The following will return the current time only: convert(varchar(8), getdate(), 108) to show just those specific hours during the time range specified just add to your where clause such as: datetime...

Hi all In my data set I am returning the hour and the number of times something happens in an hour so it looks like this Col 1 Col 2 0 2 1 4 2 2 and so on up till 23 what I want is a running total in another column so that the data will look something like Col 1...

perfect exactly what i was looking for thank you