Hello! I have a list that contains a small matrix. I don't want the matrix to ever have a page break in the middle, but checking the "Fit this matrix on one page if possible" box seems to have no effect. I'd like to set it up so that there is a page break after every 4th repetition of the ...more >>

I am trying to write an expression that says iif (field.receipt date is < currentdate by 30 days, then grab field.cost, if not then blank " ") Basically, I am trying to write a report for aging buckets. Thanks, Ryan...more >>

When I print my report in SSRS it says there are 5 pages, when I print my report to the printer, 22 pages comes out, every other page is blank. It does the same when I print it to PDF. I went to Report Properties>>Layout and have my settings as 10in Width, 8in Height and margins are set to...more >>

To whom it may concern at MSFT: Reporting Services REALLY needs to implement style sheets and/or themes. The lack of this technique to easily format multiple reports is a major oversight and should be addressed in a service pack so that we don't have to wait for SQL Server 2008. ...more >>

Hello all, I'm having difficulty getting Integrated security to work with an XML datasource that points to a web service. In the credentials tab - i've set it to Integrated Security. The web service is set to integrated security - but when I try to use the datasource i get and error. "...more >>

I am trying to format the phone number field in a report. The phone number is saved like this: 2126492824 I wont it to display on the report like this: (212) 649-2824 I tried the format tab, It did no good. I trided this : =Format(First(Fields!Phone1.Value, "SQLREPORTS"),"(###) ###-###") ...more >>

We have a web application using SQL Server 2000, and we'd like to add ad-hoc reporting. Here are the options we thought of so far: 1. Use SQL Server 2000 Reporting Services - but we're not sure how "ad-hoc" we can get using SSRS. Has anyone tried? 2. Use a 3rd party reporting software package....more >>

Hi All, I have a couple of reports that have date params. I would like to schedule the reports to be emailed but, I cannot determine how the parameters should be setup. The date parameters would be as follows From Date today's date -1 To Date Today's date. I have tried =dateadd(dd, -1, n...more >>

Hi, We create rdl files which contains <Hyperlink> elements. The value for hyperlink is an expression build using report parameters, field parameters etc and also contains calls to custom assemblies eg : <Hyperlink>=Parameters!Param1.Value + CustomAssemblyCall + Fields! someField.Value<...more >>

Hi. How can I stop text wrapping within cells on my reports? ...more >>

Hi! Is there a way to make the name of the report dynamic? instead of just appending a number if a certain already exists, the name could append the name of the current month or a selected parameter. Thanks! :) ...more >>

Using VS2005 and creating reports. GUI has combo boxes with lookups. The main table is storing the selected.value of the combo box, but the combo box is displaying the "Name" column. How do I display the "Name" column value on a report for a field instead of the integer value of the row?...more >>

If I create are report using a wizard, there are some color choices available, how can I pick from this same list when I create a report with the wizard? How can I easily apply the same color theme to multiple reports? TIA Dean ...more >>

hi, I have a report i have written which contains data to be inported into SQL from a SQL report however when i export to CSV the header line which just contains a HDR and date column are repeated on every detail line? i had this problem in Crystal aslo but crystal had a fix any ideas how t...more >>

Hi all, I have a Windows Forms application in VS 2005 that displays reports inside a System.Windows.Forms.WebBrowser. The user can print using the print icon within the browser window, but I also have a big Print button on the form that prints directly. Now, with RS 2000, my print button ...more >>

Does anyone know how to change the currency as follows: from: $2,332,765 to: $2.3 I've tried several combinations of ($#.#;$#.#;$0.0) and nothing seems to work Thanks in advance Lisa ...more >>

Hi ALL, I have a problem and i becoming crazy ! I create a report like this using a Matrix in Reporting Services Sales Area 1 250 Customer 1 100 Customer 2 150 Area 2 60 Customer 3 40 Customer 4 20 I need to add a total row witch is the sum...more >>

I am getting this error when I run this report only when I access this report from my PC. When I run it on the server it works fine. Any idea. Thanks...more >>

SharePoint 2007. I have the SSRS Web Part embedded in a page as part of the dashboard. The SSRS Report displayed in the SSRS Web Part contains a link (aka Jump To Report) to a second report. I want the second report to open in the parent SharePoint page, not in the Web Part. The Web Part...more >>

Hi, I just installed a server with Windows 2003 Std SP1, with SQL Server 2000 Ent (sp4) and SQL Reporting Services 2000 Ent (sp2) After installation i got the following error after a reboot: The application-specific permission settings do not grant Local Activation permission for the COM ...more >>

