InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:28:34 GMT20http://www.sqlservercentral.com/Forums/Topic475261-150-1.aspxHi,Anyone give me the links for FAQ in reporting services. Thanks in advance.Thu, 27 Mar 2008 02:19:55 GMTmailtosadheeshhttp://www.sqlservercentral.com/Forums/Topic1456030-150-1.aspxHi,So... I have a report that has a dataset that looks something like this:AccountManager, Product, ValueThe report has a variable called @AccountManager and what i want to do is call the report multiple times with a different @AccountManager each time, collate the reports into one Excel workbook and then mail that off to a list of recipients.Can that be achieved with SSRS?Thanks in advance for any help.SimonThu, 23 May 2013 08:17:19 GMTs_osborne2http://www.sqlservercentral.com/Forums/Topic1455615-150-1.aspxHello,I am trying to get a stacked column chart to work. I have the following query: SELECT COUNT(CALL_Status) AS Calls, Call_Operatorid, Call_StatusFROM CALLWHERE ( CALL_OPERATORID = 'Paul Smith' OR CALL_OPERATORID = 'Martin Jones' OR CALL_OPERATORID = 'Tim Edwards' OR CALL_OPERATORID = 'James Peters') and (Call_Status <> 'Closed' or Call_Status = 'In Progress' or Call_Status = 'User Action Required' or Call_Status = 'Monitoring')GROUP BY CALL_OPERATORID, Call_StatusIf I run my query i get the following results:Calls Call_Operatorid Call_Status1 Paul Smith In Progress2 Martin Jones In Progress5 Tim Edwards In Progress2 James Peter In Progress3 Paul Smith Monitoring2 Martin Jones Open4 James Peters Open2 Paul Smith Open1 Tim Edwards User Action Required4 Paul Smith User Action RequiredI am trying to create a stacked column chart. I have dragged the chart on to the report. I would like the columns to contain the results for each Call OperatoridSo for instance the first stacked column would have 'Open' in red, 'In progress' in blue, 'monitoring' in green etc. In the value section I have dragged Calls. I then added another field and then another field. Subsequently adding three calls values.In the category groups section i added Call_Operatorid.If i run the report all the stacked columns look the same height. What i need is for the respective stacks to correspond with the query results. Do i need to use an expression somehow?Or does anyone know where I am going wrong.ThanksWed, 22 May 2013 10:54:17 GMTdbmanhttp://www.sqlservercentral.com/Forums/Topic1282727-150-1.aspxI have a tablix inside a rectangle (Region 1). Below my report I have another table/rectangle(Region 2). If the number of rows returned from Region 1 goes over a certain amount of rows, it pushes Region 2 to the next page. What I don't understand is there is PLENTY of white space Region 1. Why would it push the bottom to a second page? I have tried several techniques including the forced lines on the right and bottom of the rectangle (http://lukehayler.com/2009/07/managing-reporting-services-layouts-using-the-rectangle-in-ssrs/ -- it's mentioned in the comments), Nesting Rectangles and using textboxes inside the rectangle (http://connect.microsoft.com/SQLServer/feedback/details/383350/add-can-grow-and-can-shrink-properties-to-rectangle-control), setting ConsumeContainerWhitespace = True, and many others that I was shooting in the dark.Attached is a screen print of the behavior. This should fit on one page but again it's not.I would greatly appreciate any help as I have struggled with this for days.Thu, 12 Apr 2012 13:11:52 GMTJCSQLhttp://www.sqlservercentral.com/Forums/Topic1456026-150-1.aspxHello everyone - I was wondering if anyone can provide some insight on how indicators work. I read about the percentage rule but when I do the math it doesn't make any sense. Here is an example using percentage rule, with Auto for Min and Max-- see attachment alsoITEM VALUE STATEItem A 69,622.1990 REDItem B 47,987.9352 YELLOWItem C 11,237.4420 REDItem D 12,063.1895 REDItem E 42,324.9775 YELLOWItem F 24,539.4310 REDCan anyone explain why?Here is the math: PERC OF MAX PERC OF SUM 69,622.1990 100.00% 33.51% 47,987.9352 68.93% 23.10% 42,324.9775 60.79% 20.37% 24,539.4310 35.25% 11.81% 12,063.1895 17.33% 5.81% 11,237.4420 16.14% 5.41% SUM 207,775.17 MAX 69,622.20 Why would 24,539 be on RED?Thank you!Thu, 23 May 2013 08:05:50 GMTgabi.vasilehttp://www.sqlservercentral.com/Forums/Topic1455887-150-1.aspxMany of our users use Visual Studio to speed up development and help organize their code. It’s a flexible development platform, and version 2012 adds tools that improves agile development and helps testing in Windows 8. All Aspose .NET and SQL Server Reporting Services products can be used with [b][url=http://www.microsoft.com/visualstudio/eng/visual-studio-update]Visual Studio 2012[/url][/b]. • Developers can now use Visual Studio 2012 to work with Microsoft Word and other word processing formats from inside their own applications for creating, manipulating and converting documents independently of Microsoft Office Automation using [b][url=http://www.aspose.com/.net/word-component.aspx]Aspose.Words for .NET[/url][/b]. • They can also work with Microsoft Excel and other spreadsheet file formats in their own applications and can create, manipulate and convert documents without needing Microsoft Office Automation using Aspose.Cells for .NET. [b][url=http://www.aspose.com/.net/excel-component.aspx]Aspose.Cells for .NET [/url][/b] lets you automate reports and work with external data sources, create and export charts and work with formula. • Developer can also work with Adobe Acrobat PDF files without relying on Adobe Automation. [b][url=http://www.aspose.com/.net/pdf-component.aspx]Aspose.Pdf for .NET [/url][/b] lets you create and modify PDF files: concatenate or split files, add digital signatures, save pages to image format and more. • Developers can now use Visual Studio 2012 to work with Microsoft PowerPoint and other presentation formats using [b][url=http://www.aspose.com/.net/powerpoint-component.aspx]Aspose.Slides[/url][/b].• Developers can manipulate Microsoft Visio files using [b][url=http://www.aspose.com/.net/project-management-component.aspx]Aspose.Tasks[/url][/b].• Developers can generate and recognize a large number of 1D and 2D barcodes using [b][url=http://www.aspose.com/.net/barcode-component.aspx]Aspose.BarCode[/url][/b].• Developers can Work with Microsoft Outlook, from emails to contacts and appointments using [b][url=http://www.aspose.com/.net/email-component.aspx]Aspose.Email [/url][/b].• Developers can Draw, manipulate and convert images using [b][url=http://www.aspose.com/.net/imaging-component.aspx]Aspose.Imaging[/url][/b].• Recognize characters from entire images or specific areas using [b][url=http://www.aspose.com/.net/ocr-component.aspx]Aspose.OCR [/url][/b] and many more advance features in their own applications.Thu, 23 May 2013 02:45:02 GMTaspose_seohttp://www.sqlservercentral.com/Forums/Topic1455585-150-1.aspxHi , I want to Display the Rowcount of each column in the Report footer ?Can anyone help on this please?Appreciate it !ThanksWed, 22 May 2013 09:42:27 GMTdithahttp://www.sqlservercentral.com/Forums/Topic1450705-150-1.aspxHi. I need to track changes made to reports; when they were created, changed, deleted, moved to another folder in Report Manager, and so on. My first thought was to use Change Data Capture on the ReportServer database, but I can't tell which tables in there store reports or on which tables to capture change data and how to interpret what's in that database in general. Is CDC the best way to go? If so, can someone please help me understand what it needs to monitor? Or is there another approach that is better suited to accomplish this?ThanksWed, 08 May 2013 11:13:38 GMTpeter 82125http://www.sqlservercentral.com/Forums/Topic1008194-150-1.aspxHi Guys,Can anyone please respond to below interview questions, I need some understanding. I tried to google it but no-luck ?. 1. Difference between Logical Page an Physical Page in SSRS.2. How to configure SSRS for Disaster recovery.3. Describe the role of Encrpytion key in Report Server Configuration manager.4. User want only to display only pdf as export option in report Manager .. Describe Steps to perform this .5. Name and Describe few console utilities for SSRS.6. Name few Endpoints exposed by SSRs 2008.7. How can you access the Code in You report. Describe the Static and intance based method with example.8. how to add custome Assemblies to Report.9. What is Linked Report.10. What are different types of roles provided by SSRS.11. Describe different Processing Modes offered by SSRS.12. When to Use Null Data driven Subscription?13. What Factors need to take into consideration while desigining a international report ( Localaization ).14. What are different option to deploy report from Dev to Prod.15. What are the new Controls / Features added in SSRS 2008 / SSRS 2008 R216. How can you monitor the report Usage.17. How can you add a new report User to report manager.18. How can you create the dynamaic Datasource. Can a Shared Datasource be Dynamic?19. A report is Performing poorly . What steps you would take to troubleshoot the Issue.20. Write an Expression to perform a Division of two Integers fields and to avoid NAN error.21. have you ever used Rank, Dense Rank Ntile, CTE and Pivot..22. Is SSRs 2008 dependent on IIS? if not how it perform the operations. thanksvenkiThu, 21 Oct 2010 00:16:16 GMTvenki_kumar7http://www.sqlservercentral.com/Forums/Topic1453495-150-1.aspxHi,Can anyone tell me what permissions I need to assign to a user to allow them to log into Reporting Services via management studio ? They need to be able to change reporting services server settings and manage jobs.In tests the only way I've been able to do this so far is by assigning local admin rights (tried a number of ways) - surely there must be a more restrictive way of doing this ?Any help much appreciated!CheersVultarThu, 16 May 2013 07:01:46 GMTvultarhttp://www.sqlservercentral.com/Forums/Topic1451897-150-1.aspxHi there,Anyone can tell me how to fix this table?I have a full range of data - breakdown by product, then test, then by failure type.I am trying to make a table by failure type - as per attached picture.As you can see there are percentage on the table. At the end of the table column "Trend", I want to put up the percentage graph, but I have problem because I only can total up the failure at each column and not able to get the total tested data. Do I have anyway to get the total value there?[img]https://plus.google.com/u/0/?tab=iX&gpsrc=gplp0&partnerid=gplp0#103122025681124668442/posts[/img]Thanks!Sun, 12 May 2013 04:22:35 GMTyun83http://www.sqlservercentral.com/Forums/Topic1340938-150-1.aspxHow i can display two values in same label.but i want to show second value in bracket().i am using this expression =round(Fields!MegaBytes.Value,0).ToString() & " " & (round(Fields!MBPerSub.Value,0).ToString())it is giving me proper result.but second value(MBpersub) is not diplaying in bracket().for e.g: 400 (55555).Mon, 06 Aug 2012 16:47:16 GMTweston_086http://www.sqlservercentral.com/Forums/Topic1453357-150-1.aspxFolks,Can anyone see what's wrong with the following? It's been bugging me for ages as I can't see any problem withit.=First(Fields("gradient_colour" & Fields!Response.Value).Value, "uspGetReportSettings")This is setting the background colour of a textbox. The value in the text box is percentage from the dataset "feedbackResults", Response is a column from that dataset. uspReportSettings is a generic sp that returns all the report settings in a single row. In this instance, Response returns 5 and when I call:=First(Fields("gradient_colour5", "uspGetReportSettings")It works fine.Thu, 16 May 2013 01:55:41 GMTTim Fosterhttp://www.sqlservercentral.com/Forums/Topic1453647-150-1.aspxGood Morning Guys,Would it be possible if i have An MVC ASP.NET Web Interface and Generate A Report(Either To Excel Or PDF or word) and Have It Generate the Report Through My Web Interface( not in the Report Manager?)what tools do i need to make this work?any kind of help is very much appreciated.Best Regards,NoelThu, 16 May 2013 10:02:04 GMTStylezhttp://www.sqlservercentral.com/Forums/Topic1453839-150-1.aspxChecking the security audit log on my reporting services box indicates that all connections are being made via NTLM. I need connections to be made via kerberos because I have integrated security data sources that point to other boxes. I've done this many times in 2005, 2008, 2008R2 and 2012, and I am going crazy trying to figure out what's wrong.I have:A sql server box called MySqlServerreporting services service running as mydomain\myaccountreporting services databases on a sql instance called MySqlServer\myInstance running as mydomain\myaccount (same account, I doubt this is relevant anyway)mydomain\myaccount is trusted for delegationsys.dm_exec_connections shows that connections to MySqlServer\myInstance are using kerberos.setspn -l mydomain\myaccount includes the following output:[code]http/MySqlServer.mydomain.com.auhttp/MySqlServermssqlsvc/MySqlServer.mydomain.com.au:mystaticportmssqlsvc/MySqlServer:mystaticport[/code]rsreportserver.config authentication is configured as follows:[code]<Authentication> <AuthenticationTypes> <RSWindowsNegotiate /> </AuthenticationTypes> <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel> <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario> <EnableAuthPersistence>true</EnableAuthPersistence></Authentication>[/code]I have restarted the reporting services service several times now. I simply cannot get a kerberos connection. But as far as I know, the above covers everything required for kerberos to be used. Anyone know of *anything* else that could be coming into play, no matter how crazy it may sound? Duplicate SPNs, something to do with subnets, datacenters, air speed of a fully laden swallow...Thu, 16 May 2013 22:23:15 GMTDon Halloranhttp://www.sqlservercentral.com/Forums/Topic1453157-150-1.aspxHello,I would like to have an SSRS report export data to Excel every two hours and add the data to the next column. The data is based on two fields, Closed and Open. The report will total the number of each when it is run. I would like to dynamically export these totals to a column in an Excel spreadsheet and two hours later the report will export the data at that point and put it in the next column and so on. I could set up a subscription in MS System Center Service Manager. I was wondering if anybody has done this before? Thank you for all your help!Wed, 15 May 2013 08:56:37 GMTrobert693http://www.sqlservercentral.com/Forums/Topic1453192-150-1.aspxI want to change links on one report to open in a new window. I have read enough to know that using the LinkTarget="_blank" syntax somewhere is part of the solution, but nothing I have tried is working. Can anyone help me understand where to set this option?I have tried to put it in the URL of the report I'm working with by manually typing it after the report URL after opening the report. Even after refreshing the report with it in the URL, links still open in the same window.I have tried to put it in the URL of the link that is in the Action property of the report item.I don't know where else to put it, but clearly I'm not putting it in the right place for it to work.Wed, 15 May 2013 09:45:40 GMTgeoff5http://www.sqlservercentral.com/Forums/Topic1451881-150-1.aspxHello,We are using SSRS 2005 and I have a report I want to give access to 5 different managers the report will be in a separate folders by department this report is a budget report. I don't want to change the sql query for each department individually and copy into the respective folders I would have ssrs 2005 recognize the department by folder and only give the data to the respective department manager. Is this possible? Thank you in advance.Sat, 11 May 2013 21:49:51 GMTalex_martinezhttp://www.sqlservercentral.com/Forums/Topic691062-150-1.aspxHi experts,Is it possible to remove 'select a Value' from dropdown in report manager?.I set the default value for parameter from queryI attached the screen shot of my parameter settings. kindly look in to that picture and give me a solutionMon, 06 Apr 2009 08:27:19 GMTArunkumar S Phttp://www.sqlservercentral.com/Forums/Topic1452466-150-1.aspxHiI have created a DSN (using sybse db) and develop report in SSRS 2008R2. Reports working fine in BIDS. Now I have uploaded RDL in Report Manager. Create a ODBC DataSource in Report Manager.I am getting below error messageAn error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'dsTransaction'. (rsErrorOpeningConnection)ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedAttached screnshot for reference.Please guide to to create a DSN DataSource in SSRS Manager.Do I have any permission issues in report server?--Thanks & Regards Jayanta SarkarTue, 14 May 2013 03:47:12 GMTjayanta.sarkar01http://www.sqlservercentral.com/Forums/Topic1453193-150-1.aspxWe just upgraded SSRS 2005 to SSRS 2012. We have reports that contain a page break on grouping. Since the upgrade, when we export to Excel each group is displayed on a separate Excel Tab. I modified the Config file to make Excel 2003 format available, but the report still creates multiple tabs on export to Excel. Is there another change that I need to make?Wed, 15 May 2013 09:47:14 GMTcathy.bakerhttp://www.sqlservercentral.com/Forums/Topic1452743-150-1.aspxHello,I'm trying to create a data driven subscription on Sharepoint site and I want use Delivery type as Email. But I don't see that option there. Can someone please help? Do I need to enable any option or configure email somewhere?Tue, 14 May 2013 11:37:06 GMTSri - SQLhttp://www.sqlservercentral.com/Forums/Topic675791-150-1.aspxHey all, We are currently in the process of upgrading our systems and migrating reporting services subscriptions also becomes a part of it.The current scenario is that we are moving from SQL Server 2005 to SQL Server 2008 and we will have to migrate the subscriptions which run into thousands .Is there a way or a tool that could enable us to do the same ? All i could find out was the RS Scripter ,but i am not sure will that be effective while migrating it to 2008.Kindly give in ur suggestions on this ..Fri, 13 Mar 2009 23:44:03 GMTsiby.s.josephhttp://www.sqlservercentral.com/Forums/Topic1452118-150-1.aspxIs there a matrix documenting browser support for SSRS 2008 R2 Report Manager? I am able to find the matrix for the ReportViewer web server control but not able to find it for Report Manager on MSDN.Thanks for the help!ShalluMon, 13 May 2013 08:05:00 GMTshallu_bhagathttp://www.sqlservercentral.com/Forums/Topic1452365-150-1.aspxI'm somewhat of a newbie to SSRS, but more apt with SQL Server (SSMS). The queries I've built run fine in SSMS, but I'm now seeing delays in SSRS now that the report is all built.I'm trying to pinpoint where the rendering errors are coming from (also working with our sys admins to get to the execution log tables) because it's taking forever to run or will give me various rendering errors.One thought I had is that maybe because I have my row labels and main dataset not in the right place or something? This is how this report is currently laid out: Current Month dataset (main dataset in tablix properties) | FYTD dataset || Row Labels | Prior Month dataset | Rolling 12-Month datasetThe double-line || represents where the separator is between the row groups are and the body; however, I do not have any groups setup.Will any of this cause a problem when rendering? When I switched the row labels to the left side and the main tablix dataset to the right side, it didn't seem to help performance so still stuck. I know there could be several other reasons.Thanks in advance for your help!Mon, 13 May 2013 17:22:42 GMTrarasconhttp://www.sqlservercentral.com/Forums/Topic1452296-150-1.aspxIs it possible to have a generic drillthrough report that can give me contact information about any list of EmployeeIDs coming from any number of aggregate reports. Let's say I have a bunch of reports that generally return the details of EmployeeIDs along with variables such as Department, Gender, Ethnicity, Organization, etc. These main reports can aggregate the details various ways. I would like to somehow pass the details of the EmployeeIDs that make up the aggregate, rather than having to recreate the complicated SQL in each of the main reports. I know how drlilthrough works with a single value and then get details for that single value. In this case, I want to get different details about the Employees that make up an aggregate, so there is no single value I will be looking up in the drillthrough report.One idea I had was the idea of somehow storing those detail records in a separate table with a report id and then the generic drillthrough could read that table for the employeeids. But I cannot think of a way to store the details of the particular table cell that would be selected.Biology Dept 55 Male 23 Female 32For instance, I would like to be able to have the drillthrough report get results for only the 23 males in Biology. The main report already has run the dataset to get those details, so I just want to pass those 23 to the drill report. It seems the only thing I can do is recreate the main SQL and add parameters for the dept and gender, but I would like a generic drill through, rather than a separate drill through report for each aggregate report.Is this possible in any way?Mon, 13 May 2013 13:40:28 GMTmikeg13http://www.sqlservercentral.com/Forums/Topic1450100-150-1.aspxHello,Can you please help me to solve following error for DD Subscription:While running the subscription it shows the status on browser as Processing: 0 processed of 1 total; 0 errors.Log details:httpruntime!ReportManager_0-39!3fc8!05/07/2013-11:27:11:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.AppDomainUnloadedException: Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014) at System.StubHelpers.StubHelpers.GetCOMHRExceptionObject(Int32 hr, IntPtr pFrame, Object pThis) at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn) at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)library!ReportManager_0-39!3fc8!05/07/2013-11:27:11:: e ERROR: Throwing microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse.,Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-39-130123889993312881. ---> System.AppDomainUnloadedException: Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014) at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush) at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush) --- End of inner exception stack trace ---;library!WindowsService_24!14ec!05/07/2013-11:27:15:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.emailextension!WindowsService_24!14ec!05/07/2013-11:27:15:: e ERROR: Error sending email. System.Runtime.InteropServices.COMException (0x80040213): The transport failed to connect to the server. at ReportingServicesCDOInterop.MessageClass.Send() at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification) notification!WindowsService_24!14ec!05/07/2013-11:27:15:: e ERROR: Error occured processing subscription cde3ed53-93fe-4080-8994-cf5b235ab67c: Failure sending mail: The transport failed to connect to the server.Tue, 07 May 2013 06:44:38 GMTamit_pjoshihttp://www.sqlservercentral.com/Forums/Topic1449351-150-1.aspxHello,I'd appreciate if you guys help me with my problem in a matrix. In the following SSRS 2008 matrix, notice I have a Row named FieldName, and only one field in the Data area named Value. My question is: Let's say we have Field 1, Field 2, and Field 3, and in the "Total" area of Field 3, I want to display the result of a division of Field1/Field2. How can this be done?[img]http://s23.postimg.org/ed62ri58r/Clipboard01.png[/img]Fri, 03 May 2013 13:52:00 GMTgiontechhttp://www.sqlservercentral.com/Forums/Topic1451929-150-1.aspxHiI have create a ODBC connection for Sybase Db and Develop my RDL file. Its working fine when I am executing in local db.Now I wants to Upload the RDL in Report Manager. I am facing problem when I wants to create a ODBC DataSource in Report Manager (SSRS 2008R2).In DataSourceType: Selected ODBCIn Connection String: What I needs to mention. Can anybody please explain me in details.I needs to implement it, I have done few rnd but no such environment available in personal to test and confirm.What I understood is in Connection string: I can mention the xxxxxxxx text from my RDS (created for ODBC - sybase connection) xml output file <ConnectString>Data Source=xxxxxxxxxx</ConnectString>Please correct me.Thanks in advanceJayantaSun, 12 May 2013 13:48:58 GMTjayanta.sarkar01http://www.sqlservercentral.com/Forums/Topic1451234-150-1.aspxI am trying to evaluate whether we could get away with ReportBuilder V1 (because our server is SQL 2008) or whether we should upgrade to SQL Server 2012, hence ReportBuilder v3.I tried a very simple report based on a model I generated out of our datamart.I just tried (and failed!) to sum some values without any criteria.It looks like ReportBuilder V1 returns the distinct values instead of the SUM! :ermm:I tried to use both "# MyValue" and "Total MyValue" but got the same result. :crying:I then did the same experiment with ReportBuilder V3 and it worked fine...Based on that simple test, it looks like I should not approach ReportBuilder V1! :-)Has anyone some advice on this?Many ThanksThu, 09 May 2013 10:02:24 GMTEric Mamethttp://www.sqlservercentral.com/Forums/Topic1450682-150-1.aspxHi Members,I have a SSRS report which displays a field value based on a expression. The expression uses left function. The expression is =left(UCase(Trim(Fields!xxxx.Value)),30). It displays 30 characters properly on the report viewer on report manager on DEV environment. We have deployed the same report to UAT environment. The same report after deployment on UAT is not working as it supposed to. It doesn't display all the 30 characters. It looks like it's truncating the data. For some records it shows only 17 characters and for some records it shows 14 characters so this behavior is unpredictable. We are using SQL Server 2008 R2 on both the machines. Same thing is happening with another expression =trim(mid(UCase(Trim(Fields!xxxx.Value)),31,60))Any pointers are greatly appreciated.Thanks for your help in advance!!!!Wed, 08 May 2013 10:26:59 GMTalladizhttp://www.sqlservercentral.com/Forums/Topic1451292-150-1.aspxGood day all, Hope this post finds you all well. I'm a new RS user and have a question regarding line charts and % values. I'm going to try to explain this as simple as possible using the image below. I'm trying to convert the total value into a % value, not sure if that's possible. thanks for your help. [img]http://rickygzz.com/RS/RS.jpg[/img]Thu, 09 May 2013 12:24:00 GMTrigonzalezhttp://www.sqlservercentral.com/Forums/Topic1451201-150-1.aspxI need to create a report. I have data in one table that represents street ranges. Example.from to street category100 200 Adams CFMH300 400 Smith CFHMThere are numeroous ranges in the table above but I need to use the category code CFMH I then have a second table that has historical information that referenced these ranges. Examplestreetno street123 Adams245 Adams333 SmithI need to pull the historical data based on the ranges.Thanks,BillThu, 09 May 2013 09:35:40 GMTWilliam Gary Wrighthttp://www.sqlservercentral.com/Forums/Topic1449597-150-1.aspxNeed quick help on this issue. Environment Details:Reporting server migrated from 2005 to 2012.But we haven't migrated rdls and these reports are being viewed via reportviewer 8.0 version (2005). IIS 7.0 ( hosting environment has 8.0 & 11.0 dlls for report viewer)The reports are loading properly when limited values passed as parameter. When multiple parameters are passed (i.e. complete hierarchy tree selection), report is rendered as expected with 740 pages. But when user clicks on next page of report viewer control, we are getting "Invalid URI: URI is too long" error.As per suggestions on other blogs added settings to Report Server web.config. But it didn't worked for me.<add key="aspnet:IgnoreFormActionAttribute" value="true" /><add key="aspnet:MaxHttpCollectionKeys" value="100000" />Report Server Log Files Details:library!ReportServer_0-2!6e0!05/03/2013-00:44:35:: i INFO: Using folder C:\Program Files\Microsoft SQL Server\MSRS11.REPORTS\Reporting Services\RSTempFiles for temporary files.library!ReportServer_0-2!6e0!05/03/2013-00:44:41:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: Internal error, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.UriFormatException: Invalid URI: The Uri string is too long. at System.Uri.EscapeString(String input, Int32 start, Int32 end, Char[] dest, Int32& destPos, Boolean isUriString, Char force1, Char force2, Char rsvd) at System.Uri.EscapeDataString(String stringToEscape) at Microsoft.ReportingServices.Common.UrlUtil.UrlEncode(String input) at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.UrlEncodeSingleParam(StringBuilder url, String name, Object val, Func`2 cs) at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.ToUrl(Boolean skipInternalParameters, Func`2 cs) at Microsoft.ReportingServices.Library.ReportExecutionBase.WriteParametersToJobContext(RunningJobContext jobContext) at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace ---;library!ReportServer_0-2!6e0!05/03/2013-00:44:43:: i INFO: Dump result: External dump process return code 0x20000001.External dump process returned no errors..webserver!ReportServer_0-2!6e0!05/03/2013-00:44:43:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.UriFormatException: Invalid URI: The Uri string is too long. at System.Uri.EscapeString(String input, Int32 start, Int32 end, Char[] dest, Int32& destPos, Boolean isUriString, Char force1, Char force2, Char rsvd) at System.Uri.EscapeDataString(String stringToEscape) at Microsoft.ReportingServices.Common.UrlUtil.UrlEncode(String input) at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.UrlEncodeSingleParam(StringBuilder url, String name, Object val, Func`2 cs) at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.ToUrl(Boolean skipInternalParameters, Func`2 cs) at Microsoft.ReportingServices.Library.ReportExecutionBase.WriteParametersToJobContext(RunningJobContext jobContext) at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport() at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution() at Microsoft.ReportingServices.Library.RenderReportAction.Render() at Microsoft.ReportingServices.Library.StreamRequestHandler.RenderReport(SessionfulClientRequest sessionManager) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(SessionfulClientRequest sessionManager) at Microsoft.ReportingServices.Library.StreamRequestHandler.PerformStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.Library.StreamRequestHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.Library.StreamRequestHandler.ExecuteCommand() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()==========================If you need any more inputs please reply me on nbethi@gmail.comMon, 06 May 2013 00:44:57 GMTnbethihttp://www.sqlservercentral.com/Forums/Topic1450935-150-1.aspxHii have a tooltiip which is as follows:[b]="Current Age = " & DateDiff("yyyy",Fields!Dob_dte.Value,Now()) & " : DOB = " & Fields!Dob_dte.Value[/b]EXAMPLE OF Fields!Dob_dte.Value = [i]'1943-05-24 00:00:00.000'[/i]When viewing the tooltip in the report the DOB part shows as [b]MM/DD/YYYY [/b]format. How can i get the Dob_dte.Value to show in the format of [b]DD/MM/YYYY [/b]within the tooltip Thanks in advanceThu, 09 May 2013 02:40:02 GMTLoosinMaMindhttp://www.sqlservercentral.com/Forums/Topic1450639-150-1.aspxHi geniuses!I want to create a Project Portfolio report.Do u guys have ever created a similar report?Any idea of what it should contain?Thanks in advance.Wed, 08 May 2013 09:13:16 GMTdavdam8http://www.sqlservercentral.com/Forums/Topic562311-150-1.aspxCan someone tell me if there is a bug/issue with the SSRS built in function MonthNameThe following expression in the header of my report returns an error on the True Part, but not on the false partIIF(Parameters!THE_MONTH.Value = 100," Year " , cstr(monthname(Parameters!THE_MONTH.Value)))Basically i have a drill through report based on Months but with a total for which i pass the month in as 100Tue, 02 Sep 2008 05:08:53 GMTbrunmhttp://www.sqlservercentral.com/Forums/Topic1241708-150-1.aspxGood afternoon, I have a report that if I exported to PDF would be in excess of 10 pages. Due to a limitation, I need to export to TIFF. Is there a way to export to multiple pages in a TIFF? It seems to only render 1 page. ThanksWed, 25 Jan 2012 12:26:41 GMTmbrady5http://www.sqlservercentral.com/Forums/Topic1449844-150-1.aspxHi,I got my sp TO WORK.. FINANLLY...Now I wanted to schedule the report to run and email in XML format....I want the remove some of below and change the name of the tags from say Detail_Name to NameThanks<?xml version="1.0" encoding="utf-8" ?> - <Report xsi:schemaLocation="XML_test http://ucrpt01/ReportServer?%2FTest%2FXML_test&rs%3AFormat=XML&rs%3ASnapshot%3Aisnull=True&rc%3ASchema=True" Name="XML_test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="XML_test"> <table1 /> </Report>Mon, 06 May 2013 12:50:22 GMTjbalbohttp://www.sqlservercentral.com/Forums/Topic768876-150-1.aspxI have a table that I need to sort by multiple values and am not having much luck. Is is possible to use the "In" expression in a table?Field: =Fields!XYZ.valueOperator: INValue: ?????When I only use 1 value (123456) the filter works. However when I add multiple values, no results are displayed.I have tried the following values-(123456,456789)-123456,56789-"123456","56789"-'123456','56789'PLEASE HELPTue, 11 Aug 2009 12:30:36 GMTdfrey