Hi, I am trying to login to Report Manager (MSSQL 2005) on my server https://www.[mydomain].com/Reports with administrator user & Pass but login failed with error: "The request failed with HTTP status 401: Unauthorized." Any help will be much appreciated. Regards, Asaf ...more >>

i created a report and put a textbox and other element, set cangrow to true, than i preview the report and display in one page, the textbox height grow to the end of page, after i client the print preview, the textbox move to second page, if i export to pdf or tiff file, the textbox also displ...more >>

Hi, I've been looking high and low for a way to turn the elements of a field into hyperlinks and so far I've found nothing. One of the fields in my report holds all the document hyperlinks pertaining to that particular record. For example, if the record is about employee A, I have a field...more >>

What are the differences beetwen AS and RM? Kamel ...more >>

Hi all – Having a problem with SQL 2005 Reporting Services and Multi-Select parameters. It’s seems as though Multi-Select and Allow Nulls are mutually exclusive. This is a problem as we have some reports that are very complex – using very complex stored procedures that allow for this...more >>

I am linking to photographs/pictures of employees. Some employees have a picture.gif file while others do not have a physical file present (i.e. John Doe has not "jdoe.gif" in the file share) depending on whether their picture has been taken or not. Can I detect the presence/abscence of this...more >>

I am trying to create a report model on some tables that do not have a primary key. The wizard keeps failing with the message "Table does not have a primary key". Is a primary key mandatory?...more >>

I am working on a POC (proof of concept) for reporting services. My question is can RS be depoyed using the following architecture. Web Server. App Server. DB Server. The web server can only see the app server, and the app server can see both the web and db server. Would like the actua...more >>

We are using SQL Reporting Services 2000. We need the reports to be able to access a session variable or the request object's server variables. How can we do this?...more >>

We have written some RS 2005 reports on a development server which now needs to have SQL Server 2005 re-installed due to 'Database Services' not installing successfully with SP1. Some of the 2005 reports are currently in use and I wanted to install them on a RS 2000 report manager on another ...more >>

When attempting to deploy a report, the report builds fine but I get the following error or deployment. The report definition is not valid. Details: Could not find schema information for the http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report' Any help wou...more >>

In my laptop, I got W2003 server Std, Sharepoint portal, SQL 2000 and SQL 2005. After I have trouble to run the Http://server/Reports. I applied SP1, then I under install the SQL2005, but failed to remove the Reporting Services. Then I re-install the SQL 2005 with a new instance name, then app...more >>

