We just upgraded to SS2005. After the upgrade, we can no longer create subscriptions out of Execution Snapshot. Try this experiment: Create a report, with a simple SQL statement like "select * from CustomerDim where CustomerPk = @CustomerPk" Go to Report Parameter, check the "Allow Null" box ...more >>

Hi, Need help here. I have reporting services installed on a sql cluster and backup running every night for the 2 databases: ReportServer and ReportServerTempDB. However a few weeks ago, the backup started failing because ReportServerTempDB failed the DBCC CheckDB test with the following erro...more >>

Problem Statement: Dataset: C1, C2, C3...Cn Table1, group 1 on C1 Table 1 group 1 footer cell (R3C1) expression: =C1*sum(C3) Need to sum value of Table 1 group 1 footer cell containing aggregate over entire report, not just a page. Tried: aggregate(reportitem!R1C1) in list in body - no...more >>

I've searched this forum for the subject of this post, and have wandered into long discussions involving byzantine XML into config files, and complicated class object creation, and I hope this is mistaken... but is there truly no easy way to simply schedule a report to be sent via email? I'm h...more >>

I need some help. I am calling a stored procedure in SQL Server 2000 Reporting Services. However, the SP is a SQL string. I think this may be the root cause of not being able to see fields in filed widow and VS2003. Is it possible to call a stored procedure that executes a SQL string? ...more >>

Hi All ... If I create a report with Microsoft SQL Server Reporting Services Designers Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to deploy it to SQL Server Report Services 2000 ??? ******* Error 8 An error occurred during the parsing of a resource required to ser...more >>

I have suddenly started getting black rectangles appearing on the right hand side of PDF output. There are no rectangles or other objects in this area of the report. Is this a known bug?...more >>

Need your help with formating color of subtotal cell. Here is my scenario: Matrix with are 2 row's groups: - RowKat - RowSubKat and 2 column's groups: - ColKat - ColSubKat I want to have my subtotal cell of RowKat, in ColKat subtotal scope (most outer total of subtotals), to be green wh...more >>

Hi, I got a report with page Width 11.6 and Height 8.2 and Body Width 11.1 and all margins are 0.25. I want to print it in A4 landscape format. Unfortunately if I set for default printer HP Desk Jet printer it prints as A4/Landscape correctly, but if I set for default printer any HP LaserJet...more >>

I have SQL 2005 with SP 1. I am in the reporting services configuration manager and I am at the point where the following options have green circles with checkmarks: Server Status Report Server Virtual Directory Report Manager Virtual Directory Windows Service Identity Web Service Identi...more >>

Hi folks, I have been charged with the task of providing some security measures for reporting services 2000 and unfortuneately I have found myself a bit out of my depth (usually I am found developing desktop applications), I am comfortable with any c# coding required but I'm finding the wh...more >>

hi all i have a report in which data is populated using 6 Stored Procedures, now the problem is before i execute these stored procedures i need to execute one more stored procedure which fills in the data in the table to which the 6 SP's refer to. is there any way to mention the order in which ...more >>

I want to build a SQL WHERE (and possibly ORDER BY) clause in a c# application and then pass them as parameters to a report that would be used by a SQL Server stored procedure. can anyone tell me how to do that? Syntax for building it? maybe a link to an example? thanks -- Lucas Dargis...more >>

Hi All, I've got a report that is set up with the Report Properties layout as follows: page width = 8.5in; page height = 11in; left/right margins = .25in; top/bottom margins = .50in. When the report displays in IE7, there is a large white area (blank) to the right of the report and it's ...more >>

For some reason, I cannot see the Table control for reports in VS2005. Can anyone tell me why this might be? Or more importantly, how I can fix that? Thanks in advance. ...more >>

Hi all, When I use SQL Server 2005 Business Intelligent Development Studio to open my existing reports (*.rdl) , the IDE give me a message, "Unable get IVSMDDesingerService" so that I cannot view or edit any *.rdl. However, for viewing and editing Connection Source(*.rds) is okay. Anyone...more >>

Hi, I've successfully setup the reports server 2005, on Windows Server 2003, and had the permissions for the specific users configured to enable access to the report. When a user logs into the report server, they can access the reports I've created and deployed. The problem arises w...more >>

