Hi all I have a multi value drop down list and their values are a string data type. Label Value Blue BL Pink PK If I select more than one values the parameter value is sent as 'BL, PK' The stored procedure has a where clause WHERE theColor IN (@SelectedColor) ...more >>

We have an SSL cert in place on our production platform and for some reason the help link in report manager is calling the help page through http, not https and subsequently the call fails. Does anyone know if it is possible to change the link to https somewhere in the config files? All ot...more >>

Hi all I have a multi-value drop down list as my report's parameter. Once the report is executed with the selected parameter, I am displaying the selected parameter also as a part of the report's results. Is there a way I can display the word "All" in the report results when the user selec...more >>

We have recently replaced web pages for a web site that sits in the default web site folder in IIS - along with the Reporting Services sites. As a result when trying to logon to RS as a non administrator user, the authentication box pops up repeatedly after entering the user name and pass...more >>

Hi, What kind of options do I have for report's data source (other than direct database tables)? Can I have a report based on a XML data source or a web service Data Sources? For example can I have a report based on a RSS feed? Thank you, Alan ...more >>

Hi, I find the Export function hyerlink shows the computer name instead of showing internet domain in the report. How can I fix this problem? Thank you. ...more >>

I am using a barcode font 39 to generate barcodes in some reports. If I reader the report and save it to a excel spreedsheet and print then the report prints fine with the barcode. If while I am in the browser I use the reporting services print engine the barcode comes out as the numbers ie...more >>

Hi When I run report, it times out after about 4 minutes. When I run stored procedure this report is based on, it takes about 10 minutes to run in Query Analyser. My Datasource has setting: Connect Timeout=6000. What should I check? Oleg ...more >>

Okay, I'll try my best to explain this..... I have a table on my report. Above the header for 5 of my columns, I need to place a cell that spans all those columns. It looks like this: ---------------------------------- | h | --------------------------...more >>

