Hi, how can I Sort this MDX statement by City SELECT {[Measures].[Store Sales]} on Columns, {DISTINCT([Store].[Store City].members)} on Rows FROM SALES It is used in Reporting Services to fill the City-Paramter with values, in the Sample-Report MDX_Expression.rdl with DataSource Northwind...more >>

Hi, Is it possible to to have RS Enterprise and RS Standard in a web farm? If so how can I go about achieving it. Currently, we have licenses for both Enterprise and Standard versions of RS. Please help. Thanks. Jas....more >>

Can someone please let me know what the use of the Report > Report Properties > Author & Description Fields are? When I deploy my reports to the server these values are not visible in the report properties of the report manager nor are they exposed to be used in a report. Both of which I wa...more >>

i'm new to RS and have created reports with jump to url capability. the main report has drill down capability up to 4 levels. i would like to know if it is possible to open the report and have the toggleitems collapsed or expanded (showing the next level if expanded) based on pre-defined cho...more >>

Okay, I thought I almost had this security extension licked, but now I've run into this and I don't know where to begin looking. When I call LogonUser() from my UILogon.aspx, I'm getting this: System.Web.Services.Protocols.SoapException: Server was unable to process request. --> Object ref...more >>

I am going to present images that are stored in a database (SQL Server 2000) on my report. I want to have 4 pictures on each row. My table contains 20 images and hence I will have 5 rows with 4 pictures on each row. Anyone knows how to achive this?...more >>

I have two different URLs I use for Jump To URL navigation in my reports. This one adds a String report parameter on the end and works fine: =Globals!ReportServerUrl + Globals!ReportFolder + "?/Detail/Campaign+List&rs:Command=Render&rs:format=HTML4.0&rc:Toolbar=false&rc:Zoom=Whole+Page&rc:Para...more >>

I want to create a TextBox with dynamic width. Probably reading from an expression. Has anyone tried to set the width of the report objects with an expression. ...more >>

Problem Statement: Open a sub-report in a pop-up window with specific dimensions AND BE ABLE TO PASS PARAMETERS TO IT !!! Background: I know that there have been many solutions offered to open a popup sub-report. I was able to do that too. Issue: I need to pass in a parameter, which will be ...more >>

We tried installing reporting services and first got the error: "The install has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 25619. We then installed with the following switch per kb867872: setup.exe /i"Setup\Rs...more >>

I am trying to name one of my sub reports as =Globals!ReportName and it gives me an error "Report names can not be empty strings or just whitespace.". can i give a golbal report name for a sub report ? Thanks! Ashish...more >>

I am trying to figure out how to setup parameters that will allow me to have an "ALL" selection. "ALL" will include all the other choices in the dropdown in the sql. I am new to Reporting Services, so I am not sure if this is even possible, but it would seem to me that this would be a pr...more >>

We have implemented chart based Reports and they are being delivered to the report subscribers via email. When the email recipient prints email containing the reports with the various charts, none of the charts are printed. The email report contains embedded images which do not get printed eithe...more >>

Please (do not) confirm: - To have a "print" button on report in order to print a report and not the html page do I need to wait for sp2? When could the sp2 be available? ...more >>

Can i get a report to acceppt parameters not declared in report?? I have a webinterface that posts more parameters than some reports are able to process. reg. Kjell ...more >>

It is possible ? Users connect to database with report data using own Active Directory domain credentials (not ASPNET account) and users not must write login and password (login credentials must be send automatic by IE)...more >>

hi people. Can someone out these tell me how to export a report made in MS SQL Reporting Serives into LANDSCAPE. Is there anyway to set this in the report/layout properties OR is Microsoft team still figuring this out now??? When i export to PDF the default layout is POTRAIT and nothing seem...more >>

Hello, This question has been posted a few times and is DEFINITELY A SHOW STOPPER for Reporting Services. When exporting to Excel - the last row can turn up missing - Why is Microsoft not responding to this??? ...more >>

I'm not setting device info in the code (as I have seen many people use to switch it off) so the toolbar should be displayed by default. I've even tried forcing it with Dim DeviceInfo As String = "<DeviceInfo><Toolbar>True</Toolbar></DeviceInfo>" but to no avail Can anyone shed any l...more >>

Hi, This is probably a very 101 question :-) I have a query that returns customer records. These records are sorted by region and name. Now I have a requirement to highlight the top 10 customers (the 10 highest $$$ amounts), without changing the order of the customers. Is there a way to...more >>

I have made sure that anonymous logins are disabled on the reports and reportserver virtual directories. When I setup reporting services, I made sure that the use SSL connections checkbox was checked. I don't understand why its not asking for authentication. I also made sure that I didn't ha...more >>

I have a pretty simple chart which seems to work, but when I build it, I get a warning that "the expression for the chart "chart1" contains an error: operation is not valid due to the current state of the object". I've experimented with a bunch of things to get rid of the warning, unsucces...more >>

I was wondering if the reporting services has capability tp export into MS Word format. Thanks. Dipendra...more >>

Greetings. I am a newbie at reporting services, am using the developer edition of RS on Windows XP Pro and SQL Server 2000 SP3. I am running a report that returns data that I add to charts on my report. Whenever I run the report, I get the above error. There is no code, only charts, any help...more >>

We have developed a number of Reporting Services reports that each call a stored procedure to execute the query that generates the data for the report. In Query Analyzer, the query takes less than 10 seconds to execute. However, in Reporting Services it can take 2-3 minutes to see the first ...more >>

I have been tasked with creating our promotion procedures for all reports in Reporting Services. Can anyone give me any tips or point me to any references that will help me with this. Ideally I would develop the report in a dev environment against dev data. It would go through our quality assu...more >>

All, I need to alter the Header Bar background colour in my report depending on who the report is being prepared for. For example, client accounts that start **P need to have a blue background whereas client accounts that start **A need a red background. Any help on how to switch the colour...more >>

Hi - I have the reportviewer component working fine in our intranet enviroment, but am looking to move it over to an internet enviroment in a few weeks, and have a few questions about this. At the moment I embed the reportviewer control in the .aspx pages (which have forms authentication secur...more >>

I've placed a logo I'd like on my reports at the path http://<servername>/reports/images/logo.gif I've also performed the instructions as per the article "Configuring an Account for Unattended Report Process" in the RS BOL. I've also re-started IIS, several times yet I still cannot get the ...more >>

Dear sir When i try to subscribe the report, it gives error "Credentials used to run this report are not stored". thanks and regards arvind asharma@techaxes.com -- asharma...more >>