Search results for query: *

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

You can also use the convert function convert(varchar(10), getdate(), 101) This will display 1/26/2009. Thus where convert(varchar(10), mydate, 101) = '1/26/2009' will return all records for 1/26/2009 regardless of any time attached to them

This seems pretty basic and I am sure there is a simple way to do this but it is escaping me. What I want is date time with just the current date and hour. For example at 7:49 today I would like to return 1/26/2009 07:00:00.000 and at 8:15 1/26/2009 08:00:00.000. I know I can use dateadd and...

Hi all I have a chart with around 10 columns on it with days on the x axis. I would like to bold the label for todays column. I tried and if state where the ProcDate = Now() but it would not work because it was looking at the last columns date which is Thursday. Any know how to accomplish...

Have to wait till Monday since our database administrator is off today. Thanks for the help.

well thats the problem. I accidentally removed our whole group. So the only group that can see the report is users who only have view reports and view folder privileges. I was trying to test something and I thought I added myself individually but apparently did not. I am surprised that as an...