What is the best approach to displaying a REAL datatype value with RS? When I query them in QA, they are returned correctly... such as 0.15 or 0.5. When I display them in a RS report they often come out as 0.15000000034. I know this is because they are approximate floating point values, but I ne...more >>

Is there a way to deploy reports through a script or scheduled task? Thanks Rob...more >>

Does anyone know if user has the capability to join two entities with additional field which is not a predefined primary key or foreign key at the design time? User want to run the report by join tables with certain fields on the fly. I have not found a way to allow them to do that unless they...more >>

Hi all, I'm trying to figure out how to add static columns to a matrix report in reporting services 2005. i have a matrix where the columns can be dynamic (1 to n columns) and in addition to the row columns on the far left i also need to place columns on the right as well. So it would look lik...more >>

When I run an RS report on server1 that connects to a sql database on server2 I get the error: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. " Suggestions?...more >>

I noticed on a report that there was a Calendar next to the Parameter @ClearDate If you use the calendar it will enter the date into @ClearDate. I am trying to add a calendar to my reports but I cant find any information on how to do it. Can someone point me in the right direction? Sco...more >>

When I run an RS report on server1 that connects to a sql database on server2 I get the error: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. " Suggestions?...more >>

Hello, Thanks for reviewing my question. It is my first creating a report in SQL and when I deployed my simple Report project I received the following exception: Error : Exception of type 'Microsoft.ReportingServices.RsProxy.AccessDeniedException' was thrown. I have SQL 2005 loade...more >>

Is there a size limit when printing a MSRS report. I have a 17,000 page report that is viewable, but will not print? ...more >>

I am so lost..... Ok, I need to install reporting services so we can use build reports with sharepoint. Our server model looks like. Server 1 - Sharepoint Server 2 - Sharepoint Database Where do I need to install reporting services.. on server 1 or server 2?. Then, I am going to install...more >>

Is there a way to have hyperlinks in the data be removed when exporting (to excel or other formats), so that they are not available once exported? ...more >>

How can I create dynamic page breaks based on a number of records I only want to be displayed per page?...more >>

Hi, I want to set a parameter to use the first and last days of the month for two parameters' defaults. I then want to set the first day of the previous two months as the "available values" for on of the parameters and the last day of the previous two months for the other parameter's "avai...more >>

Is it possible to have SQL Express and Reporting Services on XP Home and use reports locally (like Access)? Thx ...more >>

HI, Objective: On the last page of an invoice at the bottom of the last page have a stub of the invoice: that section has: Company Logo Company Address Invoice number INvoice date Sub total PSP tax and Amount due Issue: Reporting Services does not support Report Footer only Page F...more >>

I'm building a client application that uses the SSRS Web Service. My problem is that when I use the servername the web service works just fine. ie http://RServer/ReportServer/reportservice.asmx If I try to use the full DNS name of the server any call I make to the web service returns a 404...more >>

I have the following expression in page header: =Iif(Code.GetGroupPageNumber(ReportItems!Textbox4.Value,Globals!PageNumber)<>1,CStr(Code.GetGroupPageNumber(ReportItems!Textbox4.Value,Globals!PageNumber)),"") this causes error The Value expression for the textbox ‘Textbox2’ refers to more ...more >>

I have installed Visual Studio 2005 on a client system so that I may create reports from Report Server (2000) on the SQL 2000 Server. When I try to install the Report Designer for Reporting Services on the client it does not offer me the option to install Report Designer. It states "visual studi...more >>

I am running SQL Server 2005 Reporting Services. I have a report that runs with an Access database as the data source. Occasionally the report will hang at the "Report is being generated" screen. The screen never times out even if left for hours. Once one job fails any other attempts to ru...more >>

