I have a matrix with dynamic rows and columns. I got the totals for the Rows and Columns by right clicking the groups and selecting the SubTotal option. Can I display the totals in percentage. [Column1] [Columns2] [ Total] [C-Percent] [Row1] 1 2 ...more >>

I have a string parameter bound to a dataset that contains a "UNION Select '(All)' " statement to provide the user a way to return all values instead of just a single value. I have other integer parameters that use this exact syntax for filtering (ALL) and they work fine. The syntax looks ...more >>

I am trying to use the DATEDIFF function in a formula, but it isn't working. Here is the formula that I am entering into the "Define Formula" dialog box: DATEDIFF("day", TimeLogged, TimeClosed) When I click ok, it gives me the message, "The arguments to the following function are not valid...more >>

I am having this problem. Any thoughts? the standard way of opening a new window using the Jump To URL navigation feature - ie using the ="javascript:void(window.open('someURL'))" works great as long as the report containing these links is NOT in an IFRAME. If it is, it's treating the Javasc...more >>

I don't see a way to use the page settings from the RDLC Report, specifically to get it to print in Landscape. The PageHeight is set to 8.5in and the Width is set to 10in (for .5 in margins). I tried using the LocalReport.GetDefaultPageSettings, but this returns 8.5in X 11in, or Portrait m...more >>

