Hello All, I want to add custom cofiguration section to the report server web.config and use this configuration from the RDL, can it be done? and if the answer is yes, how it can be done. Thank you ...more >>

hi i had luck formatering a text box top to botto in formatting: t e s t i n g but i would like bottom to top and i cant seem to find it g n i t s e t any ideas ? ...more >>

I realize this may not be the appropriate newsgroup for this question, but maybe someone knows. I'm calling native SOAP RS web service methods (with ASP with VBScript, not ..NET) and the response from each method is an XML document. Specifically for the Render method, along with a bunch of ...more >>

I installed RS 2005 on a WIN 2003 64bit. I installed the RS Database on a remote server Win 2003 32bit/SQL 2005 with sp2. I want to install SP2 to the Report Server/Manager site on my 64 bit machine. When running the wizard on the 64bit machine, it wants to upgrage the RS Database installed o...more >>

Looking for good articles on RS best practice, standards and processes. ...more >>

trying to write a report that when exported (csv) each detail line in my report would be a seperate line in the csv file currently the csv places all detail line on the same line in the csv and delimits the row by comma. is there a way in the csv rendering to allow the RecordDelimiter to be a ...more >>

Hi, Could anyone please tell which versions of SQl Server 2005, Visual Studio and Reporting Services are the the most current and/ or where I can find this out on my own, is there a list a utility etc? MSDN site didn't help much. We're behind a FW and auto updating is not an option thanks!...more >>

I have a dynamic date in my reporting services report that displays the previous month and year we are reporting on. Here is the expression: =MonthName(Month(Now().AddMonths(-1))) & " " & Year(Now()) When I create a pdf from this it displays correctly, but when I print it, it always puts th...more >>

I'm getting the following error when attempting to deploy any report in RS (2000): An unexpected error occurred while compiling expressions. Native compiler return value: '128'. I've tried deploying reports that worked fine in the past, and have not changed since they were last deployed. I ...more >>

Hi I have a problem my database table has my parameter value UserId integer I need to set up my report to accept more than one id at a time (ex. 2, 44, 5). I went through the report parameters in reporting services and set the parameter to accept multi value. When I tried to run the re...more >>

Hi, I got a matrix, and a subtotal column (R-click on the column field, and select "subtotal"), but at runtime the column is showing the value of the first column, Matrix Subtotal is not summing. Why is that.. ? help please. the same is when i make a subtotal for rows......more >>

Hi I am using a jump through report action to call a sub report. The main report has the paramters displayed but for the sub report the section where the parameters are displayed is collapsed. Is there a way to change this behaviour for the second report, my users will want to know where the ...more >>

Hi, I have a report that refers to lots of external images (200+ each run). I've been taking a snapshot of this report so that it's quicker for users. I've limited the history to 1 snapshot. However, it appears that the images are being cached in the ChunkData table (in the ReportServer datab...more >>

hey there I am using Reporting Services 2005. I have recently been away and the Microsoft Updates were done and now find that =User!Language no longer works on my reports eg they are back to US dates? Does anyone know of which Update? or what I need to do to correct. thanks Dianne ...more >>

I have created reports in BIDS in a solution called "TestReports" with a shared data source in folder "Shared Data Sources" and the reports in "Reports" (ReportOne, ReportTwo). When I preview them, they all work fine. When I open SSMS Reporting Services, there is nothing at all under the "H...more >>

I know the default web URL for report server is http://servername/ReportServer . How do you specify the RS installed on an specified instance? I mean the syntax. Say if my instance name is finance . Is it http://servername/ReportServerfinance or something esle? Please let me know. Thank...more >>

I am using the report viewer control. The IIS serving up the pages is on the same box as the report services. I have created a jump to URL textbox but included some Javascript to make the window pop up. My link is http://servername/reportpath. This however causes windows to prompt for the pa...more >>

I have a need to publish reports from Sharepoint to users outside of our domain. When using plain http auth, Report Builder no longer works correctly. The standard solution in this case is make the Report Builder folder available anonymously so the clickonce deploy will work. That works for a st...more >>

