I have created a sales checking report which will only show the items below the sales target, now I subcribe this report by email daily basis, but even there are no any data on the report, it will also sumbit a blank report to me. it is possbile to control no data handling for reporting or sub...more >>

From SQL Server 2005 i am connecting to sql server 2000 database. I try to connect to 'Reporting Services Configuration Manager' and i received error message 'Provider load failure'. What should i do to make RS work? Should i reinstall SQL Server2005? ...more >>

I need to modify a report that has a list containing other controls, subreports..etc that can span multiple pages. How can we show a "group header" on each page rendered withing the list? We tried moving the list contents into a table cell but the group headers won't repeat on each page. Th...more >>

I have a text box above a matrix and the matrix is set to start on a new page. how do I get the text box to start on the new page also? TIA Dean ...more >>

I am trying to join two tables from two different datasets in SQL Server 2005 Reporting Services. How would one go about doing this? Since there are technically two spots to have SQL queries (one for each dataset), how does one go about doing SQL? Is joining across multiple datasets even possibl...more >>

When access http://localhost/reportserver$SQLExpress the first time after SQL Server with Advance Services installation on Windows Vista Ultimate, the SQL Server Reporting Services show the following error: "Reporting Services Error: The permissions granted to user 'Adelso-PC\Adelso' are in...more >>

I am currently migrating Crystal Report XI reports over to the Reporting Services and came across a problem. The Crystal Report displays Top N records, subtotal of these Top N records, and the grand total of all the records. SQL stored procedure underneath returns all the records. >From wh...more >>

Hello, I think this may be a bug with SSRS 2005 but wanted to verify in case anyone has a remedy. My report contains a table with an image on the detail row whose visibility is toggled based on a value. Everything works as expected when viewing the report onscreen or exporting to PDF. Ho...more >>

Can someone please provide me some pointers on dynamic formatting. How can I change the formatting information from code. Where on SQL Books online can I get information on dynamic formatting Thanks Karen ...more >>

Has anyone gotten the print control in report viewer to work with Firefox? One of our clients insists on using firefox and we would like to use reporting services. I found and downloaded the Mozilla Activex control and plugin support, added the CLSID for the RSClientPrint control, but have not...more >>

Is it possible to group data in charts? e.g. I need to return a graph with % and other data per office separately for a board pack so the charts either appear per office on a page or a couple of charts per page....more >>

I have created a report with parameters, I select the dates (01/05/2007) to (01/07/07) using the calendar and then click view report the dates then reset to (05/01/07) to (07/01/07) and no data is displayed yet the parameters which are displayed in the report are returning the correct values. ...more >>

any way using report builder ad hoc tool for users to add an "as of" date to a report using the TODAY function? Rich Belanger ...more >>

Hi all Just wondering how one would approach buidling an RS report based on a dynamic table ie. Each time the report is run, the table may have a different number of columns. Here is what I'm trying to acheive: The user enters a date range for the report. The report then calls a SQL sto...more >>

Hi, This may be a silly question, but how do I show both value and percent in a pie chart? Thanks in advance, R. Green ...more >>

I have a report containing drill down detail. The headers for the drill down detail prints even at the summary level. This is causing two pages to print for every one due to the headings. How can I turn the headers off unless the user has selected to view the drill down data. Any help wo...more >>

HI All, Currently we have two servers in our poduction farm. One runs sharepoint and the other is the database server. Can i install reporting services o nthe sharepoint server and tell it point to the database server? Right now I have it installed the db server, but would like to move it ...more >>

If I create a new template, build reports from it, and then change the template, will the existing reports implement the changes? TIA Dean ...more >>

Where can I find some good looking examples of reports and charts that showcase good looking design practices (my efforts leave a lot to be desired:). I can find lots of examples for FrontPage and PowerPoint, anything out there for SSRS? TIA dean ...more >>

When i go to My computer-Manage-IIS(restart). I have folowing error message; The service has not been started. I did reinstall IIS. What should i do to run IIS? Thanks....more >>

I have a report with an embedded image which appears in every row(static), it also has a report that it drills down to. This page that calls this report uses the reportviewer. the report loads quick, but the images take a while longer. If I hit the column that drills to the next report, I ...more >>