hi all, i've just updated my sql server 2005 with sp1 and sp2. i want my report date format to change according to regional setting, therefore i've set the report property for language as User.Language. i've also enter the format i wanted in IE option.. how do i set the report parameter...more >>

I have an issue with Visibility property and page break combination, When i use visibilty property for making list visible and hide. And in the list general tab----> I used edit detailed group and provided groupId and given page break based on it. But its not working when i use expressio...more >>

We have windows authentication set up on our report server which we have been using for a couple of years now. Recently it started to pop up a dialog box asking for my user name and password after I had changed my password on the domain. Since I am an administrator on the domain, I did a test ...more >>

I have the following query. It works great, but I would like to only pull the TOP 10 Counts of the result. How can I accomplish this. Thanks for the help. SELECT DISTINCT FR_FIRM_1.CITY, COUNT(FR_FIRM_1.CITY) AS FIRMCITY FROM FR_FIRM_1 INNER JOIN MR_MEMBER_1 ...more >>

We are creating a matrix report with multiple row headers. There are duplicate values in the first column. The duplicate values are hidden but we would like them to be displayed. The “HideDuplicates” attribute is unchecked. Ultimately, this report will be exported to Excel and we will ...more >>

Hi: How do I create a drop down box in the report based on a query like: SELECT chStaffCode, vcStaffName, chStaffInitial, sdOfficeEffDate, chCurrOfficeCode, vcSurname, vcPreferredName, vcFirstName, vcOtherNames FROM tblStaff WHERE (chStaffCode = @Param1) if I am taking o...more >>

What's the syntax for a data function parameters for a subscripion? ex: I currently have my start and end date hardcoded, but I want this to be 1st day of month and last day of month. Any ideas? thanks, Voss. ...more >>

Hi, Is it possible to display 0 in a table? i have a table that drills down into Region and say for instance when a region has no sales for that day i would like it to show as 0 not not show on the report in crystal i would simply use a else 0 anynow know how to achieve this in SQL reportin...more >>

I'm trying to run this query and it keeps erroring out on me in VS.net and on the server -- it's generic can anyone help? SELECT dbo.MSP_TASKS.PROJ_ID, dbo.MSP_WEB_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_ID, dbo.MSP_TASKS.TASK_NAME, dbo.MSP_VIEW_PROJ_TASKS_STD.TaskS...more >>

Hi, I am getting this when attempting to add or modify a subscription: A subscription delivery error has occurred. (rsDeliveryError) (Report Services SOAP Proxy Source) ------------------------------ For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Reporti...more >>

Hi there. I'm struggling to get a distinct field in Reporting Services. I know how to do it in SQL. It's a simple as SELECT DISTINCT Field. How does one do the same thing in Reporting Services? -- Regards,...more >>

Hi, I have configured the reporting services configuration in sql server 2005. The sender address and the smtp server are configured corretly I get this error when a report is to be emailed. Failure sending mail: The transport failed to connect to the server. Thanks...more >>

Hello, I created a aspx-page, which I added a Reportviewer (Server-Report). At present credentials by NT-Authority/Network Service are used. Since however the server is English-language, at the moment everything is displayed in English (e.g. "Show report", Tooltips...). I would like gladly...more >>

Hi everyone! Is it possible to changes the background color for each row? People coding asp.net would know this as "AlternatingItemStyle" in a datagrid. Can this be done using the VS IDE or do I have to go behind the code in the rdl file? Best Regards Jesper. ...more >>

I have Report Server installed on a two-machine web server cluster. Myself as well as some other users can access and run reports, but others cannot. They receive an error when first navigating to the report site stating "The encrypted value for configuration setting DSN could not be decrypted"....more >>

Basically, I'm trying to create cascading report values. The user has the option of selecting from these types of date ranges: All Year Quarter and Year Date Range If they select all it will go out and run a funtion to get the earliest date and the latest date. If they select Year, I'd l...more >>

Hello, I am really hoping someone can help me out, I don't have a lot of SQL or SQL Reporting Services knowledge so please bear with me. We use SQL 2000 Reporting Services at our office but the front end (web interface) is not functioning (long story but we disabled OWA on the same box a...more >>

I know that a number of people have posted to this newsgroup regarding the issue of unexpected page breaks occurring before subreports when printed or in PDF format. Unfortunately, after reading them I'm not sure that I can clearly see that a solution has been found. I have a case where a sub...more >>

