Can anyone point me to some effective, online resources that will help me understand how to configure security on reporting services -- do I have to be SA in order to generate a reporting services model, for example? There are server and database security considerations, as well as reporting se...more >>

Hello, I am very new to sql server (as in, still reading the table of contents in the big honkin' book I bought). is there a way for users to send an inquiry to an email address, and get a response from sql server? It would be very helpful if someone could send an email to parts@##.com w...more >>

Hi, My manager wants to upgrade from SSRS-2000 to SSRS-2005, but he doesn't want to upgrade to SQL Server-2005 yet. Can we do this? Will SSRS-2005 work with a SQL Server 2000 Reporting Services database/Report Catalog? -- Thanks, Jeff...more >>

I have a drilldown report. Without opening a drilldown item, is there a way to search for a text string using the "Find" link when viewing a report? If not, what would be the best recommendation to accomplish this....more >>

I need to be able to merge two different results from two different datasources. One datasource is connected to Oracle and the other one to SQL Server The parent record comes from Oracle and may have detail data in SQL. I want to display results in one single report services table. Is there a ...more >>

I have a dataset returned from sql server that can be represented for the purpose of this discussion with 2 columns. From the server all the data is sorted first by column 1 and then by column 2 so that the resultset looks like the following: column1, column2, column3 a, 1/1/2007, 10 a, 2...more >>

I have just deployed about 75 reports to my Reporting Services instance. I now need to create subscriptions to ALL of these reports. The recipients will always be the same, as will the schedule. I've already gone ahead and created a shared schedule. What I would like to do is to create a su...more >>

My organization is moving to a SQL based CRM solution that is customized for our industry. As a part of this move we are converting all our documents over to SQL Reports. We have also been contemplating using a CASS certified product to help us get some substantial postal discounts for our m...more >>

Assuming all the servers in our environment are quad processors and at min. 8Gig RAM: 1. Should reporting services reside on its own server box. 2. Is it recommended that the .mdf, .ldf, tempdb reside in a SAN with fibre HBAs...more >>

Dear all, We have requirement like we need to embed lots of Word Object in the Report. I would like to know whether it is possible using Reporting Services. Thanks & Regards, Anil ...more >>

I'm using a PageViewer control in SharePoint to view a Report in SQL Server, so the URL that is pulling up is something like http://servername/ReportServer/Pages/ReportViewer.aspx?%2fOceanSpray.SharePoint.OsciReports%2fSavings+By+Plant&rs:Command=Render The report comes up and displays the re...more >>

Hi, this is my problem: I have a Table defined in some report (Reporting Services); the Table has a grouping, and each Group has one or more detail rows. So far so good. When details belonging to some group do not fit on the current page, they move to the next page - and this is my prob...more >>

Hello All , I have MOM 2005 install along with SQL reporting services 2000 with SP2 . I have all the components installed in one Server . Now I am facing problem . When I print reports for now assume those contain graphs and bar charts it is not printing in one page neither I found any op...more >>

I have one report with two datasets, and consequently two queries. The first one gets a list of ReportID's for a particular day, while the second dataset uses each ReportID to create a report. Query 1: SELECT ReportID FROM Table1 WHERE Date=@Date Query 2: SELECT * FROM *A whole bunc...more >>

Where can I find the report designer installer. I only can find the reporting services configuration utility. Thanks Rob ...more >>

We need to live with Global Variables in user code (embedded in the RDL) Question 1: What is the scope difference between Public Shared and Friend Shared? A MS oficial (forgot who, he was on the Reporting Services Team Member Blogs: one of Bob, Brian, Chris, Lukasz, Tudor) wrote in his bl...more >>

Question 1: May this hotfix help me out Question 2: Where to get this System.dll 2.0.50727.224 When I start VS2005, open an existing Reporting Project and this opens with one Report Form in Forms Designer Layout, the following message appears sometimes: Microsoft Visual Studio: Object re...more >>

Hi: I have two parameters in my report. Date and Name. user should be able to enter data to one of the parameter field or can enter to both fields to generate the report. I have below query and it is not working ... If i don't enter both values i get an error message saying that "enter a...more >>

I really just do not understand this and it is really frustrating me... I made a custom authentication/authorization extension that uses forms authentication... it works fine on my local system (32bit windows xp pro sp2 with SQL 2005 Dev SP2)... So I installed it onto our development test serv...more >>

Can reports I created in SQL Server 2005 using Reporting Services run on SQL Express 2005 with SP2? I am a developer and some of our clients use SQL Express. Thank you. David ...more >>

Hi, I have a front end application where I'm using the reportviewer control. if the user open a report and don't do anything for 10 to 15minutes, and then try to export the report in PDF, an error is raised: Execution 'mlgd4355vz5mgouvwv2guz45' cannot be found (rsExecutionNotFound) on the RS...more >>

This is probably something trivial, but I'm from an Oracle Unix environment and I have no idea how to solve this in windows server 2003 with SQL Server 2005 sp1... it happens whenever I run any report. An unexpected error occurred in Report Processing. (rsInternalError) Get Online Help Spec...more >>

VB 2005 to Report Services 2005 My project shows a datagrid populated by a datatable. When the user clicks on Print Grid, I want to send the datatable to a report service report. What is the code to call the report service report and to send the datagrid to the report? I created a separ...more >>

There are a number of post out here on this problem. When you bring Report Manager up (http://localhost/reports) you might not see the tabs for Contents and Properties and the menu bar or you do see them but you can not select any of the items on menu bar. One solution that seems to work f...more >>

Yesterday, I was able to go to http://localhost/reports and manage roles and users in those roles. Today, that page looks different. I'm not sure if anyone ran anything or what, but I now just see links for various projects. I noticed in IIS that there is a pages/roles.aspx page so I type...more >>

Thanks in advance. ...more >>

Can i do this? In the filter window, i want to add a field and make it into a prompt. But then when the users run the report they should have the ability to not select anything from the prompt and hence see the report for all values of that field.......more >>

I'm using SSRS 2005 and I can create report that use the enable drill down function fine, and when the report is displayed the user can click on the + signs to expand a group. I would like to add the option for the user to be able to Expand All or Collapse all. Currently they have to click o...more >>

In RS2005, can I tell it not to break for pages? All of my objects on the report say FALSE to break end/start, and i've tried putting the report size to something outrageous (like 50 inches) but I'm still getting a page break. I must be missing something but I can't figure it out. Help ap...more >>

I have a report which uses a query to populate a parameter. The default value is not queried, this is just set to "=1". When the report is deployed, the parameter in report manager is showing as 'query based' which is wrong. This is a pain in the ass as when I try linking to this report, ...more >>

Hi, I try to start a report vie following Link http://srall011/SmashANALYST_ReportServer?/Kunden/Test&rs:Command=3DRender&= Region=3DAargau but it doesn=B4t work. The given parameter ("Aargau") is not selected in the list. The Report works and there is only one parameter. Any Ideas....more >>

Can anyone tell me how to name the sheets on an export to Excel? Lets say I have two tables and my interactive format is set to 8.5,0 on each so the output will contain sheet1 and sheet2, one for each table? Is there a way to name the sheets the table name or some field within? Thanks Bo...more >>

Please somaone help me. I am facing problem with SQL 2000 Reporting Services. I have configuration Windows server 2000,SQL server 2000,SQL reporting Services, ..NET framework 1.1. Actually i am getting the error in Event Viewer as aspnet_wp stopped unexpectedly with Event Id 1000. That's why...more >>

Hi Friends, I am generating a report using sql server reporting service and rendering it in my .aspx page in a report viewer control. Now i need to export it to excel so that the excel file can be stored in client pc.How do i show an save as dialoge box,so that user can either save,open or c...more >>

I have created a query for a parameter ie: select id. name, type from tablea I would like to show both name & type in the value (drop down list for user). How can I do that? -- Karen Systems Analyst...more >>

We will have many developers creating .rdl reports in SQL Server 2005 Reporting Services. Is there a way I can create some sort of "template" report that has the colors, font style and size, company logo in just the right size and location... that everyone could somehow have that to start w...more >>

We have tried a bunch of different ways to run reports in the ASP.NET Web ReportViewer. Every attempt to do it ourselves has failed to render. We have a number of examples of local processing in Web pages. Heck, we even have built a number of Windows Forms applications that use both local ...more >>

Hi Expert! I got a report showing the list of current sale volume by each office branch. We got 20 offices. Is there a slideshow software package or ASP.NET control out there to display my report as what PowerPoint does. I would like to be able to pass in the report parameters. Thanks in...more >>

I'm getting login errors when trying to run reports both locally on the report server and remotely on a client machine. This is the error I get: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'RequestDataSource'. (rsErrorO...more >>

After installing sp2 on my production server ( went well in dev and qa) I got this message: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title>...more >>

After reading tons of articles about how to prevent initial execution of a report (which I do know is by design), I came up with my own hack. WARNING: This is definatey a Hack!, but once you have gotten past the initial shock it does work quite well. (The code was only tested on SQLRS 2005, so i...more >>

I'm trying to administer permissions for other users so that reports can be viewed remotely. I'm told to go to http://myserver/reportserver but I get this error: The permissions granted to user 'MyServer\IUSR_MyCompany' are insufficient for performing this operation. (rsAccessDenied) I'm...more >>

Hi all, i am facing a typical problem in SSRS.I have a report which have a subreport.Everything working fine if i have data on my main report and my sub report also,but if i don't have any data then report is giving a error when i am trying to EXPORT it in some version(.xls or .xml etc). ...more >>

Since the Business Intelligence Development Studio comes with the workstation components, one could assume, that one licenced copy for it comes with each licenced CAL, but is that really so or do you get just one per server licence? Mike...more >>

Hi, I'm using SQL 2005 repoting services and came upon a strange phenomenon: Every once in a while after installing reports on the reports server I find out that one or more of the reports got truncated names. I couldn't find any regularity. The names length is not the same and I couldn't find...more >>

I have a parameter that get his values from a query. his defualt value is Null. In the report page, The first value is "<select a value>". even if I give the parameter another defualt value Then it open with this value selected but still the first value is "<select a value>". Can I remove t...more >>

I think I'm supposed to go to http://localhost/reports to manage permissions and other. But when I do, I get the error: The permissions granted to user 'BOUDTFS\IUSR_FIVERIVERS' are insufficient for performing this operation. (rsAccessDenied) How am I supposed to give necessary privileges...more >>

Hi all, I have installed SQL Server Express 2005 Advanced (with reporting services). I have followed the videos on the microsoft site. Everything seems to install fine, but I can not get into the http://localhost/Reports website or the ReportServer site. I tried changing the access on the sit...more >>

Hello Everyone, I am attempting to create a report that contains two matrices. Each matrix will use it's own dataset. My problem is on the second matrix...I am unable to fiture out how to code the Value Property to refer to the field without First or Sum. When I drag and drop the fields into t...more >>

Is there anyway to view or get the number of days that an item will be marked as "new" for? or any way to change this? or does anyone know what the default value is? thanks! ...more >>