I try to deploy report "rptInfo.rdl" and I receive this error; A connection could not be made to the report server http://localhost/ReportServer. Unable to connect to the remote server (Microsoft.ReportingServices.Designer). What should i do to make this work? Thanks....more >>

Hi, we have an installation of MSSQL reporting services where users can select data based on date ranges. Since upgrading to 2005 we now have a nice new Date picker control alongside textareas which accept MSSQL datetime values. This is all very nice but the date picker automatically formats t...more >>

We are starting to use VSS2005 for storing projects and rdl files. We are mainly using it for the versioning capabilities in VSS. Does anyone have any tips for best practices on how to utilize Visual Studio 2005 and VSS 2005? IF anyone has a link or two to sites that go over this topic that...more >>

is there a way to configure interactive sorting so that a group that has been expanded does not get hidden again when the sort arrow in a column heading is clicked? TIA Dean ...more >>

We currently have Visual Studio installed on the Reporting Services server. Are there any issues with installing VS on another workstation instead? Thanks, Steve...more >>

I have a SSRS2000 report with three parameters: 1) Company - values from a query including NULL for ALL companies - no default value 2) From date - has default value 3) To date - has default value My problem is that the report runs automatically when launched. Even though there is no defau...more >>

I'm trying to use SRS to recreate a report that is currently in Crystal Reports. This is basically what the report displays: 2004 2005 2006 Customer Category1 $$$$ $$$$ $$$$ Category2 $$$$ $$$$ ...more >>

Hello I was wondering, is it possible to build a Report Model (VSBIDS2005) from a Stored Proc? Kind regards Ricky (SS2005/SSRS2005)...more >>

I'm having a problem with a report i recently built. I use a table with three colums and one issue I have is there is a lot of white space left all over the report because a table group will not span onto the next column. With the exception of one group that is larger than 1 entire column. Th...more >>

Hi @ All, I have a little problem with this new (for me) tool. I'm using RS2k5 with its defaut website. I have to handle some server-side error and display a custom message. Is it possilble? How? Thanks, N0uxxz. ...more >>

Hi! I have to create a report using a cross-join of an attribute hierarchy and a parent-child hierarchy. For the parent-child hierarchy, I use a nested detail group in my report. (group by uniquename and parent group by parents uniquename) The attribute hierarchy is shown as a group around ...more >>

Hi, In a SSRS 2005 I am having a problem: My report consists of one table report en multiple subreports. The report and subreports have to be paged by product. So page 1 contains the data of product 1 for the report + each subreport. I've achieved this by putting the report and subreports ...more >>

I have a parameter to bring up my report now, which works fine. But I need to add the functionality of bringing up my report from c# now. Any help is appreciated. Thanks, Trint ...more >>

Hi, We use SharePoint to run our reports. When a user changes a parameter within a report, the browser refreshes each time. Is there any way to stop this? Thanks ...more >>

I have a tabular report with several groupings. I want to customize one of the groups. For example I have a field called country. I want to group it by region, western and eastern. How would I do this? ...more >>

I want to be able to automatically create and save an SQL Report (rendered as PDF) from a link on a web page. I know how to setup the hyperlink to open the report directly in PDF (without the user seeing 'Report Viewer') - however I actually want to just save the PDF without user interactio...more >>

Hi, we have a webpage which makes a call to the reporting services function GetSystemPermissions via C# to get permissions for our intranet. My question is how to I add an admin user to this group? Is it done via Active Directory and if so what rights does the person need? We are running MS...more >>

Hello. Is there a way to use value from a field in a table? For example: In the first cell i have the value of "=Field.myField.Value * 2" and in the second cell I want to use The previous value. some thing like: "=Field.SecondField + MY_PREVIOUS_FIELD_VALUE" of course I want it to ha...more >>

Hi I'm very new in this area so please be patience... We run windows server 2003 and SQL 2005 and Reportservices. We have build several reports which we can see on http://localhost/Reports/Pages/Folder.aspx However if we deploy these report to a webpage using the option inVisual Studio, ...more >>

I get this error starting debug or preview with my report after adding inner join script because I needed another tables field: Must declare the scalar variable "@anyName" I have researched this a little and have found no answers, although several posts of this same problem. any help is a...more >>

