i have a simple query written in mdx: SELECT { [Measures].[Imp Vta Linea], [Measures].[Uni Vta Linea] } ON COLUMNS , NON EMPTY { ORDER( HIERARCHIZE( DISTINCT( { [Tiempos].[Semana].[Anio].&[Dos Mil Tres].&[20346], [Tiempos].[Semana].[Anio].&[Dos Mil Tres].&[20346].CHILDREN, [Tiempos].[Seman...more >>

Is there a way to insert reports with interavtive features in my custom web application? I cannot use url access provided with the SQL Reporting Services. I need to render an OLAP Report with drill down features. ...more >>

Here is a funny one: When scrolling through the dropdown box using the up and down arrow keys, the following error is received: Steps to reproduce: select an item in the dropdownbox. Change the selected item by scrolling through the dropdown box using the up and down arrow keys. error T...more >>

I need to see report using ReportViewer. Problem is when I want to see report as customer it asks for Username and Password. So I need to code in page load like Imports Microsoft.Samples.ReportingServices.ReportViewer Dim rs As ReportingService = New ReportingService rs.Credentia...more >>

Has anyone done this? I have to send out a subscription to a large group. The group membership is based on tables in our HR database. Thanks, Burt...more >>

We are using a third-party scheduler (our enterprise standard). How can we integrate MS Reporting Services and our scheduler? How do we schedule reports through this? Are there best practices, or even sample scripts? Thank you....more >>

I want to programmatically pass in some parameters, generate a report, export this report to PDF, and pop up adobe acrobat reader in a web browser in one click while naming the PDF file exactly as I like, including its path. I currently do this easily with Crystal Reports in one click, but ...more >>

I have a numeric parameter that does not get its default value when I deploy the report. It works fine in report designer preview. Is that a bug?...more >>

Repost of a question / bug I reported one month ago. I try it again since as of 10/13/2004, this is a MSDN Managed newsgroup, so I hope I'll receive an answer from an MS employee. I want to set report parameters to the first day of the previous month. In order to do so, I calculate a parame...more >>

I have a report that requires a barcode. I'm using a wasp128 barcode. The barcode works fine except when I export it to a pdf. It shows the barcode only it is spread out like somebody has slipped some spaces every couple of lines. Export to a image works fine and is scanable. Any thoughts? --- P...more >>

This question has been asked numerous times, but I'm still stumped. I have done several research and some people say it's impossible, while others say it can be done. One I heard is the dataset extension. I'm still a little confuse how this work since I'm quite new to working with Reports, ...more >>

Hello, I try to use reports parameters of the DateTime type. But whereas the query filling the parameter drop-down box only retrieves pure dates without any time information, the entries in the box are appended by "00:00:00". Microsoft says, the DateTime type obeys the ISO standard, but "...more >>

Hi All, Is there a script(.rss file) that can move a .rdl file to a different folder than the one in which it is in. eg. Assume File is on The "Reports" folder in the Report Server. Now I wish to move it into the "Reports\Vehicles" folder. Is there a script that can facilitate this rathe...more >>

hello, i have a question about using web service as datasource in reporting services i have a web service which returns dataset now what should i do, how do i attach this one to report i saw couple of examples(on data extension ) but i really dint understand how to attach web service to this.i...more >>

I am trying to install an instance of Reporting Services on an Windows XP Pro workstation with SP2. This instance will share a Reporting Services Database with an existing Reporting Server installation. I am using the web farm configuration. I am getting the following error towards the end o...more >>

hello guys, i have tried this example "http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql2k/html/RSDSetEx3.asp" but the problem is i am not able to see data extension in drop down list does any one know what the problem is. Thanks ...more >>

I'm creating a form which will enter all the information from the database onto the form when the user enters a paramter. The problem is that I can't get it to display more than one form. Let say that the user wants all information from a certain company on the form such as employees. T...more >>

I want to use cascading parameters for my report. Are there example for cascading parameters? ...more >>

Hi, I have a reporting services installed on my server that has saved reports with snapshots. I want to move these on to laptop so they can be showed while laptop is disconnected from network. I tried to backup (on server) and restore (on laptop) ReportServer and ReportServerTempDB database...more >>

I would like to do some pretty strait-forwared preprocessing of a result set returned by the shipped Oracle DPE like add a column for calculated values and insert some additional rows. Specifically, I want to preprocess the rows returned from a query that may have say 80 rows, returning only ...more >>

I have succefully connected via VB.NET to the reporting service and executed the UpdateReportExecutionSnapshot(strResult) method to update the snapshot of reports. But when the report generation takes long it reports me the following error: An unhandled exception of type 'System.Net.WebExcep...more >>

Hi, I am trying to open Reposrt Services , I get the following error. 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\'. The directory does not exist or is not accessible because of security settings.] I do not know what went wrong. Could any one please ...more >>

I have a question about how to use a stored procedure with parameters to dynamically pull data for a report. When I use a dataset and a stored procedure, I get prompted to fill the parameters. It works great. But I need to fill this dataset dynamically. Problem is when I preview the report,...more >>

We have been receiving these errors and are not sure why. The Reporting Server has RS SP1 and the latest SQL Server service pack (SP3a). The webiste is serving up reports with no problem. Thanks. Event Type: Error Event Source: Schedule and Delivery Processor Event Category: Startup/Shut...more >>

I want to add a print button on the report viewer toolbar. Is this possible? How? ...more >>

I have a Report with many Parameters and a Users with resolution <x can't not see the Results. Is there a work around for it?...more >>

I have several clients using several SQL server databases that have all been setup on one machine which they access remotely using terminal services. Each client has their own software installation with their own set of databases. So, there would be many client installations on the same machin...more >>

Hi, I integrated with ReportingServices using Forms Authentication followed the instruction of the article from microsoft, it works fine on my laptop (Windows 2003 server and sql2000), but when I try to duplicate it on our company server (windows 2000 and sql2000), I always got the error: Au...more >>

I have succefully connected via VB.NET to the reporting service and executed the UpdateReportExecutionSnapshot(strResult) method to update the snapshot of reports. But when the report generation takes long it reports me the following error: An unhandled exception of type 'System.Net.WebExcep...more >>

Let's say I have 10 reports in a project where each report requires a "drop down list" type of filter. We'll call this filter (report parameter) "Product Type" and is a populated from a stored proc. In order to put this Product type parameter on each report, do I need to define the dataset whi...more >>

Hi all, My report consists of a matrix and displays results from a stored procedure. One of the groups is called country. The matrix displays countries with all the products in that country. By default, all the countries are shown, but I want to be able to filter by country from a parame...more >>

hi all, it could be possible to do something like sum(other aggregation functions)? i mean to have nested aggregation functions. thank you...more >>

Is it possible (using SQL Server Reporting Services) to load a 'TextBox' component with the contents of a RichText file (i.e. from a saved file 'testRpt.rtf') ? Any suggestions would be appreciated. Thanks in advance .... Steve...more >>