I am pretty impressed with the export format, it looks just like the HTML/PDF. I have a simple report, it has a list and below it a table. There are two data sets, the one for the list always returns one record, and the other for the table returns a bunch (currently three). The problem is with ...more >>

Microsoft® SQL Server™ Reporting Services provides a single entry point to the full functionality of the report server: the Reporting Services Web service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the re...more >>

Does anybody know how to create a filter expression where the row is NOT BottomN 1? Cheers...more >>

Hi, Export to PDF of the sample Reporting Services Report, with Euro sign is ok for the chart but for the table it is cripted. Any idea if this is caused by the euro sign ? Marco...more >>

What is the equivalent for Crystal Report Global Variables in Report Services? -- -Kevin...more >>

is there a way to set blank values in a Matrix so it defaults to 0, so it won't appear blank? ...more >>

I have some reports(.rdl) files in a solution. It is on MyServer1. And I can see using Internet Explorer; entering Location as http://MyServer1/Reports Is there a way I can deploy it to other Computer MyServer2 in particular location and then run using http://MyServer2/Reports Any suggest...more >>

Anyone come across this one: I have a report that has to print out its figures in Euros or Dollars - I pass in the locale code as a parameter (DE-DE or EN-US) respectively and change the language of the report to one of those values via an expression. The report runs, looks fine on any PC ov...more >>