Hi, I have a report (created in Report Builder) which has a security filter in it (based on userid). I would like to be able to have users subscribe to it and get only the data they ought to see. However, since I have to save the credentials in order to render the report automatically (in sub...more >>

Hi all, I was wondering if it's possible to somehow change the parameters pane design. My problem is that some of the reports we write are in right- to-left languages (hebrew, arabic). We can change the whole report so it's right-to-left, but the parameters stick to the left. Is there any w...more >>

I'm trying to deploy reports to development server that is running mssql 2000 and a named instance of mssql 2005 but when I deploy I'm running into authentication issues. From some articles I'm finding that this can occur when using SSRS in mssql2000. Do I need to modify the deployment path in...more >>

So, what's the buttom line for RS 2000 installation on a computer that runs IIS7? Any chance to install? Thanks ...more >>

I am using SQL Reporting services 2005, and I'm having a security problem that I can't figure out. I have a user that if I give her domain account browser rights, she can run a report. However, if I give her access through a domain group, she can't run it. The group has browser rights to ...more >>

I need to upload multiple reports produced on another server. Is there a script or utility that will allow me to do this? Thanks!...more >>

Hi, I have written an expression for the Visible Property wherein if the data field value is blank, then do not show that. This is working correct, but I want the whole row to get suppressed so that the blank space is not visible on the report. How do I do this. Regards, Sudhakara.T.P....more >>

Hi can someone tell me how to render images with the render method. The report contains embedded images for use with a dashboard scenario. I know I can do it with pdf.... I've also tried to render the file as a mhtml but it still does not render the images embeded that I was expecting. R...more >>

Hi, I have a report that is basically a Matrix report that has totalling rows throughout the vertical aspect of the report (not just at the end) and a totalling columns at the end. Can Reporting Services deal with this using the toolbox and so on, or do I need to get coding? I am pretty s...more >>

I accidentally created a document map and would like to remove it but I can not find out which object in the report is causing the map to be generated. I have a Chart and a matrix in the report. How can I figure out what is causing the map to get created? TIA Dean ...more >>

Hi, I know I am being thick here, and should probably just read the manual, but how do enable users to log on and view reports. I have gone in to the Properties of the report folder where the report I want a user to see is located. I then set the security options to add a user, assigning ...more >>

Hi, I am using Integrated Security yet when I open IE and open //localhost/reports, I am presented with a Windows login dialog box. I then enter the same user name and password for which I am already logged in to Windows and everything works correctly. Anyone know why I am being asked fo...more >>

It would be really cool to sort of ghost our company logo as a background beneath report content. Any ideas on how to do this are welcome? All the Best, G ...more >>

I have a report that groups on a field, AccountNumber (which is a parameter) I changed this param to a Multi-Value field, but now, whenever the report runs, it blows up saying it's an invalid datatype for the grouping. I have the rest figured out (how to parse the comma separated list) but I'm...more >>

I'm traying to find the max number of records that a report can return using Reporting Services. Thanks. ...more >>

I'm trying to remove a user who is no longer in the Active Directory. When I go to Site Settings > Configure site-wide security > check the box for the user to be deleted and click "Delete" I get an error message "The user or group name 'domain\username' is not recognized. (rsUnknownUserName)...more >>

Hi, I have another question about code in RS. I have a table cell with FORMAT of "$#,##0,0". If I have any number in the cell I want to display it. If I have 0 (zero) I want the cell to be empty. I know how to do it with an expression: iif (Fileds!myFiled.Value == 0,"", Fileds!myFiled.Value) ...more >>

All, I'm sure that many of you'll will have come across this issue earlier. As you're aware RS does not allow for merging of vertical cells. I need help with working around this to design a layout as below: ---------------------------------------------- | D1 | D2 ...more >>

Can someone explain mistery behind that message while installing RS? What if IIS is running? What else to check then? Thanks...more >>

I am getting the following error. Reading other posts, I have set the C:\Windows\Temp write permissions to ASP.NET and NETWORK SERVICE users. Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\nyudtfly.0.cs' could not be found error CS2008: No inputs ...more >>

Hello, I wrote a function in vb.net and i Sent her parameter. The function is used in a table cell. I want the function to use a field value, I tried : Fileds!myFilesName.Value But it didn't work. Can I do this kind of thing? Thanks. ...more >>

Hello. I wrote some code in VB.net in the code section of a report. I saw in a few places thet u can wrtie in C#. Is it true? When I tried I got an error. I'm using sql2005 Thanks ...more >>