So there have been a lot of people complaining the SP1 removed the (Select All) feature and that SP2 would put it back and allow you to toggle it on or off. How do I toggle it on or off??? ...more >>

Hello Everyone, I get this Error msg on RS 2005 SP1 whenever I try to edit my Subscriptions, "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystem...more >>

I want to make something like this: TOP 3 Sellers! Seller Profits ----------------------------- Maggie 130 John 70 Mike 30 Others 200 ------------------------------- TOTAL 430 Showing the TOP 3 Seller...more >>

I created a new dataset for a new report that gets data from a stored procedure. But when I run the dataset in the Data tab, it only returns the column names with no data. The stored procedure runs fine in the Query Analyzer with several returned records. Any help will be appreciated!...more >>

How do you get remote errors to show on a different machine? We want to see what errors our dev machine is throwing when it does so we dont have to go through logs to try to find it.. I tried changing the customerrors to Off in web.config but didnt seem to fix the problem, what am I missing? t...more >>

Hi; i want to show the results of another dataset on my table's detail row, is there a way to link a table or a textbox to another datasource? TIA ...more >>

Hi, I have a report which can produce 220 pages if the user select "all" in my multiple choice list. if the user try to export this report the PDF file is corrupted. the same report with only a small amount of item selected instead-of the "all" (so around 1 to 20 pages) is correct. The e...more >>

Hello: I have a table, with a group that inserts group headers and details, each header expands or collapses its details, but I'll also like the users to be able to expand all the data with a single click. Is it possible to have an element toggled by two different ways? Any Ideas? Tha...more >>

I have been looking high and low and can't seem to find anything a little more detailed on the whole RS utility. What I'm looking for specifically is some type of programming reference. Also, I created a new VB project in VS2005, but yet when I write any code, Intellisense doesn't pick up a...more >>

In a report that has a table that contains a number field, how do you format the output to contain commas between thousands? ...more >>

Hi, Would anyone happen to know why I get the error "Cannot currently modify this text in the editor. Text is read only." when I tab out of a parameter field? The report I'm working on has two parameters. The first acts as a search box where the user can enter a text string to find items...more >>

I am using VS 2005 and have created serveral reports. They run fine and connect to a SQL2005 db via a datasource. The problem I've run into now is that I have one report that depending on the user needs to pull data from different databases. User A needs to run report 1 and have the ds poin...more >>

Does anybody have issues with Crystal leaving 'sleeping' connections in SQL Server even after closing the report and viewer? - ...more >>

We have a website which we have recently converted to VS2005. Our back end is SQL Server 2000 (all reports in Reporting Services). Does anybody know if SQL Server 2000 Reporting Services can be used with VS2005. They both work fine if on different servers but not if SQL Server and the website ...more >>

Hi all, I'm a newbie to Reporting Services so please forgive my ignorance... I've recently installed SQL Server Express 2005 with Reporting Services on my Vista Business Notebook (with no network connections) and have installed VS C# Express as well as the Business Intelligence Studio to c...more >>

I'm working on a RS report which is refreshed monthly, and where the users can filter the contents by entering parameter values at the top of the report. Moreover, I want to create links to this report from another report, where the appropriate parameter values are passed on to display the rele...more >>

After intalling SP2 and RS add-in when I try Grant Database Acces from Configure Reporting Services Integration I get "A new member could not be added to a local group because the member has the wrong account type". I am on a domain controller. Any ideas ? ...more >>

Hi there, I've got Reporting services is installed on server 1 and sql server & analysis services installed on server2. I've published my reports on server1. When i try to view my reports from report manager i get error msg "Can not create connection to data source". I've got four reports. ...more >>

Trying to set the names of worksheets that get created when rendering a report to excel. Report has two tables but I can't seem to find a property that changes the worksheet names which get generated...I don't want Sheet1, Sheet2. tia. JimJ...more >>

I have a matrix, I would like to have a subtotal and total that only performs the action if the dynamic collumn has a particular value. I have dynamic column A and B. I only want the subtotal for A not B. Bruce ...more >>

Can you make reports against a SQL Servers maintenace plans, DTS/SSIS jobs and logs in the event viewer? If so what database can I connect my datasource to my querry this information? Thanks steve archer Perot Systems ...more >>

Has anyone found a way to render a report to ascii text? When I say ascii text I don't mean CSV, I mean output the report into a text file with appropriately spaced headers, footers, columns, and LF's? I do have the option of creating a custom rendering extension, but that sounds like it may ...more >>

Is there an expression that can be placed in text box, within a table, that generates a sequential number which gets reset on every page? Assuming that the report was 2 pages long. Page 1 Seq# Description 1 line one 2 line two ..... Page 2 Seq# Descr...more >>

