I want to make a report depending on some parameters. Sometimes users should be able to get reports if they dont select one or two options , I mean Parameters. But if we dont select a parameter then it pops up a message to select that option . Until we select the option it dosen't work. Even ...more >>

How is it set? In other words how do I get the lines closer together? Gerhard ...more >>

I am having trouble rendering reports through the ReportingService.Render method which take longer than the 120 second default IIS connection timeout. Is there a solution other than increasing the IIS connection timeout? Of course I am using the infamous PDF rendering extension, attempting to...more >>

Hi, I have a report which is showing monthly sales figures on a matrix. the Rows are grouped by year and product and the Columns grouped by month. What i would like to achieve now is to add a column between each month column to show the % increase between the months. so that the report look...more >>

I would like to hyperlink from a report to another report that provides online help about the report. Is there a way to enter raw HTML into the report designer and have reporting services generate the formatted HTML?...more >>

I have two questions regarding calculated fields. I have a report with two datasets. Issue 1: Dataset 1 queries a table that contains configuration information. This table has one row. I would like to create a calculated field that divides the value of a column in this one row but anot...more >>

My line graph is currently using the yearmonth datafield on the x-axis and the number of units ordered datafield on the y-axis ( it pretty much demostrates the consumers' purchasing trends throughout the months of a year)- this is a horizontal line. I want to create a second line (vertical line)...more >>

I am trying to utlize the rc:Stylesheet parameter to alter the default header look/feel so that it matches the rest of my site and reports (My understanding when I read the SP1 readme file and other posts was that I can use the rc:StyleSheet parameter to change the 'HTML viewer' area of a repo...more >>

I have a bar chart, simple bar, and depending of the data within, I want to have different format for the label. This is for the x-axis (what actually is the y-axis visually for the bar chart). I want to check against the column "ord" in the data set and if 1, then color should be red, else bl...more >>

I want to render a RDL to a PDF format in landscape view rather than portrait. How do I do this?...more >>

Hi all: I am new in RS. I use Report Designer to create a report and use Report Manger to view it. My question is I want to use parameter passing to let the end-user to select multiple item in the parameter list, however, by using Report Designer the parameter list only alow user to sel...more >>

I want to display two measure values in a chat, one is the age of employee, another is his salary, I use bar to display the age, and line to display the salary. The two measure values have different scale, can we set different max values on both Y-axis ? ...more >>

Hi All, Can someone tell me how to set my sort parameters? I have this little project where I'm supposed to sort the 'STATES' in alphebetical order? Thx,...more >>

Hi all, I would like to retrive data from my datawarehouse cube and make a report. But I got a problem when I ran a report dataset by MDX. First I checked the same MDX script in the MDX sample application and it worked. Then I ran it in the report, it took a long time and gave me an internal erro...more >>

Does anyone know the steps to move the SQL RS web services front-end? The back-end database will stay in its current location. Thanks, Doug ...more >>

Hi, I have a data driven subscription and sends out an email with the report attached. The From field is showing as MyName_SQLReporting@MyCompany.com. How or where can I change this setting? thanks ...more >>

All, I am testing reporting services as a candidate for our Data Warehousing project. I was wondering if it was possible to get Reporting Services to execute the entire SQL query on the server, rather then bringing the data over the network to process it on the Reporting services server. Cr...more >>

We're having a good bit of trouble with a deployed report overloading the server during times of heavy use. The report renders directly from an external app to Excel, running the report by way of URL. I haven't found any tuning that helps us - we have about 1200 clients who try to run the repo...more >>

Reporting Services has been fine for me up until last night and now I can't view any reports as the R/Server keeps throwing the error: "Key not valid for use in specified state" I can't seem to track down any help and the link provided in the error report is completly useless saying: "Int...more >>

I need help with creating a Stored procedure dataset for a Reporting Services Report:- I am creating a dataset using a stored procedure that has parameters and I am unable to see/use the Fields to create a report. Here is an example of the stored procedure CREATE procedure rptDataLoa...more >>

Hi, I was trying to write a rss to generically deploy reports.(actually changing the sample given in the documentation) I have a variable called reportstodeploy that will take a comma separated string which is the names of all the reports to deploy. Inside the rss, Iam using the Split functio...more >>