Hello. I've got this asp.net 2.0 site running ssrs reportviewer. Works great. If I compile the asp.net set using : aspnet_compiler -f -u -v Everything works except the reportviewer. I get error: BC30456: 'InitializeCulture' is not a member of 'ASP.reports_reportviewer_aspx' and...more >>

Hello, I just migrated my reporting services to 2005 from 2000. My reports have come across fine but I don't see the schedules that were set up for them. Also, when I try to create a 'New Data-driven subscription' I don't see this option; I used this feature in 2000. Is there some setting ...more >>

Hi I am new to SSRS and have some trouble. I have a report which is deployed and I can show this report in a project ( asp.net Framework vs. 2 ) using Microsoft.Reporting.WebForms.ReportViewer. Thats fine, but now I have to make up some code for changing the Query used in my datasets: I ...more >>

Hello I have a problem with a Report Server installation. The report server database is on another computer than the report server frontend. On the frontend Server SqlServer Service Pack2 was installed last night. Now I can´t connect to the ReportServer Database. How can I fix this problem,...more >>

Today I received a Windows Update that included SQL 2005 SP2. Since that time whenever I try to use the "Print Layout" feature in Reporting Services, it shows nothing but black. Does anyone know of a fix for this? ...more >>

Hi SQL 2005 was first installed on a Win 2003 Server sans the Reporting Services because IIS was not installed. Then we installed IIS and then RS and then reapplied SP2 for SQL2005. RS runs under an appPool that is configured with a local account that has admin priv. I log into an AD domain a...more >>

Hi All, can any one please help me in finishing this mdx... below is following mdx, which is used to pull the data from the cube for last three months from the current date. this works fine.... now my question is In my cube i have Measure data (clicks) till the current date onl...more >>

I am making raw (not using the .NET framework) SOAP calls to RS web services from Classic ASP but have run into multiple RS permission and IIS logon failure problems. I first created a new user on the machine (RSUser) and have given permissions for the user as a System User, and Browser and...more >>

Dear Experts, We have setup reports to cache, everything works fine. :) We want to know if there is an API to extract cached reports ourselves? How can we do this and is it possible at all? Thanks, Bojan Nikic...more >>

My report used to work beautifully in regards to paging and then the requirements changed. I added a subreport into the table's detail section and made it a drilldown with the toggle based on a group value. The paging went wonky as in there is only one page now even with the paging set up on t...more >>

I have a report that displays records for data that is filtered by a selectable parameter. The parameter itself is a listname that I in turn use in the where clause with a "where fieldname in (select fielda from table2 where listname = @listname)" On the report header I would like to display ...more >>

hello i am building a report which is going to show me list of candidates from different groups for that i have created a qurey that display group list. and a qurey display orginal data (candidate list) my problem is i can only select one group at time for report parameter from group list ...more >>

Dear MSND! I have a problem when i design a report in Visual studio 2005/Report Server Project (SQLServer 2005 SP2). The "sum" Of Gross Profit Margin, or other percentage calculations, summarize the content of "child" rows instead of showing the groupings percentage. To show you my probl...more >>

Hi experts I am working on sql server reporting services 2005. And now a days i am facing a problem. Some times when i want to run a report the at that time i am geting the following error msg "An internal error occurred on the report server. See the error log for more details." This eroo...more >>

Hi Everyone! In my project I have lot of small small reports having the same criteria e.g. Company and Years, the requirement here is to execute all these reports and create a single document that can be delivered to customer's customer. I am not able to find any such posting in this group...more >>

Looking for an example of sending a 2005 RS report via a web page on demand. I would need to fire it when a user clicked a button on the web form. In the old days, in plain old ASP, we used to build an HTML formatted email body and then fire it off using CDO. We could still do that with ASPX b...more >>

Hi, Is it possible to sort by the automatic subtotal column that can be created when using a matrix in a reporting services report? The underlying stored procedure returns data along the following lines: name bucket count ----- ------- ------ one <10 5 one ...more >>

Hi all, I have created some reports with SSRS. I have two users that when they click the print icon they receive a "Print Error" dialog box with the message "Error loading resource library. (0x8007007E)". I have removed the RSClientPrint and then clicking the printer icon again tried to in...more >>

Hi all, Here's what I'm trying to do. I have a matrix laying out the results of a dataset horizontally. On one row, I have a some value, and below that, I would like to have a running average of the row above it. For example. Month 1/2007 2/2007 3/2007 Revenue $...more >>