I am consolidating multiple reports into one and wish to set the formatting on the cell dependent upon the data. The following code does not work = iif(Parameters!RevenueColumns.Value=1, "#,#" ,"") & iif(Parameters!RevenueColumns.Value=2, "N2" ,"") & iif(Parameters!RevenueColumns...more >>

Hi! This is a duplicate of my posting over on MSDN SSRS forum. Perhaps someone here has seen this. I hope that Microsoft can weigh in on this one: I have a sql statement as part of a report that I'm developing using VS2005 and SSRS. The WHERE clause (part of a much larger SELECT / UNI...more >>

i have SQL/RS v2K, i have many, many reports that have been running fine for a year plus, or more. 'running fine' as in my logic is run, my reports are compiled and distributed via subscription. the subscriptions are scheduled intermittently throughout the day, every day of the week except s...more >>

Hi, Do you know if it's possible when exporting a report to excel, to format dates columns as Excel Cell Dates ? Thanks in advance, Greetings Braulio...more >>

I'm trying to create a table where if the column has no data then it is not visible. e.g. Sum(values)=0 then hide=true type of thing This is causing a problem with printing PDF as this still includes all the blank columns, I understand the explanation as to why this happens. I've scoured t...more >>

Hello, I got the error: ______________________ Reporting Services Error * For more information about this error navigate to the report server on the local server machine, or enable remote errors SQL Server Reporting Services ______________________ I saw the answer: "You could set ...more >>

Hi there, I'm having this weird issue here on the report server. I am trying to configure security on the Report Server but right now all users have access to all folder on the report server even though the only group that I have access to the report manager and it's contents is the DomainNam...more >>

Running SSRS 2005, I have a custom assembly that needs to read/browse the file system, Active Directory, and the registry. I have added the explicit permissions into the code before the calls ie. Dim fsec As New FileIOPermission(FileIOPermissionAccess.AllAccess, strFilePath) fsec.Assert() ...more >>

Hi, I changed my machine name after installation of SSRS 2005. After the name change, nothing seems working. To make the reports work, what and where do I need to make the changes? Whenever I starts reconfiguration, it says Invalid Namespace error. Appreciate your help. Thanks Atul ...more >>

Hello. I am trying to get the machine name in a Reporting Services 2000 report. I thought I would put this in the registry and read it from a function in the custom code. Here is my first attempt: Public Function GetMachineName On Error Resume Next Dim WshShell Set WshShell = WScr...more >>

Hi, We are having some users who are having trouble installing the Report Builder applet. They're getting 404 errors. In order to help troubleshoot the problem (which seems to be Domain related) I need to remove the applet from my PC. Does anyone know how this can be done? Thanks. ...more >>

I have a string. I need to extract all the text to the right of a /. should i use substring, or right function. ...more >>

I have created a shared dimmension for which I need to change the alias of the table. I created the shared dimension but when I go to that table and select option to change alias I have a problem. The screen comes up with current alias: dbo.setting I want to change it to dbo.setting_prestng. B...more >>

Hi there! I'm wondering if there is any way to access the datasources inside your custom code of a VS 2005.NET report. My datasources are made up of custom business objects, thus you can imagine wanting to manipulate them from the report. In this particular case I want to build up a TOC durin...more >>

I am getting the following error while configuring the reporting services on my local machine. I cannot restore the key as I do not know the file or the password. Somebody please help! ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configu...more >>

Hello, This question is a mix of SSAS and SSRS. How can I use member properties in an SSRS Report? In the Dataset area I cannot drag the member property, and in the report, if I try: I get an empty string. I read that in 2000 you had to do hack to get working member properties...more >>

Hi all, I am trying to create a "simple" matrix. I have: ----------------------- | DateRange | -------------------------------------------- | Department | sum(value) | -------------------------------------------- I am giving th...more >>

I have a report with several tables inside and I would like to fix the size of the tables regarding the number of detail rows and appear a scroll bar to show the rest of the table and therefore having acess to all table in one page. Is it possible? I'm using SRS 2000. Thanks, Pedro Geralde...more >>

I have this db in some of my servers and don't Know where it comes from. any body know what is this ?...more >>

How can I setup Reporting Service so the report wizard uses a default template we have created? ...more >>

We have created report into Sql server 2005 and viewing this from “Reportviewcontrol” of Visual studio 2005. Now problem is some time report first page displays only Report header and all data on Second page. Some time its display report header and report details on same page. Any one k...more >>

Hi Experts, I've recently done the reports migration. Is there a way to redirect my users from OLD reports server to NEW reports server? Thanks for any clue. Thanh ...more >>

Hi On the layout tab how would I go about finding a specific textbox? Example: If I'm looking for 'textbox80' there should be a way to locate this specific textbox as oppoed to hovering over each textbox. I'm coming from Oracle Reports. Is there some way to get a list of all the textboxs...more >>

Hi group. I'm developing a VB.net application that shows Local Reports (RDLC) within a ReportViewer control. I'm looking for an event handler who controls when I click in a hyperlink that shows a secundary report. I have no problems with this issue in a Reporting Service environment because e...more >>

How can I disable auto page breaking...? I have a report and I don't want any page breaks... Strangely enough I found a post that says to use an expression for the visibility property on a table, when set to "=False" this disables auto page breaking for the table, I tried it and it prodcues th...more >>

I have a really basic chart that pulls data from a SQL table. I have the dataset asking for a machine number. The date range is hard coded in the query for now. This is my table's basic data... Machine | Performance | DateTime ____________________________ 1125 | 60 | 11/16/06 1125 |...more >>

Report A has been deployed and works fine and ties out in production. The design copy of this report in VS has been corrupted. All other backups of this report have been corrupted. How do I get the rdl. for Report A fixed?...more >>

Can I use Visual Studio 2005 to deploy a report to a SQL Server 2000 Reporting Services Version 8.00.1038.00 server? ...more >>

When using the Report Builder in SQL 2005 some larger reports give me an error message = filter required. I assume this is somthing is a setting somwhere but where? -- Peter Peter.freeborn@halliburton.com...more >>

Hi, I have some selection criteria in my .aspx web page and based on the selections, by using an stored procedure, I am generating the dataset. As of now, I am displaying this in HTML table format. Now I have designed the report using Reporting Services and have deployed it onto the Report S...more >>

Hi all, I am getting "rsServerConfigurationError" error when i try to run reportserver 2003 Log files indicate Could not load Authorization extension " error. Let me explain the situation I am running RS 2003 with sql2000 db I need windows authentication but custom authorization. Therefore ...more >>

SQL Server 2000, RS2000.... I have 2 timed subscriptions to the same report. One of the subscriptions delivers the report via Report Server Email, the other via File share. If I choose PDF orWeb Archive as the deliverable then then both reports work. If I choose Excel, I get the following err...more >>

This is pretty weird... any controls past the halfway horizontal point of the report get pushed into page 2. The leftmost control is not affected just those to the right of it. It's like there is an invisible tab after the leftmost control. Smaller (not leftmost controls) (not past the middle of...more >>

I have Vista installed from Msdn pre release but i cant install sql2005 reporting services (sql2005 dev edition). I keep getting the warning message that IIS is not installed or available. I have enabled IIS and the default web site is running. what do I need to do to get reporting servic...more >>

I have a report where the text in the report header is in Forte, but when the report is viewed by other clients the report header is in Verdana. Is there a way to keep all of the font settings no matter who views the report? Also on clients where the font doesn't change when generated the font...more >>

This is the same question that a 100 other people have asked but I still can't get this to work, Sort of... Passing parameters to a subreport, I can get this to work but in the main report I have 3 levels of grouping. Date-->CreatedBy-->and Hour. My sub report is in the details and I want it t...more >>

I am getting this error from Report Builder Cannot create a connection to data source 'dataSource1'. Back end SQL 2000 Credentials stored securely in the report server Login and password of the SQL login The weird thing is pointing to another db on the same server works fine -- Pet...more >>

Hi All, I created a report for Microsoft CRM 3.0... Do I have to "deploy" it to the CRM server in order to use it in CRM or only to "build" the RDL and add it in CRM ??? Any tips on this will be very helpfull Thanks ...more >>

Good afternoon! I have the following problem: There is a table with following structure: PersonID, PersonName, Field1. Filed1 is enum type with values (A1, A2, A3, B1,B2,B3, ..., Z1,Z2,Z3). I need the following table: PersonID|PersonName|A1| A2|A3|(A1 + A2 + A3)|(A1+A2+A3)/Total | ... | Z...more >>

I am trying to provide hyperlink with parameter, to open up in new window by the following url ="javascript:void(window.open( 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))" MArk2.value is a field from query in a dataset, I tried give the parameter mark2.value but get errors ...more >>

Hi, I am looking for a way to hide the parameter input fields in the report. I want to avoid that customer could modify his assigned parameter. If I disable option in report property "prompt for user" (I have German version "Eingabeaufforderung für Benutzer") I cannot assign parameter fro...more >>

Hi, Can we merge the cells vertically in SQL Server 2000 Reporting Services we can merge it horizontally. but i want to do it Vertically. please solve this problem Thanks & Regards Mukesh ...more >>