Dear All, We are facing some issue in reporting service subscriptions. In one of the server when We create subscription to save or send report, Its giving below error. But reports works fine directly from the report manager. ERROR: Failure sending mail: An error has occurred during r...more >>

duh I know. I'm on the reportserver as administrator. I'm looking sql mgt studio and iis, I know reports and folders are there somewhere, but can't see them. Thanks for any help or information. ...more >>

I am making change to a report and believe I am correctly deploying it to an ssrs report folder per the messages I get back from vs.net. Question is, how can I see what folders are available? and where? At some point I knew or was able to do this, and think it was through SQL server since I ca...more >>

Hi, Does anyone know how I can limit SS report access only through our application? Thanks. SSRS Standard Edition ...more >>

I have an XML field (of type XML) in my report's underlying table. I want to display a hyperlink in my report. When the user clicks on this hyperlink, I want them to be able to save the xml value as an XML file on disk (i.e. "Save File As" in MSIE). Has anyone tried this? Thank you, --...more >>

Hello. I've got an odd requirement to password a particular report.Basically the same authenticated user will have access to all reports, but this particular report should only be available to select users(all which share that username). Any way to mask an ssrs parameter input so that it on...more >>

SS2005 64bit is installed and running fine on my copy of Vista Business 64 here I've gone into Programs and Features and enabled all the IIS/ASP.NET stuff posted on the internet. I've also created a IWAM_computername account and added it to the Administrators group. The setup program ...more >>

Hello Fellow RS Has anyone ever heard of or tried adding to the report export list? I've read through the BOL for report export options and searched the web for advice. There is quite a bit of information folks have shared on ways to export stored procedure results to a fixed length text f...more >>

I have a report that contains a single chart. That report works fine by itself, and as a subreport in many other contexts, but... When I use that report as a sub-report inside a table, passing all of the parameters to the sub-report based on values from the current row of the table... T...more >>

I cannot create any subscriptions from Management Studio. Reports have shared Data Source with stored credentials SQL Agent is up and running In surface area configuration "Scheduling and delivery" for SSRS are enabled SSRS Execution account has been set up E-mail settings are fine I'm logge...more >>

When I go to inetmgr => Web Sites => Reports The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. -------------------------------------------------------------------------------- A...more >>

Hi all I have a scenario where I need to retrieve scanned images for a report. The plan is to have one page showing items submitted from a table and the remaining pages producing the linked scanned images. the scanned images will probably be PDF or data held in XML format. I am thinking th...more >>

I have a _very_ simple table with just one row and three columns. The first column of the row contains a subreport that retrieves a single value. The second column of the row contains a subreport that retrieves a single value. ....and heres where I lose it... :-) The third column sho...more >>

I am having issues installing the reporting services addin for sharepoint. While the installer claims the install was successful, I do not see the features in Sharepoint Central Administration. A look at the install log shows that the install failed. I am logged in as administrator, this ac...more >>

Hi, I have a report with parameters and need to get it via C# in PDF Format. Need an example that works. Thank you, ...more >>

I have freshly installed new OS and SQL 2005 with Reporting Services. When I try to navigate to ReportManager I am getting "Cannot connect to remote server" message. What can the problem be? Thanks ...more >>

I'm working on SSRS 2000 to start off with. I have a subreport that takes one parameter. It worked beautifully until I had to change my result set to include records that did not always have the necessary value for the parameter so my parameter went from.. parameter = fieldname To para...more >>

Hello everyone. I am still trying to get SQL Reporting Services to work with MSPS 2007. When I create a report and try to deploy it, I am prompted for a user name and password to connect to the reporting Server. I am working in the microsoft EPM2007 demo environment and am trying to use the f...more >>

I want to create a report with two columns with a single group heading with one table. I will use this as a subreport in a larger report consisting of single column tables. When I layout the report it shows two columns but when I preview the report it is just one long half-size column and neve...more >>

Hello. I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter. When the report is runnig the parm1 value is "false". How can I protect this parameter from a change by the user? I mean - the user can run the report and then add to t...more >>

I have a report "Clearance Summary Report: Each page summarized the total sales for one agency. Everything works great except for one total "Adjustments:" An agency can have one order but have 50 adjustments to that order. That is why the Adjustments can not be included in the "dsReport" que...more >>