I have a OLAP cube that I'm using for a data source that has several calculated measures in it. When I add the calculated measures to my report the retrieval time goes from ~1 second to ~4 minutes. I haven't been able to locate any information about this issue. Is there something I'm doing ...more >>

Does anyone have a way to get reports that are emailed out via the Subscriptions service as a WebArchive to appear normally in a Blackberry? Each element in a row in a table gets put into a new line. It looks fine in any normal email interface, but not in a Blackberry. e.g. Row1Col1 Row1Col2 ...more >>

I must be missing something. I've looked this up and no one else had mentioned this problem. I have two tables, display is based on a parameter, biut only one or the other is displayed. When I display the second table, it ends up on the second page and the first page is blank. What am I mi...more >>

Hello, Using SSRS 2005 SP2, I have a report that has a multivalue parameter of US states in a report that returns orders. I successfully can return order numbers along with the associated state where the order was placed. However, if I select the states of NH, VT, and MA and there are no ...more >>

I can't seem to locate the sample reports in the latest download of SQL Server 2005 evaluation. I have also tried (and failed) to find an alternate download location for the samples. Anyone have any ideas where these can be obtained? Thanks ...more >>

Hi, I would appreciate your advice in deploying enterprise BI solution. The task at hand is this: I need to get the data from DW (SQL 2005), process into SSAS and present with SSRS. I may also need to offer a third party OLAP browser as a part this of solution. My initial thoughts about the s...more >>

This is on SQL Server Reporting Services 2000 If I give UserA browse right to FolderA then UserA can browse FolderA. However, if make UserA a member of GroupA (tried both Domain local and Global group scopes) and give GroupA rights to browse FolderA and take browse rights from UserA. UserA...more >>

I'm using F to format currency (UK sterling) to 2 decimal places. Is it possible to include commas to separate 1000 multiples - e.g. 5,000,000 -- FionaDM...more >>

Does anyone know the following with regards to working in the Middle East with a Business Intelligence background: 1. Degrees or certifications needed 2. Current hiring requirements 3. Language requirements 4. Work experience 5. Tools used on the job, Oracle, SQL Server, etc 6. Awareness and ...more >>

We have a report that users typically export to Excel. I've created a macro in Excel that I run against the the exported report to do some follow up work. Unfortunately, this requires that I export the report myself, run the macro and forward on to those interested. I'm looking for a way t...more >>

Does anybody know if it's possible to embed a sub-report that is on a separate instance of Reporting Services? And if so, how? For instance, I have SERVER1 and SERVER2, both running SQL Reporting Services. I have report FOO on SERVER1 and I want to create several reports (BAR1, BAR2, BAR3, e...more >>

Hello, I'm installing reporting services on a new sql server 2005 box. While on the machine, I go to Reporting Services Configuration Manager, I'm trying to create the report server virtual directory and report manager virtual directory. My issue is that I don't want to create them on the sq...more >>

I only ask this after spending most of the day searching for this information. Hmm, Is any customization of the the sql report server home page (by home page I mean /reports/Pages/Folder.aspx) possible? In particular I want to add a block of text describing how people can request to join a p...more >>

Hello, I'm kind of new to reporting services and have gone thru a number of web casts but no where did I come across this. Say I have two datasets from two different database on servers. I know a report can have multiple datasets but is there a way I can associate the datasets. For exam...more >>

Hello: Is it possible to import "IBM DB2 UDB for iSeries .NET data provider" into Reporting Services 2005? I tried to do it but was unsuccessful. I'm attempting to access data on our IBM i-Series(AS/400) and I need to pass parameters in my datasets. I appreciate any assistance you can give ...more >>

We are running RS 2000 SP2 on an Server 2003 box. We've had almost a daily issue now where the RS site (http://servername/reports) is not responding. All other IIS sites on the same server are fine. There are no errors logged in the Event Viewer. If we run IISRESET, Reporting Services works ag...more >>

Hello. I am new to working with SQL Reporting Services 2005 in an EPM Solution. So, I downloaded the Microsoft EPM2007 Demo environment and have this running in a Virtual Environment. I am pretty familiar with MSPS 2007 and MOPPS 2007. I am now trying to work with SQL Server Reporting Servi...more >>