Hi. I'm resposting the question because I haven't been able to get (or figure out) an answer. Thanks for reading. I am using ReportItems in the header of a report to reference a data field in the body of the report. Often the data in other fields can be quite large (20 to 100 pages when r...more >>

I probably already know this answer, but I'll ask it anyway. Can we respond to RS event within RS? ===================== Thanks! Keith p.s. Get off the couch and exercise!...more >>

I have a report that has images etc. (company logo) at the top which works fine when rendering to pdf. However I'd like to elimiate this stuff when rendering to xls. Is that possible? Thanks. --Cory...more >>

Is it possible to use an expression to set the Height property of a row in a Table? If so, show me an example. ...more >>

I have written a c# app that renders in real time the RS Reports in an 'EMF' memory stream straight to the printer. Would it be faster to stream them to a file and then send to the printer??? Streaming straight to the printer is VERY slow! Thanks, Trint ...more >>

My end users want me to post 2 versions of my 2005 Reporting Services reports. One that when they click on it automatically opens in Excel w/o grouping...sort of a data dump. Then a second that is grouped, formatted and pretty. I know that I can have them export the report once run into E...more >>

I am using a table with grouping - but found that the group header was printed at the bottom of the page (when exported to PDF) with no rows below it. The following page printed the group header again with the rows. Is there a way to stop that behaviour? Example... Page1. Group Header ...more >>

Hi, Reporting services has been running for a couple of months. I noticed today that I had 8GB of log files. Is there anything I can do to stop so much being logged ? i don't really need it. Thanks Scott ...more >>

We are trying to find a service pack that will allow us to connect from reporting services to MS Analysis services. Does anyone know what service pack we need? ...more >>

Hello, Is there a way that I can pass the html syntax as is in the textbox value? Currently it displays the whole html syntax in the report. <a style="text-decoration:none;color:Black" href="#" onClick="javascript:void(window.open('http://www.google.com','_blank'))" TARGET="_t...more >>

I have report with report parameter as "Regions".This parameter dropdown needs to get populated based on User!Userid global variable.To achieve this I have Oracle stored procedure "GetUserRegions (userid, cursor OUT )" How can I build Dataset based on this stored procedure and pass User!User...more >>

I am trying to set up my report services so that a "power user" for a specific set of reports can go and add the users that they want to have access to the reports. However, the only way that i find this works, is if i also grant the "power user" access to sql server enterprise manager to cre...more >>

The parameters box in the report view displays in tabular format if you have at least two parameters. Can I change this in anyway so it displays in columan format. Current display 1. parameter box 2. parameter box 3. parameter box 4. parameter box Can I change it to d...more >>

Hi, This is what i want to do. Is it possible ? I have a report1 with a textbox button - and a table with 10 rows. when the user clicks on the textbox button - it should open another report - report2 - IN ANOTHER BROWSER. report2 takes filter values and has a close button - when close butto...more >>

hi folks I have a dynamic pivot table sproc I've written, which I'm trying to include as the data source for a new report (familiar with how to execute a sproc as the datasource). I don't seem to be able to get a query string into the Report Wizard that's acceptable. (Next step is how t...more >>

I have 2 matrix reports a summary and a detail. The summary report exports fine to excel but when my customers drill to the detail matrix from the summary and then try to export to excel ... they get this error ==> "Exception of type Microsoft.ReportingServices.ReportRendering.ReportRende...more >>

hi, I have installed the reporting serivces, the report server is working fine, But when i try to view the report manager, http://<servername>/reports it gives a error message "The request failed with HTTP status 404: Object Not Found. " I have seen the virtual directories and the rswebappl...more >>

hi, I was working on reporting services and when i opening the report manager in the browser, it is giving me error the error is the request failed with HTTP status 404: Not Found and the reportserver it working fine. I have seen the rswebapplication.config and the 2 virtual directories also...more >>

I'm working on a report that one of the parameters is a list of state names. (Actually the parameter is a state ID but I have a query that retrieves the state names.) This list can be 1 state of all 50. They would like the list of states listed on top of the report. How can I do this in a mu...more >>

Hi! How can we use .Net assembly to reference within a report? We know two ways to reach this: - registering a custom library in the global assembly cache utility; - coping our custom library in the bin folder of Reporting Services server. Is it possible to reference directly a class? Consid...more >>

Hello, I have a report which takes data from a stored procedure and then reveals some text on a row depending on whether or not a bit is true. The data coming from teh stored procedure is a single row for a contact, and it displays a number of rows in the report. When we run the report i...more >>

Hi, I need to do that the Reporting Services works when I change the web site port number (from 80 to any other) Can somebody help me? Thanks. ...more >>

I think this is probably easy but haven't found the setting yet and am running out of time. My report has a column I want to use as a parameter(parameter query). The value of the field repeats several times and I want to limit the drop down list to the first occurance of each value. Hope...more >>

Hi Is it possiable to recover a .rdl file from the report server? I deleted a report file from Visual Studio, but it was succesfully published to the report server. Any help is appreciated. thanks...more >>

Hello there I was wondering is there is a stored procedure to witch I could feed the name of a maintenace job and it will give me all the data that exists in the maintenance configuration screen ? thanks ...more >>

I am looking to deploy reporting services on two serves, one already running SQL2000 plus an exisitng IIS Server. The IIS server is running Windows 2003 Web Edition - is installing the non-DB components of this edition of windows supported - cannot find the into in the deployment guide! ...more >>

Is there anyway we can have dynamic operator in filters ???? instead of > i want to put parameters!operator.value...more >>

I am using xslt to generate an rdl file. The top level node is the Report Designer default: <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdes...more >>

Hi, I have 3 parameters- columnname -takes the column name like name, course, marks operator - takes the operator - <.>.<= value - takes the value like 30,computers , english etc i want to pass these parameter to a table and filter the value out. how can i make the operator as a parameter...more >>

I have a question to ask: I type "http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport" in jump to url box, it will go to open a report named testreport in my report server. It is good. I want to rename the testreport to a variable name. If I change test...more >>

Hello, I am very new to Reporting Services and want to do something I have done in other programs using a tool or wizard. I want to group my data by " 30 days over due" , then " 60 days over due" etc..Based on the following DAYSDUE > 30 and < 60 DAYSDUE > 60 and < 90 DAYSDUE > 90 and < 120 ...more >>

How should I install SP WebPart? I need to install the web part on antother server. What should I do? ...more >>

Can we utilize a userID as in the custom security example but also have a friendly name appear on the modified By in the Report manager detailed view? I'm currently seeing the UserId in the Modified By and would rather view a friendly name. Yet I still want to use the integer type user id for s...more >>

The report is made of one list containing 2 tables, one below each other. Depending on the report parameters, the bottom table is made visible or hidden. When that table is hidden at run time, RS still reserves the same amount of white space that the table takes in the report design layout. ...more >>

HI, There is one report with 3 parameters. They are AppID, StartDate, and EndDate. When rendered as soon as I made a choice in the AppID dropdown, the browser logo starts spinning and I have only a short time to get the dates input. What might be the cause of this? Thanks, -- Fairfield...more >>

I have a problem with a default implementation of Reporting Services with SP2 in one box, with SQL 2000 SP4. The tool works fine, I have 10 Reports working without problems, but when I want to execute one of them, this error message appears : aspnet_wp!webserver!294!07/25/2005-16:06:56:: e...more >>

Hi, Is there any facility to restrict the dataset not to display the textbox more than once when exporting to CSV format,when textbox value displays group value(text). Many Thanks ...more >>

How can I incorporate a MS Project Gantt Chart into Reporting Services reports?...more >>

I have a table with 2 Groups and I want to number only Group2 with row numbers. I put in a RowNumber(Nothing) function, and i'm getting something like this: Group 1 11 Group 2 14 Group 2 28 Group 2 Group 1 35 Group 2 etc.... What can I do to get the numbers to show up co...more >>

I am trying to build a dynamic datasource for my report. The problem is there are multiple where criteria that, if left blank, I want to ignore. I could go down the road of nested "iif"s but that would get very difficult to maintain. I have a C# function that already does something like this ...more >>

Hi I have a main Report MR - i added a subreport to it SR1 - and it works fine but when i try to add another subreport SR2 - it gives me an error ERROR: subreport could not be shown. It only hapens with this particular rdl. The subreport thing works for other rdls. the supreport SR2 works fine...more >>