I'm going to try and explain this as best as I can :) I have calculated fields that has the following expressions - I've named each textbox hoping that I could grab them in the expression but I have no idea how??: 1. totalMarket: =iif(sum(Fields!Wins.Value) = 0, 0, sum( Fields! Wins.Value) ...more >>

I have a matrix that shows figures by year, broken down by months (1-12). When the query runs and that particular month has not values, the column is not displayed. I previously came across something regarding the use of a function to force the columns to appear but can't seem to find it again...more >>

Why are there two newsgroups/forums on MSDN and why don't they contain the same data. Here is the other one http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1 This has a better UI ...more >>

I added this expression to the Text Box on the Report and it returns the Nothing Value, yet the value does exist. =Iif(Fields!USCATVLS_1.Value = "External",(Fields!Billing_Amount.Value*Fields!BNFITAMT_5.Value/100),Nothing ) If I add: =(Fields!USCATVLS_1.Value) the Value "External" return...more >>

In SSRS 2005, I have created a graph with x and y axis. On the graph there are several lines based on the sql query. The question is, how is it possible to place the last value in (y axis) on the last point of the graph line. Thanks...more >>

New to RS. I have a report with 3 parameters, Date Range, From Date, Thru Date. Date Range is populated with these values: 0 Custom 1 Yesterday 2 Today 3 Current Week 4 Prior Week 5 Current Month 6 Prior Month 7 Current Quarter 8 Prior Quarter 9 Current Year 10 Prior Year and i...more >>

I have a parameter on a report that has multiple values. I would like to = have a textbox that displays the selected options, but can't seem to = find a good way to do it. I tried using... =3D"Strategy =3D " & Parameters!Strategy.Value(0) & ", " & = Parameters!Strategy.Value(1) Which works ...more >>

I have web-based reports using SQL server 2005 with filters called location and suppliers and the number of locations and suppliers are more than 200 each. When the report is rendered with this filters, selection of locations and suppliers is taking long time on the browsers and it is not easy ...more >>

I'm trying to setup a query with a WHERE clausing containing LIKE and the LIKE contains a Report Parameters The parameter (:urlPath - using ':' as this is an Oracle database) takes values such as "/us" or "/uk/products" and I search a field caled "url" for records where the beginning of the "u...more >>

Does anybody know a free tool to convert Crystal Reports to Reporting Services ? Thanks ins advance, Tito. ...more >>

In .NET when I call a stored proc that returns two sets of data, each set is put into a datatable within the dataset. I have an SRS report that is calling a stored proc that does the same thing. However, SRS doesn't show me that second data table so I can get access to it's columns. Is there...more >>

I have quite a few reports on my server. After upgrading to RS 2005 all of them work fine except one. This error appears on the Web Interface when opening any new snapshots (Created after RS 2005 upgrade): An internal error occurred on the report server. See the error log for more details....more >>

I am trying to create a master detail/report using Data Regions rather than Sub-reports. At the master level I was to display customer data. At the detail level I want to display sales transactions for each customer (for various reasons it is not convenient to extract all data in one SQL qu...more >>

A stored procedure is causing a hangup in visual studio. When running it from the query analyzer it will give the whole resultset within 10 seconds. When running it from visual studio it causes a hangup. I was thinking this to be a total client-server solution. I'm using some derived tables w...more >>

Hi, I'm in the process of designing a report and am having a few problems with the layout. What I need is a header on all pages but footer on only the first page. I managed to accomplish this by hiding all the textboxes on the footer if the current page global variable <> 1. The problem is th...more >>

It could be strange, but i would like to know what is the best way to allow to all the employee to have access to my reports. I don't know why but, some people can access to the reports. What should I do or stop ? Thanks !...more >>

I try to configure RS to export report as csv with fields delimited by tab. I can set it to be any value (eg. semicolon) but can not do that with tab. Is it possible? ...more >>

I have a problem with SQL Reporting service. My stored procedures and configuration settings are correct which I can query database records without any problem. In web reporting, I have a few report parameters including one field is user default constant value. The constant value is "Generator" ...more >>

Our customer want to use a different language type of his Regional option. So the datetime type at the Parameter Bar of reporting service could no show as stander code. (For example short date of his Regional is 2000.1.1 but he want to show as 1.1.2000 when he click the calendor @Para...more >>

In my current job, I've inherited a website and some ReportViewer reports, and I've figured out how to poke around and make some changes requested by my employer, but there's still a lot that I don't understand. Any input would be appreciated. Here's the current problem: the reports that we ma...more >>

I have Windows 2003 with Sharepoint Server 2007 installed, but my Report Server is broken. I am unable to start Reporting Services. When attempting initialization I get an error message Details: The RPC server is not listening (Exception from HRESULT:0x800706B3). Any suggestions will be appr...more >>

I have two datasets. I have a list with multiple tables in it to break out information. There are two tables that I need to populate. They are using dataset 2. THe rest of the tables are using dataset1. How do I link the data that is pulled in dataset 1, to dataset 2? Both dataset...more >>

Is there a self-reference variable so I don't have to refer to a cell by it's name? I'd like to do a "iif( self.value = nothing, "Silver","Transparent" )" so I can do it on the whole table. -- "Everyone knows something you don't know"...more >>

I'm working on a report that displays parent table records along with records from several associated child tables. I created the primary report to display the parent table data, and to use subreports to display the child table data. All but one of the subreports render as expected. The prob...more >>

Hello, I have a report in an .aspx page. When the user expands the row the records display correctly except when there are a ton of records (1500 or more). Does anyone know a way to display the records in another page when the user expands a row? Thanks, John...more >>

In Reporting Services I have following query. For some reason query only picks the FIRST choice for State or Product … even though user selects multiple products or states … what is the issue here? Could you please help me? Thank you. SELECT DATENAME(MONTH, dbo.fnGetDSDate(ts_t...more >>

I have a requirement for two reports, which are basically except that one shows values, whereas the other shows percentages. I would like to code this as one report that modifies its display behaviour based on a parameter that is passed in ( value 'P' or 'V'). The format of the cells in the...more >>

Hi, Is there any way to copy functions from one textbox to another with auto fill? There are cases which the programmer spends enormous time over formulas just to change textbox names into the same formulas. ...more >>

Is there a way to fully expand (or vice versa) a report with groupings and hidden levels? (Something like the Excel’s subtotal groupings functionalities would be ideal). The picture below displays exactly the two controllers we require… (normal and level expand)...more >>

Hi, I need to develop several reports in RS 2005 where the report parameters are dates. The reports are based on a SQL Server 2005 Analysis Services Cube and consequently the reports need to be based on MDX. My dates are formatted according to Swedish date standard. I would like the users to ...more >>

The subtotal in my matrix is working correctly in all cases except 2 (grr!): - the total of the subtotals (this is some kind of random number) - the grouping called 'unassigned' (secretly mapped from NULL to 'Unassigned' in the stored proc) this is 'missing' some of the data How is that i...more >>

I have a number of reports that use one of two shared data sources. All of these reports used to work/run fine in both BIDS and on the server after deployment. However, recently I cannot run any of them from the reportserver - but they still all work fine in BIDS. One datasoure is a SQL2005...more >>

As I am trying to avoid the file save as/open when a user gets a pdf report from sql rs 2005 i thought i would try using the web service option and streaming to the browser. One one pc ie7 it works fine. On another pc ie6 xp sp2 i get the error message 'file does not begin with %pdf'. Both ...more >>

Hi, We are having a problem with accessing our report server via the server name. If I use the address http://<servername>/reports I get the error "HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials. Internet Information Services (IIS)". However if I use the ip add...more >>

I am using reporting services 2000 and would like to know if there is a way of programatically setting the x-axis minimum and maximum values. The Minimum and Maximum Scale X axis textboxes do not have an "fx" next to them, so I cannot set an expression for them. Can it be done at all? ...more >>

How do I create a dynamic SQL DataSet? For Example: 'Select * From MyTable Where MyField In (' + @S + ')' (I'm using Oracle as a Database, and thus the variable is :S instead of @S) ...more >>

Hi All, I have successfully configured the Reporting Services with Sharepoint Integration Mode and everything seems working fine until I try to extend existing web application. I have created alternate mapping using port 80 to existing site (use port 88). When I access reports through port 80, ...more >>

I am using sql 2005 SRS and using pdf reports. The question is how can i force the pdf to just open? Currently, the user selects the report, a dialog opens with save or open. After selecting open Adobe Reader opens with the report, then they have to select print which opens another prin...more >>

Hi, I created a report to display in invoice when passed an invoice number. How can I display multiple invoices when i pass either a date range? I am not sure how to get multiple invoices, one after the other on different page. Thanks...more >>

I have 3 lists each containing a sub report. I have placed these 3 lists one above the other. After generating the report, I need to look at only one list item at a time.When looking at one other 2 should get hidden. How can I switch between these lists without regenerating the report?...more >>

All - I am new to reporting services and its functionality and capabilites. I've been directed to see if there is a way to use reporting services to report on SQL Performance. Saying 'a way to use' means is there a pre-defined reporting template or ways to develop these reports?...more >>

I want to be able show the numbers on chart incrementally. For example, where if i have the values as 2, 5, 8 on chart, I would like to show as 2, 7, and 15 .. and so on… can you help me with this please? This is my formula for the chart … =Sum(Fields!NumberOfCrs.Value) Thank y...more >>

I'm looking to implement disaster recovery on my Reporting Services installation. I've already gone ahead adn backed up our encryption keys. I've also set up a backup job for the ReportServer databases. Does anyone have a list of the config files and/or IIS files that should also be backed ...more >>

Is there any way to find out what the data souce connection string is at runtime? I have a report that is sent out to various sites, each with a common data schema, but various connection strings. The report uses custom code in the report rdl, so each time I deploy the report to a new si...more >>

I have a main report and a subreport. The main report has a parameter of customer, that works fine. The subreport contains detail data. I want to link the subreport to the main report. The field that they have in common are ReportID. The user will not use this parameter, but that will be the joi...more >>

When using the subscription to send a report via e-mail (in excel format). This works. Is there anyway a password can be set to this file ...more >>

I have two reports, report one has parameter where user have the option to select multivalue from a parameter dropdown. This value is then used in a simple SQL state with "SELECT * FROM A WHERE A.VALUE IN @SEGMENT" which is working fine SSRS 2005. I have sencond report where I would like to sh...more >>

I have put a Non-Queried Default Value parameter in a report and got an error, 'Fields cannot be used in report parameter expressions.' The expression I'm using: =IIf(Fields!NTFrequency.Value = "Quarterly",IIf((DatePart("m", Now)=1), 9, month(now)-3, IIf((DatePart("m", Now)=1), 12,month(no...more >>

Is it possible to use an iif statement to set the height of an image control. I have tried something like this, but it did not work: iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes around the 1.5in and .5in, but that didn't work either. Thanks, ...more >>

Is it possible to protect a report we create with the reporting services in SQL Server 2005 so that end user will not be able to change and/or see the definition of the report itself? Mind you, the end user will have the admin privileges on their SQL server. Thanks in advance. GAZ ...more >>

Is there a way to draw a rectangle that has rounded corners? Thanks. ...more >>