I might be in left field here, especially since I believe reporting services is entirely a server side report generation engine, but.... I would like to generate (not just view something from regular srs -- I want to produce something from my local SQL Mobile right on the mobile device, whi...more >>

hi all, i have a parameter ParamA that refers to another parameter ParamB. select ParamA from property where chain like (@ParamB+'%') i set ParamB to allow blank value. how do i enable ParamA if ParamB is blank? cos currently, ParamA will be disabled for selection if @ParamB is not spec...more >>

Hi, I have installed VS.NET Pro 2005 & SQL Server 2005 Developer Edition with full install. From some reason I don't see the "SQL Server Business Intelligence Development Studio" on my machine so I can't create reports. Any help will be much appreciated. Regards, Asaf ...more >>

I have a report with four paramters. A "Start Year" and "End Year" that are strings with values from a query, so available valuse are 2003,2004. 2005, and 2006. Two datetime for a "Start Transaction Date" and "End Transaction Date". When I set the "Start Year" parameter, the report seems to...more >>

Hi, I am trying to create invoices where first page should have ~3.75in footer with remittance slip. All other pages should have small footer. Body of the report is one big table with groups. What is the [best] way to accomplish this? Footer size could not be formula-based (at least tho...more >>

Hi, Can I trigger an email subscription by using command lines or url command? Thanks, Max ...more >>

I am building a reporting aspect of my .NET web app, and I have already come accross the problem where if the app is hosted on a server and the backend SQL database is hosted on another server, I cannot use integreated security to retrieve data from the sql server (unless deligation is turned ...more >>

We are implementing the SSRS 2005 custom security extension described in http://msdn2.microsoft.com/en-us/library/ms160724.aspx. We have the sample running, but the LogonUser method never seems to be called. Shouldn’t this routine be called as a result of the user logging into Logon.aspx o...more >>

Hi, How can I add multiple values in non-queried "value" box. I have a parameter name "Country". I have a label USA which has three values. Label Value USA 555,666,777 The above example doesn't work with my stored procedure which has where clause as ...more >>

I'm trying to deploy my reports to my production server and I'm getting 'rsAccessDenied:The permissions granted to user 'domain\me' are insufficient for performing this operation' I asked my dba to give me full permissions on the reportServer and ReportServerTempDB databases in production AND...more >>

Hi i have the following iff statement. =iff(Fields!Measures_MeasuresLevel.Value=cost,Sum( Fields!Financial_Year_All_Financial_Year_FY01_02.Value),0) I get an error "Name iff is not declared" What do i have to do in order to get iif statements to work? Ta Paul ...more >>

With a report is created against a cube, the data designer generates the mdx. If a field is checked as a parameter, the mdx will include something like this: SELECT ( STRTOSET(@ProductDimCatgLabel, CONSTRAINED) As a default when the report is run, a dropdown presents all possible values. Be...more >>

I have several Reports that when I Click on the "View Report" button I receive a 405 Resource Not Allowed Error. I have re-installed Report Server and updated to Service pack 2 for Reporting services, with no change in the outcome. The Initial load of each of these reports works fine, howe...more >>

Hi, I have a stored procedure, that can't be modified. It return data like these (the real one is more, and more complex of course) A .... A .... A .... B .... B .... B .... C .... C .... I want to make a table with only theses entries : A B C How can i do it in reporting s...more >>

hai, i want to display date 14/02/2004 is in the format of FEB 06. how can i format the date to get this result please tell me the ways ,any one worked one this. thanks & regards, mur. -- mur Message posted via http://www.sqlmonster.com...more >>

We are using Reporting Services 2000. We have several reports that all contain an "Edit" hyperlink that goes to a URL not related to the report server url. We cannot directly enter this URL into the "Jump To" section, because the url is different depending on the environment (dev, test, pr...more >>

I have a report that I will use a DateCreated value for the date and time parameters. The time stamp for the DateCreated value does carry dates and times. This report is for three 12 hour shifts and the hours run from 7:00 PM to 7:00 AM. I need to set my default parameters to display as yester...more >>

If you cannot find the current Visual Studio sln project file, can you obtain the report design from the Report Manger to plug back into the designer to ensure that you start from the most current report verision held on the server? Thanks Ian...more >>

I've got an ASP.NET 1.1 application running on http://www.webapplication.com and a report suite hosted by SQL RS 2000 on http://www.reportserver.com. Webapplication.com uses URL access to the report server to make use of the HTML report viewer toolbar rendering reports inside of a IFrame usin...more >>

I have a matrix of data for a period of months. What I am trying to do is to add a column at the end which will be YOY change. So how in a matrix do I reference the value in column 4 (for example) and the last column. Also how do I add this calculated column to the end of the matrix. ...more >>

Hi, have had a look at the archives and there is some good info there about having different formatting for subtotals as compared to the actual data columns. What I want to do though, is have the same formatting applied to the subtotals as to the data columns. I have 9 data columns which...more >>

Hi, I have a report containing some values. Surprise? :) I want to delete rows containing values 0 and null from the report. I need to include those rows to the sql query, but don't wan't them to be seen in that particular table. Can the dynamic deletion of a row be done? Thanks for helping...more >>

I am pulling down reports using the reporting services web services, and for various reasons I am not using the report viewer. So I am rendering them in EMF format and previewing them in the print preview control. However, whenever I preview them or print them directly, the PrintPage event of ...more >>

I'm having problems with Windows Authentication in RS 2000. This is on a brand new server. Here is the setup I've done. -Install Win2003 SP1 (install all updates to be current) -Install IIS (with ASP.NET and FrontPage extensions) -Install VS.NET 2003 -Install SQL 2000 (with SP4) -Install ...more >>

A single server running side by side SQL instances. SQL 2000 as default instance and SQL 2005 as named instance. Designed a report using 2005 Reporting Services to query data from SQL 2000 Database. Report by itself works fine the problem is with performance. Report has multiple parameters...more >>

Does anyone know a way to set a report to print out to Landscape by default? I do not see an option anywhere for this setting within Visual Studio 2005 when creating the report....more >>

> Hello, > > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003 > Standard, but appers error message no log file rsstp.log > > InstallBootstrapPackage' Return='2' GetLastError='183 > > anyone can help me? > Clayton Cardozo. ...more >>

I am using this below query which is with a Union all. The database I am trying to connect is Oracle. Once I go to preview I get an ORA error which mentions thatt the query is not properly terminated. Is there a way to create a Union all in a paraemeterized dataset with connection to Oracle. ...more >>

I'm having trouble with a few subscriptions getting emailed. They are showing "email sent" in their status. I remember a while ago, finding a post about a log file I can read that showed transactions and their error or success messages, but I can't find it now. I didn't have to look in the ...more >>

I have one report with two dataset (one from a table and one from a Cube). Within my report are two tables, one uses the ‘Table’ dataset and one uses the ‘Cube’ dataset. The two dataset are similar (i.e. they return similar data/fields). I would like to compare some of the fields fr...more >>

Hi everybody, I have this "minor" problem... This is the situation: a list of orders is shown I scroll downwards in my page to look for a certain order I click on the order to see the order details (jump to the detail report) use the back button to go back to the list of orders (previous ...more >>

I have a sub report that is only showing part of the time. I have run the report with following scenerios: peramter "status" = "active" , and perameter "session" = 1 and it runs corectly peramter "status" = "inactive" , and perameter "session" = 1 and it runs corectly peramter "status" =...more >>

I'm fairly new to SSRS, having switched over from Crystal recently. I've created a report, which is working fine in the designer and the debugger. The problem is that when try to deploy the report to the reportserver (localhost/reportserver), I receive an error described here: "A connecti...more >>

I'm transerring a Reporting Services db from server 1 tot server 2 in a different domain. To do this I followed these steps: - Create back-ups from ReportingServicesProductie and ReportingServicesProductieTempDB - Create encryption key on the Reporting Services machine - Restored the backups -...more >>

Hello all - Our users are getting the above error when trying to execute a report. Permission has been granted to the security group that they belong to, for the report folder and report (browser permissions), as well as the Analytical Services database and the associated data warehouse data...more >>

I need to format a text in a text box to show a text field truncated. In other terms, I must show only 40 characters of a very long string. Do I use the statement "format"? How can I solve this issue? Many thanks...more >>

I installed SQL Developer Edition on W2003 STD, plus sharepoint portal server 2003. after the installation, I try to acces http://localhost/Reports, failed. How can I setup the reporting services web access with sharpoint portal server on the same machines? Is there any web parts for Re...more >>

Hi All, We need to email RS reports to various sales persons within a branch. Sales persons are only allowed to see their own report. Therefor a report will be executed for the amount of sales persons, passing thru the salesperson's ID as a parameter. We do not want to schedule a report fo...more >>