Maybe I am just not using the correct search strings, but it really appears that there is no server side validation available for parameters in Reporting Services generated reports? Is this true (so then I can stop looking)? Thanks for your help. -- Paul Web Developer...more >>

Is there a way to modify or suppress the "Report is being generated" text and image? I am trying to setup reports in the Report Viewer webpart on a Sharepoint site (Sharepoint 2007, SQL Server 2005 SP2, Reporting Services in Sharepoint integrated mode), but do not want the user to see that me...more >>

I've got an issue that is perhaps a bit different than any other related posting on this topic. I have successfully installed and configured SSRS for SQL 2005 and now I'm at the step where I need to require SSL. So I opened the Reporting Services Configuration, then selected Report Server Vir...more >>

Hello. I have a multi value parameter in my report. I want to know how can I display all of the selected values in this parameter in a text box. Whan I try to use this parameter in a textBox it automaticly take the value: Parameter.param.Value(0) Whice take only the first select value. Is t...more >>

Hi, I am using embeded image in my Report.But when it is exporting into Excel,i could not get any image. Am i missing anything?or is it not possible? Thanks in advance. Dibakar...more >>

Hi I am looking for an object model to learn how to access report items an conections (if available?) in code. Because the code window on report properties is THAT programmer-friendly I have no idea where to start accessing the items. Thanks. Markus ...more >>

Is it possible to base an expression on whether a group is expanded or = not? =20 I want to show totals in the header, unless the group is expanded. In = that case, I want to show totals in the footer. This would have to be dynamic, but i don't know if you have that kind of = access to the...more >>

Hello: I need to display a column in a table with FirstName and LastName added together, but I don't want the textbox to grow or do any word wrap. Just want to show what fits in the space. When I set the "CanGrow" property to false it looks good on the preview, but after publishing on the s...more >>

I have a single Win2k3 server that was running SQL2000, SQL Reporting Services 2000, and Windows SharePoint Services 2. I upgraded the WSS2 to WSS3. When I try to navigate to http://myserver/Reports I get an error "Server Error in /Reports Application". With the error message Unrecognized at...more >>

Hi, We have SSRS 2005 shared/ consolidated environment for DEV and production. On few occassions, we noticed that some users render large reports in Excel which causes poor performance for other users and few times, it caused the report server to crash. We had to manually restart IIS to work a...more >>

I have removed Reporting Service from SQL2005. Now, I want to install it again. The setup does not give me this option. What should I do to re-install reporting services again? Thank you ...more >>

When I go out to Reports I can see the reports but when you click on them all yo get is the properties tab and they will not render. If I go out the the Reportsserver they will run fine. Is there a reason why they will not give me the option to render? ...more >>

hello All, This questione pertains to Sql server 2005 reporting services. Is there a way to browse through each record in the dataset and also make changes if required before it is rendered on the report?...more >>

Hi, I got a problem accessing the database from within the deployed report. The report works perfectly well within my IDE (VS 2005 v8.0.5x) but when I deploy it to the Report Server (SQL Server 2005, v 9.00.1399) no access to the database can be established; the field containg the value shows ...more >>

