Search results for query: *

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

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

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

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

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

Hi all, I accidentally removed my permissions for editing security on a folder in report manager. I can go through sql server management studio and see the folder but when I click on properties of the folder I do not get the options to edit permissions that I do on other folders. My account is...

I have a report viewer embedded in an asp.net page. I also have a control that has a popup extender that loads on the same page. On the popup extender there are required field validators. When I click the next page or refresh button on the report viewer it causes the validation run. Does...

Does anyone know what colors make up the different color palettes in reporting services 2003? Thanks in advance Jeremy

Hi all, We just started using reporting services 2005 and are trying to get the email delivery option set up with out much success. We have set the RSReportServer.config file for our SMTP server and set up the from address but when I click on new subscription for a report I only see the report...

I have a report that uses a stored procedure to call the data. The stored procedure runs in about 1 sec and when I view the data on the data tab in reporting services it takes about 1 sec. However when I try to view the report in the preview tab it takes 3 min or so. But when the report is...

Hi all I am trying to filter a table in reporting services 2005 using the "In" operator. If I use the following code then I get results back but I cannot figure out how to add other requirements. =("e") I have tried the following all with no success. =("e, f") =("e"), ("f") ="e, f"...

Hi all I have a text field that contains the text '70%'. I am trying to search this field using a case when statement but I have to use the % wildcard because it can appear anywhere in the field and I am not sure how to distinguish between the % with the 70 and the wild card %. If anyone...

Hi all, I have a matrix on a report that is a subreport on another report. The matrix has one column and one static row. I am using a stored procedure to return a result set based on ID numbers. I am trying to return the top 3 counts of ID number. I run into an error when the top 3 counts...

Hi all, I have a table that contains tranfser information. The table currently has each transfer as a seperate record as below. i would like simplify the data to appear that each record would be one move with a time in and out for transfer location. So the first record would appear as record...

I have a text field in a table that I want to search through for the word "lesion". The word may not be in the text field at all or may be in there once, twice, three times or more. The format for the text field is: "LVEF - 60%, Right Dominant, DIAG1 Generic 80% lesion, LAD Generic 80%...

hi all i have a table that contains patient complications. My ultimate goal is to create a report using reporting services that will display the complications. I want to create a list of complications seperated by ", ". I was trying to accomplish this using a function that would run through a...

hi all im trying to create a stored procedure that will look through a record in a table based on a specific case number. the fields are stored in the table as a 1 or 0 and if they are want i want to store a text value that i can concatenate and return in a varchar variable. here is my part of...