We're having a problem which appears to affect 5-10 clients using SQL RS 2000. It seems randomly, the reporting services web service will stop responding. We get timeout errors when trying to run reports through our web based application, and the http://localhost/reportserver virtual dire...more >>

I was wondering if anyone found a way to provide report users a help file explaining the parameters, through the Report Manager interface. Or if you did it another way, I'd like to know that too. TIA, Renee ...more >>

Good Morning, all, I have been tasked to design reports for our budget data. The client wants to be able to drill down through our company hierarchy. Some departments are five levels deep in the hierarchy, but others are only three levels deep. Right now a very simplified version of my...more >>

SQL Server 2005 I have a report with 20+ columns. Normally the text in each colum heading is aligned at the top of the column heading. The column heading is three lines high - there is so much text in some of the columns - it takes three rows to display all of the column heading text. Wi...more >>

I want to create a report with a textbox which contains a field followed by a Carriage Return and Line Feed then another field e.g =First(Fields!Field1.Value)+ Carriage Return and Line Feed + Fields!Field2.Value How do I do this? I see a suggestion in places for vbCRLF and also \n. ...more >>

Hi there, this is likely to be a long post as I have a lot to explain about the problem in the hope that someone somewhere has some ideas!! Ok, let me begin: I have a production server that houses the following - a website under IIS 6, SQL Server 2005 and Reporting Services. Because of the ...more >>

Hello all, We have a Windows 2003 server running SQL server 2000 and makes reports available via a web link. The problem is that when people access the web link they are intermittently being asked to supply credentials, despite the fact we have integrated authentication enabled on IIS. The...more >>

Hi, I have created the report (which is an invoice)...it looks fine, but I have to enter the invoice number in the Report Viewer Param1. How can I write this out as an address in the address bar, so that I can programatically create specific invoices with my c# app? Thanks, Trint ...more >>

Hi, I have 2 tables in a report and, depending on which value a user picks in a particular parameter, I want to display only one of the tables. Is there any way to do something like, "IIF(parameters!param_A.value = "Y", visible = true, visible = false)" or something like that for a table? ...more >>

I have a new SQL Server running 2005. I have moved over all the user application databases from a SQL Server 2000 server. I had a few reports written in 2000. Do you move over the databases called ReportServer and ReportServerTempDB from 2000 to 2005 or do you let the setup disk create the ...more >>

i'm trying to call a function i wrote in vb.net. Here is the function ================== Public Class runningSum Public Function getit() Return 1 End Function End Class ================== this is in a project called my_Custom. I've compiled the code and moved the ...more >>

The function asks for an array of values. I am using a Matrix report. Stored Proc returns a Year, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec I get one row for every year. I can do this in VB easily using the financial.IRR() function, but I would rather not make a call to an...more >>

Hi, I need to generate a report that gives me a list of all users and their access right on a sql server Any ideas how i can do this Thank in advance Zach ...more >>

I have a dataset with customer, date and count columns. Then I have a matrix based on that information as follows: Oct 2007 Sep 2007 Aug 2007 Customer A 123 432 959 Customer B 984 394 345 Cu...more >>

Hi, I have a problem with the following: I have 2 dates in the following format mm/dd/yyyy hh:mm:ss AM. I would like to measure the difference between 2 dates (Date1 and Date2). When I use the following expression "DATEDIFF(d, Date1, Date2)" I get a value without decimals. How can I hav...more >>

Hello, is it possible to change the default font "Arial" to an other font (for example "Gotik")? where can i do this? Thanks in advance, Ralph ...more >>

I've run into what may an odd bug. I'm using SQL Server 2005, and Visual Studio 2005. I was provided with a SQL statement (that is, I did not originally write the SQL) for use in creating a simple manifest report. Names are changed for security, but it is like so: SELECT DISTINCT A.NAME [nam...more >>

I have a report with a parameter set up for Account name. When I use the drop down I do display the 5 accounts associated with the 5 rows data. (One shows in the parameter drop down 3 times because it has data for 3 different rows.) Account 1 Account 1 Account 1 Account 2 Account 3 My q...more >>