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

We are unable to maintain the format of our 3 column style report when we export the report to MS Excel. However, we have no problems with maintaining the 3 column style report format when exporting to .PDF. Please help! However, our business depends on this formatted report for our 2400...more >>

Hi, I am wondering if there is a way to change the text direction of text in a cell in the table header row. For example, the results that will appear in the detail portion of the table will simply by Y or N. I want to turn the text sideways so it takes up minimum space. I don't see anyt...more >>

How are reporting services reports scheduled to run and email? I don't see any links in the SQL Server Business Intelligence Development Studio. Are there plug ins or something else from microsoft that could be missing? I have SQL Server 2005 SP1 running on my PC (windows 2003). Any step by st...more >>

Hi; im new in reporting services and i need my network and terminal service users, can generate the reports (using internet explorer) but i dont want they have to type user and password again, is there a way that windows's user and password can be used for the reports? TIA ...more >>

This seems to be a longstanding bug that has not been resolved in 4(?) years and is also present in ReportSvcs 2005. When you export a report to Excel, merged cells "CanGrow" property is ignored. (For us at least) this almost renders Reporting Services utterly useless. So for instance if yo...more >>

Hello: I have a report with several tables, each of them "Inserts a page break before" (so it renders on an individual page) The visibility of one of these tables depends on the data and some problems are derived from this situation: 1 -The table with the Hidden expression is not insertin...more >>

How can I show some sensitive data differently to different users?...more >>

I'm a beginner with SQL Reporting Services, so I apologize if this is a well-known issue: I have a report with multiple subreports. I want 2-3 logical "columns" of subreports, each subreport potentially being a separate height. It seems that if I put several subreports on the page, the top ...more >>

I've created a report in RS 2006 that uses an XML data source. The source uses a web service that takes sufficiently long to return that my query times out. can anyone tell me how can I increase the timeout value of the query? ...more >>

We are having an issue that 1) I can not find any documentation on how to setup correclty and 2) have not had any postings from other experts that have actually worked. Here's the issue along with our environment: Server 1 - Windows 2003 SP1 with SQL Server 2005 SP1 Server 2 - Windows 2003 ...more >>

I have a dilemma. I am creating an invoice report with a fairly complicated hierarchy. I have it working so far. All the invoice elements are doing fine except the taxes. Because of business requirements, it is not possible for me to get everything in a single dataset. My invoice may have 40 ...more >>

I have a SQL Server database and stored procedure to return month no, budgetamount, actualamount. Budgetamount has values for each of the 12 months of the year actualamount has YTD amount for each month. The user wants to see a total for the budgetamount for the same time frame as the actua...more >>

How can I hide a static row/column in a matrix? The static row/column should only display depending on a parameter. thanks, ...more >>

Hello again, everyone. I'm in the process of upgrading to SRS 2005. We have an instance of SRS 2000 on one server, but wish to migrate all of those reports to a new server with a clean installation of SRS 2005 so that the 2000 hardware can be reallocated. Needless to say, I'm not the re...more >>

I'm trying to use an expressions like these to alter the font size.... iif(Len(Fields!MyField.Value) > 12, "7pt","8pt") iif(Len(Fields!MyField.Value) > 12, 7pt,8pt") iif(Len(Fields!MyField.Value) > 12, 7,8) Regardless of which expression I use, I get this error: "<my expression> cannot be...more >>

Dear all, We are migrating step by step our different environements, we would like to migrate SQL 2005 first, then migrate all the other applications to .NET v2.0, Reporting Services 2005, ...etc. We already bought the new SQL 2005 servers and we have several questions about this : ...more >>

I'm a DBA and need to deploy the reports our developers made in a test environment on the production servers. What is the best way of doing this. Are there some how to's, white papers or best practices? Regards...more >>

Hi All, I am getting Reporting Services Login box , when trying to deploy the reporting services reports on the test server. After entering username/password it does not do anything, I mean not allowing to deploy. I am unable to deploy straight from VS2005 (on development box) to the test se...more >>

Hi, is it possible to start a Report via Link (from Desktop) with start parameter like an ASP-Script For example: ....report.rdl?Year=2007&Month=6... Thank you Hans ...more >>

Hi, I am generating report using stored procedures. I am passing values to the SP parameters for the report through URL. When I generate the report, the parameters are being displayed in a toolbar at the top of the report. Is there any way I can hide the parameter toolbox or parameter list wh...more >>

Hi I have installed sql 2005 sp2 but i found a serious problem. When i open a preview of a remote report from a windows form application and press the "print layout" button on report viewer i see a black page. I think there's a problem with transparent colors ( Vista support????) No problem i...more >>

Hi, I'm new to reports. I have created a report with two tables in it. One table gets its data from a dataset which is linked to a stored procedure. The sp takes 3 parameters, market, fromDate, toDate. The report has 3 parameters also and these are passed to the proc to populate the first tab...more >>

Hello NG, I want to run my generated report like the Account Overview out of an Account. The Report shows Informations about an Account. But if I run this Report out of an Account the Report gives me Informations to all Accounts an not just from the selected. What should I do that just the ...more >>