Conditional Formating in Reporting Services 2005

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - license question If I have a licensed version of SQL 2000 am I eligible for a free Reporting services copy? Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67866
  - 2
    - SQL 2005 reports and SQL 2000 Can I run SQL 2005 report on SQL 2000 server? Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67865
  - 3
    - Back call without drillthrough report ASP.Net 2.0 Web app with ReportViewer Control. I have a basic report that has a link to another report. The first report loads OK then I click the link then the second report loads OK. But when I then hit the back button (the back arrow in the Reportviewer Control) I get Back call without drillthrough report? My control in aspx page: <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="9pt" ProcessingMode="Remote" Height="96%" Width="100%" BorderColor="#ECE9D8" BorderStyle="Solid" BorderWidth="1px" ShowBackButton="True"> </rsweb:ReportViewer> my code behind: string url = Request.QueryString["url"]; string path = Request.QueryString["path"]; if (!Page.IsPostBack) { ReportViewer1.ServerReport.ReportServerUrl = new System.Uri(url); ReportViewer1.ServerReport.ReportPath = path; } Any ideas appretiated! Tag: Conditional Formating in Reporting Services 2005 Tag: 67864
  - 4
    - Hide blank page when exporting data I thought that I had come across a question referring to this problem before, but I can't seem to find it. I'm not sure if this makes a difference, but I'm using the Reporting Services 2005 add-in for Sharepoint. I want the user to be able to export to PDF, but I don't want the blank browser page to pop up - or I want to be able to close it automatically. Is there a way to accomplish this? Thanks! daw Tag: Conditional Formating in Reporting Services 2005 Tag: 67862
  - 5
    - security problem on .NET Apps calling Reporting Service Web Service I installed sql 2005, and RS on my windows xp machine. I also have a .NET web applications calling the RS web service. When I run the app from http://localhost/MyApp/PageCallingRS.aspx, it's not working. So I added mymachince\ASPNET as a user (content manager) for RS, it worked. Now I deployed my app to a web server on the network. I tried to run the app from my browser, i.e. http://webserver/MyApp/PageCallingRS.aspx, it gives me the following error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.WebException: The request failed with HTTP status 401: Access Denied. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at ... The IIS for the Virtual directory of MyApp on the web server is setup to allow anonymous access. I tried the following but all failed: 1. I tried to add webserver\ASPNET to RS (user not recognized). 2. Disable anonymous access to the directory from IIS, and added the domain account of the web server as a user into RS, and set the impersonate mode on for my web app. still not working My questions are: 1. Does that imply that my web app has to be deployed on the same server as Reporting Service? 2. If not ture, how to configure to make it work? -Please Help thanks !! Tag: Conditional Formating in Reporting Services 2005 Tag: 67860
  - 6
    - BUG Multi-value field in SP2 Hi, There seems to be a bug with the multi-valed fields when only one value is selected and that value contains only spaces. I get the message 'Please select a value for the parameter...'. It works when I test it in Visual Studio but it doesn't work on the Web. I'm using SQL Server 2005 with SP2. Any ideas ? Suggestions ? Regards Alain Tag: Conditional Formating in Reporting Services 2005 Tag: 67859
  - 7
    - Problem with parameter default when redeploying report I've written a rss script file to automate publishing of reports to our server. I've encountered a problem when republishing reports that have a default value set for a parameter. If I change the default value of the parameter in the report rdl and then try to republish, that parameter's default value is not getting changed on the server. If I add or remove parameters then the server gets updated correctly. It's only if I change the default value that the update is not happening. I've tried with both the CreateReport and SetReportDefinition functions. The only way I've gotten this to work is to delete the report and then republish but this is not an acceptable solution because it also deletes report history and subscriptions. I'm using RS2005. Any help is appreciated. Tag: Conditional Formating in Reporting Services 2005 Tag: 67854
  - 8
    - Three Tier - Call to reporting services? If I install reporting services on my database server, can my developers make a call to it using web services? I have a front-end web server with a firewall separating it and the web services machine and the database server. I would like for the applications to make a call for the reports from the web server to the web services machine and then that machine make the call to reporting services then then that get passed back to the front-end web server. Is this possible without opening up the database server to anything but the web services machine? We are not looking to make use of the reporting service UI but just to send reports using calls from asp.net. Tag: Conditional Formating in Reporting Services 2005 Tag: 67851
  - 9
    - Formula for lable is not working when Numeric -Time scale option is selected In a report for X axis when I enable Numeri-Time Scale Values then formula for lables is not working. How to resolve it? Tag: Conditional Formating in Reporting Services 2005 Tag: 67849
  - 10
    - Trouble setting up reportservices I'm having issues getting report services to work (2005). I've tried on both a Vista and an XP SP2 machine. I'm using SQL Server 2005 Dev ed. Basically on both machines I have got to the point where if I browse for http://localhost/ReportServer all I see is localhost/ReportServer - / Microsoft SQL Server Reporting Services Version 9.00.3042.00 I get no error messages just what appears to be a fairly blank page. Any ideas? Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67840
  - 11
    - Passing Metadata for Data Source Views Is there any way to store the Description and Friendly Name in the SQL Database design so that it will pass through to the Data Source View. I'm dealing with a LOT of tables and this would sure make life easier as I create the different views that are needed for the 18+ applications I have to create for? I've tried editing the Description fields in the table and then creating a new View, but it doesn't appear that passes through. Tag: Conditional Formating in Reporting Services 2005 Tag: 67831
  - 12
    - Create a dataset FROM the output of a Visual Studio report I'd like to use Visual Studio to actually create an output file which I will then use as an input dataset to generate various reports. The "output" need to be dynamically grouped with several calculations at the grouping level. Visual Studio gives me the flexibility to accomplish the logic all in one place. (The logic was formerly accomplished by a series of ACCESS queries) Does anyone know if this is possible, and how I might go about it? (I know how to set up the grouping and the calculations.) Thank you, PB Tag: Conditional Formating in Reporting Services 2005 Tag: 67829
  - 13
    - How do I add a new column to an existing Data Source View in SSRS? I've got a table in my Data Source View that is one of our central entity tables in our warehouse, and there are LOTS of relationship lines (Roles) linking to this table. We've just added 6 new columns to this table, and I need to add them to the Data Source View so the new columns will be available to the end users running Report Builder. I am pulling my hair out trying to find the option to add the new columns! Completely removing and re-adding the table is NOT an option, as we have 37 relationship lines coming into this central entity table. Tag: Conditional Formating in Reporting Services 2005 Tag: 67828
  - 14
    - Nulls -conditional display of value in Visual Studio I am trying to display one of 2 values based on an input parameter. I have created a field which is supposed to evaluate the parameter and display the appropriate field. My code is as follows: =iif( Parameters!LastWeek.Value = "Y", Fields!Measures_M30N_MTD_Last_Week_of_Month.Value, Fields!Measures_M9N_MTD.Value) When I preview my report and select "Y" as the parameter, my field displays nothing. I have checked the data and know there is a value in the field represented by the "true" portion of my statement. If I change the staement to this:=iif( Parameters!LastWeek.Value = "Y", Fields!Measures_M30N_MTD_Last_Week_of_Month.Value, 0) I actually get the value I am expecting. My conclusion is the data in the "false" portion of the statement is actually null or non-existant. I think this is causing my statement to malfunction. How do I account for this and make my statement work properly? There will eventually be data in the field represented in the "false" portion of the statement. The data will reside in either/or both depending on the time of month. Thank you... PB Tag: Conditional Formating in Reporting Services 2005 Tag: 67827
  - 15
    - Can't run rskeymgmt after SP2 After installing SP2 for SQL 2005 I can no longer run rskeymgmt. I was trying to backup the encryption key (rskeymgmt -e -fc:\rsdbkey.txt -ppassword) but I get the following error: The Report Server Windows service in not responding to RPC requests. The service may not be running. I have checked and the service is running. Are there any issues with SP2? Tag: Conditional Formating in Reporting Services 2005 Tag: 67826
  - 16
    - Copy Objects to Another Report Server I have two existing Report Services installations, both on a separate server. I'd like to recreate the current environment of Server A to the second Reporting Services, Server B. Is there any way to "copy" the users, folder structure to Server B "automagically" or am I stuck with having to recreate everything manually? Thanks!! Tag: Conditional Formating in Reporting Services 2005 Tag: 67825
  - 17
    - RowNumber at group level and detail level Hi, I am trying to assign running number at Group Level and Detail Level(rownumber(nothing) and rownumber(GrpName). But row number was not coming as expected. My requirement as follows example: 1 grpname 1 detail1 2 detail2 2 grpname 1 detail1 2 detail2 Is that possible in Sqlreporting? Is there any way to declare global variables like in crystal in sqlReporting? Tag: Conditional Formating in Reporting Services 2005 Tag: 67823
  - 18
    - Can total be moved to top of column rather than bottom Standard newbie disclaimer: I have searched the archives and this is my second week with the tool, so my apologies if this is a rather simple question or I am not asking the question properly. My team has received a specification for a report where the customers would like to see column totals at the top of the column, rather than SSRS's default of bottom. I am new to banded report writing, so I am hoping this is fairly simple. Using BusinessObjects, I would have inserted a row at the top of the column and then copied the formula from the total (or subtotal) line up to the line I had just inserted (then deleted the row at the bottom). Is there similar functionality with SRSS? Kind regards, Steve Haffner Tag: Conditional Formating in Reporting Services 2005 Tag: 67822
  - 19
    - Security Error Hi to all i have the next problem: i have make a report tha call an external assembly. This assembly show a method that retrieve some data from a database. This method retrieve some data too from a XML configuration file. In development enviroment all working good but when i try to view the report from the browser there is the next error. User ID=Error in the file file D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\SettingsRS.xml. File not found. Error detail: System.Security.SecurityException: Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed. The file SettingsRS.xml is my configuration file. How can i solve this situation? Where is the mistake? Thanks in advance Enrico Zerilli enricozerilli@hotmail.com http://blogs.dotmark.net/enf/ Tag: Conditional Formating in Reporting Services 2005 Tag: 67818
  - 20
    - Data Driven Subscription with Dynamic Email Attachment File Name Hello, We are using SSRS with SQL Server 2000. We have a sales rep report that requires a sales rep value as a parameter. We have multiple data driven subscriptions setup on the server that run for each distinct sales rep number. Each subscription sends the output file to one inside sales manager as an excel attachment. We would like to be able to dynamically set the filename of the excel file for each DDS. Currently the User Stored Procedure that powers these reports returns a concatenated string value that contains the descriptive name of the report. This string value is then bound to the Subject field in the Step 4 screen of the DDS. We would like to use the same string value returned from the USP as the file name of each excel file, but there is no such option in the Step 4 value assignment screen... The following thread makes it sound possible, but doesn't go into detail.. http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/df6ebfb877bfb9d7/dbe7d741f7dadb88?lnk=gst&q=Dynamic+Attachment+name&rnum=1&hl=en&utoken=vdiTRUsAAACAT_kPml7nPanGq5_khmjX3li9W8IAv61kPG3pZaD6gecDD8SMl21CiVz-Yo8gU62WP3uELSZ1TDB3ml01NPgw3Cql7rXnpDkMfzATskuk_Q Is there any way to accomplish the above outlined request? Tag: Conditional Formating in Reporting Services 2005 Tag: 67812
  - 21
    - Where to Install Reporting Services? I am trying to figure out the best place to install reporting services give the following: The need is to allow developers to use reporting services within their applications. Web users will only get the results of the reports in a web app and will not have access to the UI. Should I install at the database lever or would it be better to install on the web services server? We are running 3-tier applications: Web Front-End Separated by a firewall allowing traffic only via web service to the web services server. Then the web services server only has access to the database server not separated by a firewall. We are not running up against any processing load problems at all.. Very low utilization right now on average less than 5 %. Tag: Conditional Formating in Reporting Services 2005 Tag: 67808
  - 22
    - Export Multiple Reports and Export to 1 PDF? Is it possible to render multiple reports and then export them to 1 PDF file? If so, how can this be accomplished? Tag: Conditional Formating in Reporting Services 2005 Tag: 67805
  - 23
    - How to Programmatically Change Print Layout in Report Viewer Toolb Does anybody know how to programmatically set the Print Button on the toolbar of the Windows version of the Report Viewer control? I'd like to display the report in "Print Preview" document look by default after the report has been rendered for the user. I think I'm trying to ask how to change the "Print Layout" setting. Tag: Conditional Formating in Reporting Services 2005 Tag: 67804
  - 24
    - Matrix strange behaviour Hello everyone, At first, i have to say that i didn't read all posts about matrix problem. My problem starts when I deploy matrix on report server. My matrix has two row group and one column group, of coz with subtotal's both. When I design report in VS2005 (I use SQL2005 too) everything is ok. After click on cell value I can recognize scopes without a problem, and send correct values to detail report. Detail report depends on clicked cell value, I mean ... when I click for example on subtotal I show only records for this subtotal and so on... like in excell cross-table. The problem is with same report rendered on web. I saw that I can't recognize all scopes, I know that is sounds very strange but I fight with it all day. I thing that it seems to be a bug in RS. Has had anyone the same problem ? Thank you for answers. Regards Marek Trzaskowski Tag: Conditional Formating in Reporting Services 2005 Tag: 67803
  - 25
    - reportviewer theme hello there, i asked before, but didn't take any answer, maybe this time.. :) i use asp.net 2.0 and reportviewer component with local mode.. when i open report in reportviewer, allways shown with yellow toolbar.. but rest of my site has green-orange colors.. how can i change reportviewer's toolbar color?? thanks a lot.. Tag: Conditional Formating in Reporting Services 2005 Tag: 67799
- Next
  - 1
    - Error message when browsing virtual directories for Report server. When trying to browse the â??ReportManagerâ?? virtual directory directly from IIS after configuring the Report server, it is displaying the following error message: The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied. I checked the servicesâ?¦All the services were running. What could be the reason for this..and what I need to do to correct this.. Thanks in advance.. Rajesh -- a Tag: Conditional Formating in Reporting Services 2005 Tag: 67791
  - 2
    - Scheduling Reports outside of RS application I'm looking for a way to schedule reports to be emailed and/or placed in fileshares, without using the Reporting Services application. The reason is that I want to wrap the success or failure of this job inside of a SQL job or other type of job that can notify me upon failure. As far as I can tell, the RS subscriptions don't have this option. I know I can probably build my own .NET application that will do all of this, but I'm wondering if there is a better way, maybe something through SQL Server. Any ideas would be appreciated. This is for SQL Server 2000 and Reporting Services 2000. Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67789
  - 3
    - design question I am trying to achive something like this: --------------- some text ---------------- | | | | | | |----------------------------------------- where border is a table's border. Any idea? Tag: Conditional Formating in Reporting Services 2005 Tag: 67787
  - 4
    - Merge cells Can I merge two vertical cells in a table? Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67786
  - 5
    - NullReferenceException I have a report with a chart and a textbox. I use the 'navigation' property of the textbox to jump to another report. When my request returns an empty dataset I have the following exception: [1580] w3wp!library!1!04/04/2007-20:16:26:: i INFO: Call to RenderFirst( '/Reporting/ReportProjects' ) [1580] w3wp!processing!1!04/04/2007-20:16:26:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; [1580] Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.NullReferenceException: Object reference not set to an instance of an object. [1580] at Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.FieldsImpl.ResetUsedInExpression() [1580] at Microsoft.ReportingServices.ReportProcessing.Action.ResetObjectModelForDrillthroughContext(ObjectModelImpl objectModel, IActionOwner actionOwner) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.CreateTextBoxInstance(TextBox textBox, ProcessingContext processingContext, Int32 index, IScope containingScope) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.CreateInstance(ReportItem reportItem, Boolean setupEnvironment, Int32 index) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.CreateInstances(ReportItemColInstance collectionInstance, ReportItemCollection reportItemsDef) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.CreateInstances(ParameterInfoCollection parameters, Boolean noRows) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, Boolean snapshotProcessing, Boolean processWithCachedData, GetReportChunk getChunkCallback, ErrorContext errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback, ProcessingContext& context) [1580] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached) [1580] --- End of inner exception stack trace --- If I remove the textbox, all is fine (nothing is displayed) Any idea ? Tag: Conditional Formating in Reporting Services 2005 Tag: 67784
  - 6
    - 2 Text Boxes - User must fill in one or the other (validation possible?) Hi all, Based on these Report Specs it looks like using just Report Server alone won't cut it. Spec: 1) Tracking Code: Allow Blank 2) Event Code: Allow Blank 3) User must fill in #1 or #2 but not both 4) Mkt Code: Allow Blank or up to 5 values 5) Date1: Option to specify a single date or range of dates 6) Date2: Option to specify a single date or range of dates 7) Date3: Option to specify a single date or range of dates If anyone has done this can you tell me if I have to code an ASP.NET Application w/embedded Report Server Control? OR how best to do this? I'm just trying to get off on the right foot. Thanks Fred Tag: Conditional Formating in Reporting Services 2005 Tag: 67778
  - 7
    - Reporting Services and SharePoint I have SQL 2005 Reporting Services running under MOSS (i.e. in a report library). Have created a datasource and use report builder to build a report. When I start a new report I see all the entitities (tables) in the database on the left hand side and I can drag and drop tables. I build a very simple report with 2 columns FirstName and Address and all is OK.... BUT I add the 'Name' column into the report in Report builder and I run the report and I have the following error : An error occurred during rendering of the report. The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it. Any idea ?? Thanks for your help... Patrick EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: Conditional Formating in Reporting Services 2005 Tag: 67777
  - 8
    - Resize rectangle I am putting a rectangle around my table. Table's height can grow alone with a number of rows. Can I resize a height of the rectangle accordingly? Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67774
  - 9
    - RS2005 exporting to a pdf... We have upgraded to RS2005 and I am now receiving a "non negative number required" error when exporting certain reports. The same report works fine with some records and fails with other records. It looks to be related to the photos that are embedded in the report. The photos are stored in the database and not a link. The report always runs and looks fine in the report viewer window. When I try to export to pdf, I get the error. I can remove all of the photos from a report that is failing and it exports fine. I start adding photos back to the report one at a time and it fails only on certain photos. I can run the same report with the same data on our RS2000 server and all reports export fine. Has anyone else experienced this issue or have any ideas? We are running the RS2005 (enterprise version sp2) on windows 2003 server. I have include the dump of the error... w3wp!reportrendering!9!04/03/2007-17:49:14:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ; Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.ArgumentOutOfRangeException: Non-negative number required. at System.IO.MemoryStream.set_Position(Int64 value) at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.MonochromeJpeg(MemoryStream memStream) at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImagePDF image, Double left, Double top, Double width, Double height, Boolean scaleImage) at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImageUnscaled(OutlineObjects outlines, CanvasImage image, Double left, Double top, Double width, Double height) at Microsoft.ReportingServices.Rendering.ImageRenderer.Image.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableCell.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableRow.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableCell.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableRow.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render) at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback, Int32 streamPageNumber) at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67773
  - 10
    - How to determine where an 2000 installation's database is Hi - In 2000, how can you determine where an RS installation is point to for it's sql server repository database? Not clear to me since the config files are encrypted. I installed the database on a different server but not sure how to find out after the fact which server and db that is. Thanks Tag: Conditional Formating in Reporting Services 2005 Tag: 67770
  - 11
    - Expression in filter list SQL Server 2000, SSRS 2000 I am trying to filter a table based on the user's selection of a parameter. I am having some trouble with the filter expression. Basically if the user chooses option 1, I need to filter the table by the column IsAdded = 1. If the user chooses option 2, I need to filter the table by the columns IsAdded = 1 OR IsDollarDifferent = 1. Can I do this in the filter expression box? If so, how? I have tried several variations of the following in the expression field: =iif( Parameters!showFunding.Value = 0, "=Fields!IsAdded.Value = 1", "=Fields!IsAdded.Value = 1 OR =Fields!IsDollarDifferent.Value = 1") Tag: Conditional Formating in Reporting Services 2005 Tag: 67768
  - 12
    - RS2000 and Excel Hello. I got some fields in my reports with padding from left side (for example 'Padding' property is set to '6pt;2pt;2pt;2pt'). So when I export the report in Excel I can't see this issue. I supposed that the spaces should appear in the report before the value of cells. How can I resolve such problem? In HTML or PDF ouput all the things are going ok. Thanks. Tag: Conditional Formating in Reporting Services 2005 Tag: 67762
  - 13
    - RS2000 and Excel Hello. I got some fields in my reports with padding from left side (for example 'Padding' property is set to '6pt;2pt;2pt;2pt'). So when I export the report in Excel I can't see this issue. I supposed that the spaces should appear in the report before the value of cells. How can I resolve such problem? In HTML or PDF ouput all the things are going ok. Thanks. Tag: Conditional Formating in Reporting Services 2005 Tag: 67761
  - 14
    - Parameters in SSRS with OLAP Hi - I have a report that uses an OLAP cube. I cannot figure out how to pass parameters into the report using URL. I've tried setting the parameter to the value I desire, but that doesn't work. Here's an example: http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=301 When I look at how OLAP passes parameters into reports, it's not the same as when I use straight SQL tables. So I tried: http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimParameter=[DimParameter].[MEMBER].[301] but then I get an error message saying that the text is too long. Any help would be appreciated. Tag: Conditional Formating in Reporting Services 2005 Tag: 67760
  - 15
    - US Date Format in Date Picker I also have this same problem since applying SQL Server 2005 SP2. Everything possible is set to UK English, but when you select a date for a report parameter from the date picker it displays in US format MM/DD/YYYY but interprets it in UK format DD/MM/YYYY. I found that if you first run the report with a date that is valid in either US or UK format e.g. 01/01/2007, the second and subsequent execution of the report will display and treat the selected date as UK format. This is not a satisfactory work around. I am working with a Windows XP SP2 client with IE 7.0. A colleague working with Vista as a client does not have this problem. If you get a satisfactory solution please let me know. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: Conditional Formating in Reporting Services 2005 Tag: 67758
  - 16
    - Field Formats I have just started playing about with reporting services in an attempt to assess whether to use it as our reporting system instead of crystal. Ive noticed that the field format options that are available seem to be quite limited. I am based in the UK and my machine is set up to use Â£ as the currency symbol, and my date format is dd/mm/yyyy. When I right-click a field in my report, then Properties ..., then Format tab and then the ... build button to select a format, the options seem very limited. For example, if I select Currency, the symbol is $, if I select Percentage, the options seem to be no decimal places or 2 decimal places, if I select date the option to display as dd/mm/yyyy is not available. I know there is a Custom option, but, when trying to format a date to display as dd/mm/yyyy format, my dates in the report display as 01/00/yyyy. It seems that dd/mm/yyyy is not interpreted in the same was as all of my other software interprets it. Also, the defaults for the machine dont seem to be used. How do I overcome these format issues? Im running SQL Server 2005 SP2 and Reproting Services is installed locally Tag: Conditional Formating in Reporting Services 2005 Tag: 67756
  - 17
    - Three column subreport I have an incident report that needs to list a variable number of dates. I thought I might use, as a subreport, a three-column list. I have the report-used-as-subreport exporting to PDF properly. If the system returns incident dates date1, date2, date3, date4, date5 the PDF looks like: date1....date2....date3 date4....date5 Unfortunatly, when printing as a subreport, the PDF looks like: date1 date2 date3 date4 date5 Two questions, if you please: 1) Will a three column list simply never process horizontally when used as a subreport? 2) Any other suggestions for how I might process these dates in a three-across layout? Thank you! Tag: Conditional Formating in Reporting Services 2005 Tag: 67748
  - 18
    - Draw Horizontal Line at Threshold I have a table in reporting services. I have a field that calcuates a percentage and the report is sorted in ascending order by this percentage. I want to draw a single red horizontal line at a threshold, let's say 95% so that any record lower than 95% would be above the line and any record higher would be below the line. How can I do this? Tag: Conditional Formating in Reporting Services 2005 Tag: 67747
  - 19
    - Navigate to a Report in another Project I have a report that summarises data in project A and a report that details the data in Project B. When the users clicks an item link in the Project A report I want to be able to call the report in Project B. When you create the link you are offered the reports in the current project only. RS then adds the TargetReportFolder (project properties) to that name for the full path of the Report. Is it possible to link to a report in another project. i.e specify the full path? Tag: Conditional Formating in Reporting Services 2005 Tag: 67743
  - 20
    - TOP 10 problem on inner join Hi. I have a report with accounts in a list, and all activities belonging to each account in a table , at the buttom of the list I would like to show all accounts in my report, but only the top 10 activities for each account. I tried to solve this filter in sql but i have this running and it shows all activities for the account. Can anyone help me out on this, how do i create an SQL sentence which can do this. Here is the code i have: SELECT Account.*, activitypointer.Subject from dbo.account INNER JOIN activitypointer on account.OwnerId = dbo.ActivityPointer.OwnerId Regards Steen Tag: Conditional Formating in Reporting Services 2005 Tag: 67741
  - 21
    - Stored procedure prefixes Hi All, I just had a client ask me if the stored procedures that a suite of reports I have written can have a different prefix than dbo. Of course, if the prefix is supplied inside the RDL a different prefix can be used....but that would mean knowing the prefix during development or changing all those reports at install time....and upgrade time... So, I was wondering if there is an 'global parameter' that can be set in a project or set for reports that can change the prefix being used for stored procedures being called by Reporting Services? In the meantime, all we have done is change the prefixes for all the tables and leave the prefixed for SPs to be dbo. This works fine......so this is not a 'big deal'....the client just feels it would be nice to have the SPs have the same prefix as the tables. Thanks Peter www.peternolan.com Tag: Conditional Formating in Reporting Services 2005 Tag: 67739
  - 22
    - opening a report using window.open() causes asp.net postbacks to fail I have a problem when opening a sql 2000 report using window.open(). As soon as the the new window with a report is opened, asp.net post- backs will fail. The postback will work but nothing happens on the page. It is then neccessary to restart IE to get the application working again. The script i use to open the window is: window.open('http//:[ip address]/reportserver?/ReportFolder/ ReportName') I do not have this problem on a development machine using 'localhost' or machine name. The behavior I describe happens when the application is deployed to a production machine using server 2003 as well as test machines running XP. In some cases it will work using the machine name but not when using the IP address. Any help would be greatly appreciated!! Tag: Conditional Formating in Reporting Services 2005 Tag: 67738
  - 23
    - DDL depends on other DDLs display empty list Hi, I had this scenario, 5 dropdown list, 1st ddl(called LOB - multi-value), 2nd ddl(called site - multi-value), 3rd ddl(called date - single selection), 4th ddl(leader - multi-value), and 5th ddl(manager - multi-value). The 1st ddl is populated when report started, 2nd ddl is depended on 1st ddl selection, 3rd ddl no dependency, 4th ddl is depended on selection of 1st, 2nd and 3rd ddl. If I ran all dataset for each ddl(which populate each ddl), it works fine with passing required parameter values. When I preview the report, select 1st ddl, report populate 2nd ddl fine, then select 2nd ddl and 3rd ddl. The report supposed to populate the 4th ddl(Leader). It didn't in stead I got empty list. If anyone encountered the same problem and had a solution, please let me know. Thanks in advance. Michael Tag: Conditional Formating in Reporting Services 2005 Tag: 67732
  - 24
    - Deserialization failed: The element has invalid child element a) how do I know which version of SSRS designer I have? how do I know which version is current? b) anyone know what this means: c:\documents and settings\administrator\my documents\visual studio projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571): Deserialization failed: The element 'http://schemas.microsoft.com/ sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/ reportdefinition:Enteranyadditionalcomments'. An error occurred at , (571, 23). Tag: Conditional Formating in Reporting Services 2005 Tag: 67726
  - 25
    - conditional color formatting i'm using SQL Server Reporting Services 2005 and have a simple report that essentially pulls back a bunch of database records and displays the results in the excel-like grid. I want to shade an entire row, based on the value of a field contained in that row, but i can't figure out where (and how) to do this. any help is much appreciated.. tia jt Tag: Conditional Formating in Reporting Services 2005 Tag: 67725

Hello,
I have a problem formating a line in a diagram in SSRS 2005. I want to
change the color of the line depending on a value on the x-axis.
I always get an exception that the bordercolor expression for the diagram
Object 'Bestandsentwicklung.DataPoint' contains an error. The entry string
has the wrong format.

The function is the following:
=IIF(Parameters!CurrentWeek.Value.ToString >
cdbl(Fields!DimZeit_WocheTag_Woche_MEMBER_KEY.Value.ToString),"Firebrick","Blue")
whereby the parameter currentweek should return a number and the field
DimZeit_WocheTag_Woche_MEMBER_KEY, too.

Can anyone help me? How do I have to convert the values to solve the problem?
Stefan

Top