I see the "lame" formula there in the editor for visibility. =Fields!routing_Number.Value That is the rows identifier. I want to compare the Fields!NumRows.Value for the two Fields!status.Value. Status could be "Cleared" or "Returned". In Pseudo code ( Sum(Fields!NumRows[0].Va...more >>

Hi, Was hoping to select a jump to report based upon the value of field. Is this not possible ? iif(Fields!ACATEGORY.Value="Receipts","Shop 2006 Inventory Analysis Detail Receipts Report","Shop 2006 Inventory Analysis Detail Consumption Report" ) keep getting ...... The specified...more >>

How to use Custom Function in Report Model? Please HELP !!!!!!!!!!! Thanks in Advance....more >>

I am currently creating a query wherein all of the records returned from an SQL Server table will have to be queried against an Oracle database. The following algorithm describes how I intend to do the report: * Get the start and end dates (report parameters) * Run the following SQL Server ...more >>

Hi, I have have a problem with the culture settings in reporting server 2005, which is different from 2000. My windows is in german, but I installed the english version of SSRS and VS.NET. So the report viewer is displayed in English. I have a public report parameter defined as date, wit...more >>

I want to run SQL 2005 SSRS on a SQL Server 2000. We have still not installed SQL 2005 in our company. Will SSRS 2005 work with a SQL 2000 Thanks Karen ...more >>

Hi, I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report to our reporting server I get the following error: "A connection could not be made to the report server http://sqlreportserver/ReportServer" I can browse to the Report Manager and view reports. I am also a...more >>

Hi Everyone, This problem is tying me in knots and I'd be very grateful for some help. I am to set up my reports to query a database for their datasources rather than using shared datasources. I am now able to retrieve the connection string perfectly well with this method. The trouble I ...more >>

I have a report where the information is not always filled in so I want to supppress the blank lines. For example if you have Address 1 and Address 2. If you do not have information in Address 2, I want the city, state and Zip to move up a line.. So if I have both Add1 and Add2 it would look li...more >>

I am trying to open a popwindow from the data field in a matrix using the url below. The pop-up window opens and displays the report but the parent window/report get "[object]" displayed on it. How can I keep this from happening? ="'javascript:void(window.open('http://dev1/ReportServer?%...more >>

After a long struggle, I was finally able to print out landscape (11x8.5) reports; however, when the report is displayed on screen, it's displayed as (approximately) 11x11. This really screws up page numbers--the number of pages on screen is less than the number of printed pages, so if someone i...more >>

Hello All, One of my clients is having an issue printing a report using the print button on the report viewer. The exact behavior: once the user presses the print button, nothing happens except showing a broken script error in the lower left-hand corner of the screen. When I click on the er...more >>

How do you go about uninstalling SQL 2005 Reporting Services? Do you have to uninstall the entire instance or can you just uninstall the Reporting Services components?...more >>

I have to RS servers (1 test, 1 prod). If I view a report from the TEST server I have a Printer Icon available and can print with no issues (therefore the activeX control [RSClientPrint] is installed and working correctly thru my browser). When accessing a report (same report) on my PROD s...more >>

I am having trouble exporting my SRS data to multiple Excel worksheets. I have four tables. I want each of these tables to appear on a different worksheet even if there is no data for it. For one of my queries, there was only data for 3 of these tables. First I selected "Insert a Page Break ...more >>

In my report, I have one group and details. The group has two rows, with the 2nd row's visibility toggled by one of the textboxes in the first row. The detail row is also toggled by the texbox in the top group row. (the second row of the group has the titles above the detail row). Anyways,...more >>

Hi All, We have to export our Reporting Services reports developed using Reporting Services 2005 RTM to CSV format. We are converting to ASCII Encoding and hence CSV export comes out good but we still have a flaw. We have some descriptive text in the textboxes above the table with data in t...more >>

I have an issue where one of the fields in my report concatenates to contents of the previous record into it - this is a limitation of the database where the data resides. I want to remove the duplicate data, and I want to find out if this can be done using RS or if I will need to write curs...more >>

Hello. I have a textbox in which I want to customize the color of the text. When you go to Properties->Color, the pull-down lets you choose from a pre-defined list of colors by name (Black, DimGray, Gray, etc.) You can also enter an expression. What I want to do is customize a color that is diff...more >>

I have a textbox where I am showing time as a result of T1 - T2. The result comes in hours, minuts, and seconds. How can I show it as nn hours, mm minutes and no seconds? Thanks...more >>

Can sombody send me instructions (screen shots of what this looks like) of how to get to Management Studio (refered in the instructions below) to do the following: Report server administrators have the option of disabling the print feature by setting the report server system property Enable...more >>

After I install SP1 of SP2 for reporting services, I get the following error: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.54'. The expected version is 'C.0.6.43'. To continue, update the version of the r...more >>

Hi, I am developing several reports, I want to pass one parameter from Report1 to Report2 and also make the same parameter selectable on Report2. However I figured out that if I pass the parameter from Report1 to Report2 and Report2 has the same report parameter, then the parameter bar on the t...more >>

Hi, Please Help........ Im having problem with report creation.I tried creating a report with the Stored Procedure and its gives me the following error. "An error occured while retriving parameters in the query DeriveParameters requires an open and available connection.The connections current...more >>

Hi, For one of my reports I should have a given field getting a Bold font, when another value in the DataSet = 0 (or whatever value). How can I set the Font/Bold-proeprty at runtime? Via an expression? Thanks a lot, Pieter ...more >>

Is it possible to restrict the ReportViewer export options to only a select few ? Thanks...more >>

I am using SSRS2000 and have 2 problems. 1. The values displayed in the legend are mostly hidden and are cut off mid word with '...' appended which makes it useless and most of the time the values are unreadable - can I correct this ? It doesn't seem to matter where I position the legend it...more >>

My company would like to write an app that does on-demand rendering of certain reports. Is there a .NET client report rendering library that is not dependent on IIS (as the SOAP/URL apis are), nor WinForms (as the ReportViewer is)? Thanks, Eva ...more >>

Hi everyone, I have an assembly deployed on my report server that contains a number of functions used by my reports. The assembly has full trust and all of the functions work fine except one. The purpose of this function is to query a database table for the correct connection string for...more >>

I have created Custom Assembly that I am using in the Reports that I created in Report Designer, it works and everybody is happy. Question is how can I use this same custom assembly in my SMDL, so that I can use this function in the DSV column defintion. Where can specify the Custom Assemb...more >>

Using SQL Server 2k5 Report Designer. When I run a report, how do I view the SQL generated by the report populated with parameters that is/was/will be sent to the server? Thanks ...more >>

I was able to create some T-SQL Stored Procedures, and call them from the Data tab in Reporting Services. All I did was type in the name of the stored procedure under the Data tab. This works great. I created a CLR Stored Procedure in Visual Studio by creating a database project, then a sto...more >>

Is it possible to STOP the linked report opening in a NEW windows? I embedded the reporting service in my web application. It opens the reports in the report holder, however it opens a NEW windows for the linked (drill through) report. Can I code the linked report so that it only opens in the ...more >>

Can I build an expression on a textbox with a "Sql Select" statement based on the dataset? There is a parameter user selected on the dropdown and it generates a dataset from the store procedure. This parameter is used on a subquery for this dataset in the store procedure and it will return wit...more >>

Hi, I am having a problem in Reporting Services 2005. I want to use report parameters as field names in a select statement, but the query just returns the value of the parameter. Ex. SELECT @pField1 FROM customers returns the actual string value of @pField1 I'm entering this query in t...more >>

Looking in the IIS logs I found that when a report is opened in IE it refreshes or there are entries in the logs every 9 minutes. I tried to change the auto refresh on a report from 0 to 3600, redeployed the report and it still refreshes every 9 minutes. The reports are run from an ASP.NET...more >>

Is it possible to have a query with a report parameter to be a query for another report paramter?...more >>

I have a datetime parameter. Also I have a listbox with available jobs to report for. I want to filter the listbox on the selected date. How can I do that? Thanks...more >>

We have a user that was entered into the domain incorrectly and added to reporting services with that name. The problem was corrected by changing the name in the domain and reporting services. The SID remains the same. Every day or so (I'm not sure exactly how often) the UserName in the Us...more >>

Hi, I have Score Field for each each month of the year like the following: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Goal 100 80 99 Score 99 100 89 - - - - - - - - - Form the database I hold the...more >>

I am developing an application with VS2005. We would also like to develop reports with this app. We will have SQL Server 2005 on a separate box as a development server. Is it possible to only install the report designer on my machine and not install the rest of SQL 2005? I have tried to only i...more >>

I am having problems with date formats in report manager. I am in the UK and want the dates displayed as dd/mm/yyyy. When I enetr the date in the parameter field it changes the month and day around and if I try to enter any number above 12 an erro is given. It ia also not picking up the cor...more >>

Hello. I have a report with parameters include multiple value. I configure "Jamp To Report" under navigation and I would like to forward to a new reports the same parameters user select in the source report undel multiple value parameters. in the text box I use =join(Parameters!Ds.Lab...more >>

Hi all, We have recently created a new deciated reporting server for reporting purposes to our outside customers. My problem is that whenever i try to connect from either the internet, or local to the Report Manager, the Report Manager such as https://secureserver.ourdomaincom/Reports respon...more >>

I have one report that is only ever printed on one specific printer. In MS Access we could specify a printer for a report so when the print button was clicked the report would automatically print to our special printer (or default to that printer). In Reporting Services I am not sure if th...more >>