Hello, I'm working on a Item Master report for a manufacturing company. The Item Master is a simple dump of 20,000 rows to a report. It has four parameters that filter data. The complex part is that the parameters are used like a search box. Everything should be displayed if nothing is en...more >>

Ok, I have a SQL 2005 sp2 server running reporting service on one server, and Sharepoint Portal 2007 on another server. As I have reports setup and want to continue using reports manager, I installed a second instance of Report services on my SQL server. I installed Portal server on the SQL...more >>

I have the following expression =(iif(sum(Fields!Wins1.Value) = 0, 0, sum( Fields!Wins1.Value) + iif(sum(Fields!Pending1.Value) = 0, 0, sum(Fields!Pending1.Value))) - iif(sum(Fields!Losses1.Value) = 0, 0, sum(Fields!Losses1.Value)) - iif(Sum(Fields!Pending1.Value)=0, 0, Sum(Fields!Pending1.Val...more >>

I am attempting to populate a matrix with static columns so that when results for a certain month have no data, the column still appears. I read several other posts regarding this and attempted to use an IIF statement in each column field for each month (IE: IIF(Month.value=1, fields!count.val...more >>

is it possible to group 2 or more datasets? i.e i have a row that returns count of sales, ATV etc from one view and paidout sales from another view this has to come from 2 datasets due to them having different selection criteria i am grouping by region on dataset1 but need to group by region...more >>

Does anybody know how to programmatically gain access into toolbar function?...more >>

How can I reuse a dataset in multiple reports? For example, if I create a ds to populate a parameter, this parameter may be useful for many reports and I'd like to avoid recreating the query in each report if possible. TIA Dean ...more >>

Any ideas on how I might be able to create a report with a page for each month, columns for each day, rows for each week and scheduled activities on the appropriate date? I have a db with rows for each activity and columns for various types of dates, i.e, start, review, submit, etc. TIA d...more >>

Hello: I know that you can e-mail SQL Reporting Services reports. But, can the reports be configured to refresh their data automatically and be e-mailed to users automatically with the refreshed data? Or, would someone have to go into SQL Reporting Services, manually refresh, and manual...more >>

hi, we are running a few data-driven subscriptions within our RS2005 installation, using the email delivery extension. We are trying to monitor the subscriptions but had no luck. Is there a possibility to log which report was send to whom (including used parameters)? Thanks, Max ...more >>

Hi! Is there any way to change the connecting string of a report data source programmatically at run time. Actually my problem is that I have an ASP.NET application and connection string is stored in Web.Config file. I have multiple copies of databases hosted on different SQL Server and I u...more >>

Hello - Background - We have 18 seperate servers with 6 non- SQL Server 2000/2005 databases. So, many of the boxes we have are windows based and some with SQL Server 2000 and some with SQL Server 2005 databses. My understanding is that Reporting Services and Analysis Services are server soft...more >>

Okay, I'm sure there is a way to do this. Basically what I have is a List that contains a table. The list is grouping on a value so that the table just shows some sub-details related to the grouping. What I would like to do is sort the List. Here is an example of what I have is the List grouping...more >>

I have SSRS on my PC, my coworkers can get to the Reporting Services site, but when they try to view a report they get the following error: An error has occurred during report processing. Cannot create a connection to data source 'AdventureWorks'. For more information about this error navigat...more >>

Is it possible to link expressions to report parameters for instance i have WTD, MTD and YTD sales targets in my DB and have WTD, MTD and YTD as report Parameters can i do this? If i select MTD link the Expression to say if MTD then Show MTD sales target etc etc ...more >>

I have installed the Business Intelligence Studio on my PC and had no problems creating a report, but when I go to http:\\localhost\reportserver, I just see a directory listing in the browser instead of the web interface. Where should I look to troubleshoot? TIA Dean ...more >>

I created an list in that we placed an matrix and i ma using one dataset for all of it anf grouped the list with one id called org name. Now for each org we have answers associated and its an different dataset wen i try to insert it. It provides errors. As we got grouping in it and in gro...more >>

How can I format a column so that the email address is clickable and will start up a new mail message? ...more >>

I am not sure how I can utilize the Topcount query in Reporting Services. In essence I want the Top 5 Adventure Workse source and destination currencies, ordered by the largest sales amount. Running the query below in SMS provides the answer, however, when I move (parts of) the code into a ...more >>