Hi, We want to add an extra checksum parameter to our RS report, and make the report work only if the correct checksum is entered/passed based on all the other parameter fields, as a simple security check when rendering reports from a system with its own security system (users not in AD/dom...more >>

Here's hoping On the properties tab, Border Style, one of the line options is a double line, if one chooses this option, the report only shows single lines does anyone know how to get the double line to show. Excuse the finance type request. ...more >>

Hi all, I'm quite new to Reporting Services, expecially for the Reporting component. I have created a report using Business Intelligence Studio (Visual Studio), Vista Business, and upon deploying the report, I get the error message: "The permissions granted to user 'JOEBLOGGS\Joe' are insuf...more >>

I'm producing a report to be printed onto labels, and so am using the columns feature in the layout. I have a list around my textboxes displaying the data, and another list surrounding this with a grouping and a page-break at the end of the group. However the page-break is actually being ren...more >>

Hi, When I launch a report using the following url, and then make changes to the report and save it, Reportbuilder is creating another report with the same name but also including the .rdl within the name itself.. therfore I now have two reports now displayed within the report manager ...more >>

Authentication via internet explorer fails when connecting to reporting services from a hostname other then the NETBIOS name. for example my servers name is BOB so if i do http://bob/ReportServer it works fine I have an A record that points reportingservices.mydomain.com to BOB's ip add...more >>

Hi, I have several reports ( .rdl) that I created using report designer, how can I let the end user make modifications to the text in some of these reports. As I am unable to use Report Builder to modify reports ( .rdl ) created with Report designer, what are my options. is there a way I c...more >>

Hi all. Goal: report showing me for each category, the change in number or percentage compared to the same category. I will try to explain it: I have a SQL that returns something like MyValue | Category | Date 63.61 Cat1 2006-11-30 00:00:00.000 65.51 Cat1 2006-12-07 00:0...more >>

Mine works with the following: file:\\server\share folder\xxxxxx.gif EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

I have 2 datasets. One contains the information for the report and the other contains a list of available companies. In the report parameter area I have the company as a parameter and 'from query' selected. When the report runs, the user is prompted to 'Select a Company' from a drop dow...more >>

Hello: I have a dataset to return all the periods a user can select to create a report. My "period" query returns three fields, the period name, ("Dec Month-End"), the period key (1234) and the period end date (12/31/2006). I want to display the period name as the parameter label and the p...more >>

I am working with the web service here, is there any way to get a list back of all the current reports being ran? thanks! ...more >>

I have Reporting Services 2005 wsp1, SQL Server 2005 version 9.00.2047. When I generate reports through Reports Admin interface and then export them to PDF, they come out ok. When I set up a subscription that is supposed to send a report in pdf format - I get the same report with around 50 bla...more >>

Hi, I have a couple of reports that I created within the SQL Report Designer, I would like to give the ability to the end user of C# Winform application to be able to make modification to this .rdl file using the Report Builder, however when I try and launch the report that I created withi...more >>

I have reports that have a drop down list to select a company parameter to print records for that company. I want to be able to leave it blank and print all companies. When I do that, it forces me to select a value. How can I get around this? Thank you David ...more >>

I'm creating a report where the user can enter a time window, say 6:00am = to 6:00pm. So I'm using a string input as the type. Is there a way to = validate what the user enters prior to running the report? Thanks. J...more >>

I have several VS 2003 BI projects using SQL Server 2000 reporting services. I am now using VS 2005, but the organization has not yet converted to SQL Server 2005 and may not in the immediate future (not my call). Attempts to open the VS2003 BI projects in VS 2005 result in error "The appl...more >>

Hi everyone, I am creating few reports in which i show data in a group. And this data is filtered on the condition that the SUM(column2) >= 0. And I have SUM(Column2) in the table footer. I expected to see in the footer only the GrandTotal of the data thats displayed in the table but to my ...more >>

The stored procedure takes less than a second to run and the report takes over 3 minutes to render. If I modified the report to use sql query text, the report is generated very fast. Both reports use SQL authentication. The reporting service and database server are in the same machine. It app...more >>

I have a report that uses a table format. It is subtotaled at 2 levels. Unfortunately, the total often appears on the page following it's detail grouping. The user is not happy with this. I have tried the "keep together" property on the table and this does not work. Upon further research ...more >>

I have a report created using MDX imported from another application. In order to provide flexibility, this MDX carries in several fields that are not necessarily used when the report is created. (The report prompts for parameters which determine whether it should be created using budget or ...more >>

Hi, Can someone help me identifying a way to hide blank pages in Reporting services 2000. Thanks....more >>

I want to filter reports based on a users active directory security i.e. what parameters they can select, what columns they can see But I can't figure out the best way of doing this and the documentation on AD seems to assume that the user already understands AD. From what I can tell I hav...more >>

After installing SP2, when i try to run a report ! Thanks 'RSReportHost.exe' (gestito): 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll' caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione 'Just My Code' del debugger è attivata. 'RSRep...more >>

I'm seeing performance issues in adding users to folders. It works fine only when the folder has 100 or less roles assigned. If that folder has more than 100 users with roles assignment, then adding another user thru roles assignment fails with a time out issue. I need to add 150 individual do...more >>

hi, In matrix row and column grouping there is one property "Group Header should remain visible while Scrolling",which is equal to Freeze panes property of Excel. But when i am exporting the report into Excel i am not getting the same effect of Static Header.I have to manually set it to get ...more >>

Hello, Does anyone know a report builder for ASP.NET, other than crystal reports. I need a report builder that can take only an SQL query and generate the report without the need to have designed it earlier. Thanks, ...more >>

I need to generate and save a report to disk from a standard Windows Application without user intervention. So basically, a user clicks a button, and a report is saved to his c:\ in a predefined format and with a predefined filename. Anyone? J. Jespersen ...more >>

im working on a report which shows the data based on the users input. I have used a matrix because I have no control on how many fields the users want, so practically we have a dynamic column here. My problem is that they require me to able the user to hide the columns he/she wishes to during run...more >>

I've developed a couple of reports using SQL Server 2005 Reporting Services. However, the parameters interface doesn't suite my requirements, i need to design a custom screen where users can specify the criteria for the data (parameters). How can i do the above using .NET? (I need to do anw...more >>

Hi I have a report with 3 tables. The all get their data from the same dataset, but they filter on to colums so they dont display the same rows. The 3 tables do not show the same colums, and I would like to sort the report by a column shown in the table, and have the report sorted when it i...more >>

I developed some reports on one system that I would like to move to another system. I copied the rdl file to the new system and uploaded it via Report Manager. The data source the report uses is based upon SQL views which I created on the new server. I'm having a problem with the data ...more >>

Hi; is there a way to acelerate the printing on a dot matrix printer?, right now is awfully slow!!!! TIA ...more >>

Hi, I have several reports within my c# winform application, I need to be able to give the user the ability to make minor modifications to some of these reports prior to running them. Currently I am making use of both .rdl and ..rdlc reports within my application. the modifications that t...more >>

I have a custom interface which creates parameters from the RS SOAP API and then submits a form containing the parameters back to RS for processing. All works fine in that respect. I have an issue that if I choose a multi value parameter, set the parameter to have valid values and pass a...more >>

Perhaps this is just behavior in the dev environment, but if I provide = default values for all of my paramters, the report runs automatically = when I switch to preview. Is there a way to provide defaults, but still require the user to click = view before the report runs? Thanks....more >>

Within report design mode, I can see the DataSet, but I can't tell if this was created using a Shared Data Source or was it created before I created and started using a Shared Data Source. I have a problem publishing reports that used the Shared Data Source. Now I want to check and see how I ...more >>

hi! is there a way to print the username in a report? TIA ...more >>

In Microsoft Project Server, RTF notes are stored in the field TASK_NOTES_RTF as a SQL Server image datatype. I am trying to display the RTF note on a SQL 2000 Reporting Services report. I need either assembly code or embed code examples. Thanks ...more >>

Hi, Is there a way to take 2 sql records from a data set and combine them on one detail line. My data set looks like sales lane store_no week year 9930.04 2 C196 50 2006 7276.24 3 C196 50 2006 In reporting services I want to have a table that shows store, lane2 sales, lane3 sales, week,...more >>

Is there a way to purposly throw an error when exporting to excel? What I'm wanting is a way for reports to show up correctly in the browser, but when users right click and export to excel, it will throw an error or display garbled. I posted a question early today regarding disabling right...more >>

We are having problems printing Reports, where the font for the fields are set to "C39HrP24DhTt" (barcode). While viewing the report it displays as Barcodes but while printing, the Barcode does not get printed, but the string gets printed. Environment: SSRS 2005 Using the ReportViewer Control...more >>

We created a report with 42 parameters in it. While in VS, it previewed fine. Then in our preferred browser Firefox, it rendered fine as well. Only after we had to test different platforms did we realize that it did not work in IE 6 or 7, using our interface, or even the MS Report web interfa...more >>

Hi, I'm creating a report that is fed from stored procedure. Now I want to pass as a parameter to the procedure a couple of values from database. How can I add another dataset to report? If under parameter tab I choce values from existing dataset I'm getting error 'The report parameter 'Client'...more >>

Is there anyway to disable mouse right click events in Reporting Services Reports? I am using RS 2005. On custom web pages, I can either use javascript/vbscript or set oncontextmenu="return false". How can I accomplish the same results using Reporting Services? I've been searching and ...more >>

I have 2 drop down lists in my report. When you select an item from the 1st list, the 2nd list gets populated accordingly. For some records in list 1 you get only a single record in the 2nd drop down. In these cases, you don't see the item in the drop downlist, but I tried checking in the sour...more >>

I am creating a report that uses a list control and have the break at end of list. This does not work on all pages. I have some sections that spill over to another page. This would not be a problem if the list control would insert a page break prior to starting the next section. Also, it seems...more >>

Using Reporting Services 2005 with SSAS 2005 I have a report working with some parameters. In queries for the parameters some default values were calculated. E.g. the current date. Then these values were used as input to create mdx statements. Parameters!kdjfaj.value When watching what is ha...more >>

Hi, I have a matrix report. When users click on a column header, a new report opens, showing another matrix report based on the selected column. My problem is, that for each secondary report, I need to filter on a different set of columns. I.e. The first report consists of columns: Col...more >>

Help , RS2000, i have a dataset with fiedls : info, month, qty i create a matrix with dynamic columns based on month, row field = info, content of intersection row/colum is a function =sum(qty) , plus total on row and column How to obtain alternate color for better read on each col...more >>

Hi all Wanting to create a report with a table inside another table. I've set = the dataset for each table to the relevant datasources. However when I = try set textboxes of the inner table to fields from dataset of the ineer = table, I get the following error message. The value expression...more >>