i'm having trouble accessing oracle data (gee... what a shock) i get the very *helpful* error message: "MinimumCapacity must be non-negative". no idea what it means. i'm running a sql statement which calls a stored proc. it runs fine, gets the data fine (i can't use the wizard because of the a...more >>

I need to pass a parameter to determine the visibility of a remark. If the parameter defines it to be visible, I also need to toggle the visibility of the remark when the user expands or collapses the containing group. I do not want the visibility turned on when the parameter wants it always i...more >>

Hi all, I'm new to Reporting Sevices, and we're currently in the early stages of designing a Data Warehouse / Data Mart. Initially, the DW will only be used as a data source for reports developed with Reporting Services. My question is twofold: first, is it possible to use Analysis Service...more >>

I've tried the suggestions in the article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q297989 I've made sure dts is running. SQL server 2000 windows 2000 server non domain controller AD domain. <Func Name='Do_rsManagerShortcut'> <EndFunc Name='Do_rsManagerShortcut' Return='0'...more >>

Am also having a problem exporting to PDF since installing SP1. Error is "Cannot download format=PDF from <server>" "Internet Explorer was not able to open this Internet Site. The requested site is either unavailable or cannot be found. Please try again later". Mick ...more >>

Report Manager refuses to schedule reports that uses data sources flagged as "Credentials are not required". (I am using a custoim data source where, in fact, credentials are not required.) When I try to create a new subscription, Report Manager complains that the credentials are not stored. D...more >>

Will this be supported in a future release of Report Services? I like what I have to work with so far, but this would really be helpful. Presently I'm having to rewrite existing stored procedures to break them apart. I need all the data they return but can't get to it with report services....more >>

What is a good, general, way for my Adapter implementation to find the RS Log directory (for example, C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles)? I would like to add my own log files there. Thanks, -Steve ...more >>

I'm having a heck of a time getting this set up. Neither e-mail or fileserver subscriptions are working. Windows 2003 Server, 2000 SQL Server, RS Developer. Running service as NT Authority\NetworkService. Connecting to SQL via SQL Authentication credentials which are stored in report server. ...more >>

The matrix in my report expands left to right and displaces the other tables/charts in my report. I've left enough room for it to expand. Is there a way to tell it not to push the other stuff? ...more >>

1. I have a chart based on a dataset with three columns Date, Number, Number 2. I want to put a one-line summary record in a table below the chart showing the values for the maximum date in the recordset. 3. Is there a way to do this from the existing chart dataset? I tried using a fi...more >>

I am getting a conversion error from System.String to System.GUID when I try to pass a GUID into a stored procedure from the report designer 'Define Query Parameters' dialog. I have tried the following: 5C790FBB-959A-46C6-804B-AC2F889D5141 '5C790FBB-959A-46C6-804B-AC2F889D5141' {5C790FBB-959A-...more >>

I have the following setup - Database Server having (Report Server Database + Application Database) Hardware Config - 4 CPU 1.6 ghz, 8 GB RAM, About 15 GB RAID x5 drive (75 gb disk space) Software - Windows 2K Advance Server SP4, SQL 2000 sp3 IIS Server ( Report Server, Application Websi...more >>

My dates in the charts seem to be in mm.dd.yyyy I would like them in dd.mm.yyyy . All my dates in the report are right just the charts. What could be causing this? I have used the "d" format in the chart. This is in preview mode and posted on the web...more >>

How do you total a column in a matrix? It seems like it should be simple, but I am not getting anywhere. - Here is some of my matrix as seen in Layout view. The Total column shown was created when I added a subtotal to the group Fields!MonthName.Value. =Fields!MonthName...more >>

Hi, When I export to Excel and Print Preview I get page numbers like 1 of 1 even though there are 2 pages.In both pages I get 1 of 1. What should to do to correct it. I don't have this problem with pdf. Thanx...more >>

Hi All We are getting the following error when trying to export the report to PDF. It works fine if the language is set to "en-au" but if we change the language to "no" - norwegian for e.g. it dosent work. Further investigation found that any language without "-" in the middle dosent work and ...more >>

Still got this serious issue with the pds export after installing service pack 1. I can't export any report to pdf. Always an exception is thrown that reads "Index and length must refer to a location within the string. Parameter name: length" . I've never had these problems before installing the...more >>

Is there a link that has good documentation on how to create tables? Like I'm trying to put one value in a cell like: =IIF( Fields!PERIOD.Value="Total", Fields!NET_SUBS.Value, Nothing) but it will create additional rows, because there are multiple periods. ...more >>

Installed SP1, still finding not possible to hide a parameter. Can someone provide the process please. The parameter is an ID that is send via URL to the report server. I created a Report Parameter for it, then created a queary parameter setting that to the incoming value of the Report Parameter. He...more >>

I have a report parameter: Customers That parameter is used in main data set to pull data for the specified customer. In the report header I’d like to show that customer’s name. But because parameter has a customer code and not a name I dont know the name of the customer that a user selects....more >>

When previewing a report (not previewing), the display doesn't seem to honor any page margins. Since it does honor page widths, however, I wind up with more white space to the right of my report "page". Print preview, however, puts the margins in correctly. This is a minor formatting annoyance...more >>

Anyway to show a textbox indicating no rows found in the report directly? The countrows() and rownumber() only work within a data region, which don't display when there are no rows and the globals!totalpages is at minimum a 1 so I couldn't figure out a way to do this with these functions. Anyo...more >>

I apologize in advance if this has been referenced somewhere else.... I need to plot a percent value as a secondary Y axis, with a volume (thousands) as the Primary Y Axis. How do I do that in the report designer? ...more >>

We are evaluating SQL RS and require the following functionality in order to adopt SQL RS as an enterprise reporting platform. We need to supress emails of reports if the report does not contain any rows. Can you please advice if this is straight-forward as we have over 150 jobs/reports runnin...more >>

seemingly simple question... if i have a folder hierarchy, how can i publish to different folders within the same vsnet project? and if i cannot, that means that i have to recreate shared datasources for each folder? so if i have: home - finance - customer support i'd like to...more >>

When I run my stored proceedure in query analyzer and copy the text to the pane in the report designer, all is well, but if I run the same stored proceedure as a stored procedure in the report designer it doesn't return all the fields that it does as text. What's the difference? What do I do to fix ...more >>

Is it possible in reporting services to do the following: I have a tabular report with months going across, and sales person going down, the data shows the total sales value for each salesperson for each month.. this I can do and is easy :-) The tricky part that I have not worked out is this...more >>

I have a textbox on a report that has the advanced navigation jump to report property set to another report three properties are passed to the "jump to report". There is one dataset on the original report that is using a report datasource with a specific username and password that allows the savi...more >>

I was able to export to a PDF format using Reporting Services Webservice. But is there a way to make zoom to 100%? Thanks....more >>

Hi, I've an MDB database connected to a sharepoint list (or a windows services list if you prefer) I'vwe also created some reports in this database, and now I want to convert these reports to RS reports. But when I try to access the database I've some problems or crash. Does it possible ...more >>

When rendering a stack bar chart, the legend when displayed in a table, the sort order is reversed. Stack bar shows data in asc ( when sort order is set to asc), but the legend shows in desc. This is not a big issue but users would want to see both legend and cart in the same order. Any ideas on how...more >>

I'm having problems constructing a dynamic query on the Data tab in SQL Reporting Services. When I try to use one of the reporting parameters it fails with "The expression for the query ‘Data’ contains an error: [BC30648] String constants must end with a double quote." I want to be able to ap...more >>

Is it possible to pass a language parameter to the report Manager page that it will show all the information in English or in French depending the value? Without using the Internet Language Option, I want to be able to switch the Manager from English to French at anytimes?...more >>

Hi, We are trying to use Report Manager to generate PDFs by using subscriptions. The reports runs successfuly online but when we run the subscription we get the following Base-64 error: ReportingServicesService!dbpolling!670!25/06/2004-14:24:07:: NotificationPolling processing 2 more items...more >>

Hello, Have been experimenting with the csv format and was wondering if there is a way to render the csv documents with headers that have spaces. On the report designer - it does not allow you to use a space for the name of the text box which will end up being the value of the header. Thanks....more >>

In BOL I read that The valid values for the EventType argument of CreateSubscription are TimedSubscription or SnapshotUpdated. What if I want to use an existing shared schedule, which in the reportserver database appears as type SharedSchedule? Do I still use TimedSubscription? And how can I s...more >>

Hi, I thought SP1 might have solved the problem, but no. None of the other posts seem to help either. I have a trivially simple report, with an image. I've tried various permutations, but when viewing the report in IE a always get the litte red [x]. When rendering the report as PDF the image ap...more >>

I have created a hidden parameter with a default value of user!userid so I can pass this to a UDF which returns a table with data dependent on the logged on windows user. This works fine until I view the report using Report Manager when any alteration to any of the other parameters requires me to c...more >>

Hello, As anyone did any work with variable width text files? We have some customers who currently receive these types of files via Access and was wondering if anyone had done anything similiar. Please note that I am not looking for rtf - just plain txt with variable width. Thanks....more >>

When you use the preview window of the .NET studio editor to go to another report with a date parameter it shows the second report with a wrong interpretation of the date parameter. The same report(s) on a web browser are working ok. Is this possible because we mix .NET Studio (English) with the OS...more >>

in order to see under which account one is currently logged in. This would be usefull in development state. roland ...more >>

I am trying to create an email subscription programmatically, so I first followed the BOL example which worked ok. Later I tried to replace the fixed ExtensionParams array of the example with a call to the web service method GetExtensionSettings, where, for the desired delivery extension, a param...more >>