Hi All, we have a little over 1000 lines of functions and code an we maxed out the code editor, and can't add any more lines. Any workarounds or suggestions? Thanks, Scott...more >>

I've figured out how to send multi-value parameters to my stored procedure using a split function when my parameter is an integer. However I need to do the same thing with a character parameter. It works for the first value, but that's it. Here's the function that I found: USE [EdCat] GO /...more >>

Hi, I am analyzing the internationalization support in SSRS 2005. I have the following queries. Query #1 Does Report Builder have internationalization support? a)If the browser language setting is french, will the report builder display french automatically? b) Or is the localization feat...more >>

I would like to require that the users select the "view report" button before the report renders. How can I do that? Also, can I trap the event for when that button is selected? how/ where? Thank you. ...more >>

Hi, We have a field in our dataset which we want to appear in the footer of each page in our report. To do this, we have added a textbox to the body of the report and reference this data in the footer using the following: =ReportItems!site_code.Value This works fine, except when the re...more >>

Hi all, Do you know that can we use 'distributed queries' in reporting services to create rdl report or use linked server as datasource. please advise if any direction, many thanks. e.g. SELECT s.sales_amount FROM access_server...region AS r, oracle_server..sales_owner.sale AS s, sql_serv...more >>

Hi I need some help with this case. I have the sample report like this: No# Desc Amount 1 Quantity1 (Pcs) 10 2 Quantity2 (Pcs) 15 3 Price1 ($) 800 4 Price2 ($) 200 Total ($) 1025 I want to get th...more >>

I have installed SQL 2005 reporting services and I configured it using Reporting Services Configuration. Now I tried to access to report manager using http://servername/Reports with login I used to start reporting services. It doesn't work and keep prompting me for login and password. But no use...more >>

Well I've seen several related posts but nothing seems to exactly fit what I need. I real new to RS so bare with me. What I have is a stored procedure that returns several elements of an address per row. For instance, Name1, Name2, Name3, Street1, Street2, CityStateZip. What I need is to colla...more >>

I have followed the steps outlined in http://blogs.msdn.com/sharepoint/attachment/4194088.ashx to try integrate my WSS 3.0 and SSRS 2005 sp2 instance. While the reporting services configuration says I am in Sharepoint integrated mode and it takes me to the sharepoint central admininstration...more >>

My company has SQL Server 2000 and is currently upgrading to SQL Server 2005. Is there an easy way to determine if the Reporting Services module is installed. I have access to Enterprise Manager and Query Analyzer. Is it possible to use either of these tools to see if it is installed?...more >>

Does anyone know of a way to control the width of the parameter drop down in Reporting Services 2005? When a parameter is not multi-value the width is adjusted to the largest member, but when the parameter is multivalue it appears to be a fixed length regardless of member size. The result ...more >>

I have a SRS report in Visual studio, picked the printer and page size, then deployed. I want the printer to be set to a specific printer. It seems it is defaulting to the user's default printer while running in IIS. Please advise...more >>

How does one specify a different data source folder path when deploying a report to a report server (2005) using RS scripting? I started with the PublishSampleReport.rss script sample from microsoft and need to publish a report (i.e. rs.CreateReport... ) to the report server that references...more >>

I am currently struggling with this one, can anyone help with this supposedly simple problem. I am trying to pass report parameters to a Report that exists on A Sharepoint Site that has had SSRS Deep Intergration applied. Can someone give me the typical URL to do this, and let me know the p...more >>

Hi I had been struggling earlier to get the Firebird data into SQL 2005 Reporting Services. I was using the Firebird .Net provider for that. I changed the source code of Firebird .Net provider to replace the "[]" brackets by blanks. So the Data View was created by Studio. Question no.1:...more >>

Hi, Does anybody know if it is possible to concatenate text fields in a group? What I need is the following: I have in my dataset some appointment records with one or more participants. For example: AppointmentID > Date > Subject > Participant 1 > 1/1/2007 > Visit > Mary 1 > 1/1/2007...more >>

this is doable in a table but what to in a matrix ? /michael v. ...more >>

I get javascript errors when i click on the datepicker. What might cause this? My reportviwer is inside a contentpage. Any way to disable or remove the datepicker from the report?or is it required when expecting date fields? Thanks for any help or information! ...more >>

What is the logic behind it that maximum no of clustered index on any table is 249? ...more >>

Hi, I'm just installing Reporting Services from SQL Server 2005 and I'm following this document: http://msdn2.microsoft.com/en-us/library/ms143703.aspx Installation went fine from what I can tell and now I'm in the second section "Configure the Report Server and Create the Remote Database...more >>

I have a question about the Report parameters box size. Is there a way to adjust the size for the parameter box display. I need inc. the size. I am using Microsoft Visual Studio to create the reports. Thanks -- Tarun Patel...more >>

I need some help with this query. I want to extract the sum of payment amounts from an invoice table base on the last dates payments were applied. Sample Table XYZ: Invoice# Date Amt 1234 10/15 200 1234 10/5 1200 1234 10/20 600 1234 10/20 400 Thanks in ...more >>

I want to create report through Microsoft Visual Studio 2005 (Business Intelligence Project (Report Server Project) in Windows XP. Which SQL Edition I can install in windows XP that gives me facility to create report via Business Intelligence. Thanks ...more >>

Hi, I have one report that call 3 different subreport but I only need to show one of them according to an input parameter. Is the a way to just call one report instead of calling all and hidden 2 of them? The report becames a little bit slower when I call with the 3 subreports. Best Rega...more >>

Hi, In my report, I am displaying two tables. Both table has headers.The first table will end at 1st page itself & the second table will start from 1st page of my report & continue for n number of pages.I want to show the header of the second table from second page onwards.How can I imple...more >>

Hi I want some help regarding hiding data only if some condition is satisfied.Say if condition is satisfied field value should be visible on report else not.Any pointers or help would be appreciated. Thanks in advance. Regards, Sunil...more >>

Hi, I have two diferent datasets in the same report, let's say Master and Detail. What I need is to show in the same table data from Master dataset and the count of the Detail dataset. For example, one table row should contain the following columns: - MasterDataset.Field1.Value - Mast...more >>

I have installed SQL 2005 reporting services and I configured it using Reporting Services Configuration. Now I tried to access to report manager using http://servername/Reports with login I used to start reporting services. It doesn't work and keep prompting me for login and password. But no...more >>

Hi experts I am working on sql server reporting services 2005. I am using Date time control for my report parameter. And default value i given =Today(). This is working fine. But i want some days previous date for default value and when I am writting Today()-1, Report is giving error. So can a...more >>

Hi everybody! I've created a report in reporting services and in it i need to have a dynamic textbox. Let me describe more.I have two reports ,in first report i have manegers' names .After that users see first report and manegers' informations for example their names and saleries , they wa...more >>

This relates to my previously unanswered post "HTTP Error 401.2" but when I try to connect to Reporting Services via SSMS using Windows Authentication (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005. The request failed with HTTP status 401: Unauthorized. (Microsoft.Sq...more >>

When I test my query in the "Data" window (tab), I get a healthy number of rows returned. When I test under the "Preview" window (tab), I get a tiny fraction of rows returned. Can someone tell why this is? Perhaps, something in the "Layout" that I am missing? I'm not even sure how the data...more >>

Hi, I've got this ssrs 2005 report that works great passing a few security related parameters from asp.net codebehind. However, there are two date related parameters that won't be coming from my web form, but rather from the report form itself. When I test the report's date parameters from visua...more >>

I have a report request that requires a user to be able to add 48 values. These values do not exist in the database and would require user input directly into a table. Are they any controls that would allow this? ...more >>

Hi .. I installed SSRS on W2K Server machine also running SQL Server 2005; after the install completion I keep getting the following message: "The report server is not responding. Verify that the report server is running and can be accessed from this computer" when I type http://<ser...more >>

Hello Everyone, I'm running SSRS 2005 on top of a sql2000 database. I'm trying to create a report that list assemblies- a bill of materials- that go multiple levels deep, for now a minimum of 4 levels deep. Say I have an assembly/kit part number; ST-987589 That kit contains 3 part numbe...more >>

Can anyone explain please why headers and footer information is not exported when exporting to XML? Does not make sense why this should not be included for XML. Can probably understand why no headers and footers for CSV files? -- Steve G ...more >>

Using Reporting services, how do I insert a Report group?...more >>

Hi All, Is there any way to customize export format drop down list? I do not want so many export formats,I just want these 3 [PDF, Excel, tif] option to apear in the dropdown. Thanks in advance. Rakesh Halder ...more >>