One of the RS2005 users is complaining that they are no longer able to export data to Excel. The problem is specific to just one report. Following is the error I am getting. w3wp!ui!8!7/21/2007-16:51:14:: Unhandled exception: System.Exception: An error occurred during rendering of the repor...more >>

Hello, I'm trying to read data from xml file (i want to use this file as enviornment config file). i tried 2 methods and failed in both of them: 1.a. I loaded the XML file to the report server 1.b. I wrote a custom code for reading the XML. i got #Error 2.a. I loaded the XML file to the repo...more >>

hello guys, I am making a report with first page having header data and footer while on the second page i have just some legal text. I have put this lagal text in a big rectangle inside the body of layout. when i get the preview , the first page displays correctly with header body and fo...more >>

I have 3 multi select report parameters on my report. Let's say a user selects only a few of the values in each of the report parameter drop downs but know they want to select all of the values with a click of option button. Then what I would like to do is have an option button that will allo...more >>

Just wondering if anyone would know why a report would work fine for around a week, running within 6-7 seconds, then suddenly take 25 minutes to run? Doing an update stats appears to cure the problem. The source database is loaded several times each day. Running the SQL statement directly in S...more >>

There has been quite a few posts about this appearing and disappearing when SP1 is applied, etc. I now have SP2 loaded and the "Select All" option appears in the dropdown. What I am wondering is, as of SP2, is there any way to disable the "Select All" option or are we stuck with it again? ...more >>

We are developing a reporting solution using SSRS 2005. All reports contain subreports and require a table of contents. The table of contents should appear at the beginning of the container report and should list all the sub reports and the page number that each subreport starts on. The SSR...more >>

Are you supposed to be able to save the Orientation of reports. It aint working for me. I have saved it in the designer but it's remembering it. TIA, Jarryd ...more >>

Hi, Query execution failed for data set<dataset name> Does anyone know why this error could be coming up? If I log in as a member of the Administrators group the report runs fine.If I run it as a user that I have given every permission to (Browser, Content Manager, etc.) I get the error...more >>

Hi, I have a requirement to generate single report which contains more than one individual reports. In my asp.net application, currently Iam using report server URL to render one report in my form. Below is the URL Iam using for one report http://servername/ReportServer/Pages/ReportViewer.as...more >>

Hi, how can I convert a word document into the RDL Format for Reporting Services. Is there a tool or an workaround ? Thanks Stefan...more >>

Hi Everyone, I am trying to hide a column in a matrix table. I have no trouble using conditional formatting to control the visibility of the column, but when I hide the column the main row in the matrix does not shrink. Therefore, I have a big gap... My thought was to use condi...more >>

is there a way to set the style of a report project in sql server 2005 reporting services? im getting really tired of having to change the fonts, colors, etc. for every new report i make. ...more >>

I have one report that contains three matrix controls. The first matrix is filled with data for the current month (June of 07 for example). I have a parameter dropdown listed with the months to select. The second matrix report is the year to date total which is all data up to the previous m...more >>

Hi, We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I click the print icon in SSRS, I get an Internet Explorer Security Warning asking if I want to install Microsoft SQL Server. When I click "Don't Install" I get the message, "Unable to load client print control." ...more >>

Hi guys, I have created a custom assembly that writes to the database in the report footer. I pass the Globals!ReportName and Globals!TotalPages parameters into my custom assembly which writes to the database and returns back Globals!TotalPages value. The method signature is: public int Inse...more >>

Here is the deal. We have a mapping table that stores basic info (like 4 columns). These columns are used to populate parameter boxes in a report (some parameters depend on the values of others and so we had to use a mapping table for performance increase). The mapping table is loaded hourly u...more >>

I have a main report with a list of people, and a subreport that has data about that person. How can I hide the person's name (the main report row) if the subreport has no data about that person? Thanks, Han ...more >>

Hello, I have a class in a .dll wich I instantiate in reporting services on the References tab. The instance is called "Myinstance". I also have a parameter called "parm1". >From custom code I have: Protected Overrides Sub OnInit() MyInstance.company(Parameters!parm1.value) End Sub ...more >>

Hi, after i install my reportingservice. i only can export the data to excel and pdf format. when i can enable the CSV format? any help will be highly appreciated thank you....more >>

Just wondering if anyone would know why a report would work fine for around a week, running within 6-7 seconds, then suddenly take 25 minutes to run? Doing an update stats appears to cure the problem. The source database is loaded several times each day. Running the SQL statement directly in S...more >>

Hi, When exporting my report to excel, the column widths change resulting in mis alignment, and certain columns being place on new pages, which is not very user friendly at all. Is there anyway that I can prevent this from happening? Thanks ...more >>

Hi, When I export my report to a pdf file, it is too wide, and some of the columns overflow to the following page. I have multiple tables on each page which results in my pdf file looking more like a dogs breakfast than a meaningful report. Is there anyway that I can prevent this from ha...more >>

Hi Group, As part of our efforts at best practices, we recently changed the default port of 1433 for the first instance of SQL on our SQL server another port say 8888. There is a firewall between the SQL server and the clients. The firewall rulebase was changed to allow traffic on port 8888...more >>

Hello. Whats the easiest way to add a column with a numeration to my table? I want the users to have an easier life finding on which row they are talking. I preffer of course doing it in reporting service and not adding a column in my dataset. Thanks. (its look like i have problems ...more >>

Hi, I've installed SQL server 2005 with both service packs on my std 2003 server. The application I'm using requires reporting services 2005 as well but I can't find it within SQL. Is it part of the SQL 2005 suite as I couldn't find it within the standard intstall? Do I need to install se...more >>

I have a main report which has a list of people, and a subreport with some data about each person. How do I hide that person's name (ie the main report row) if the subreport of that person does not contain any data? Thanks, Han ...more >>

Cannot seem to find the MS Admin Guide for SQL2005? Advise on links plz. Thanks ...more >>

the URL when the report is rendered. How can I do this? ...more >>

Hi Folks, Environment: VS 2005 I have created a MSRS 2005 Report with a matrix control which has Report Parameters. The user can pick the parameter values from the drop down and view the report by clicking the View report Button. Is it possible to refresh the report automatically everytim...more >>

Hello. Whats the easiest way to add a column with a numeration to my table? I want the users to have an easier life finding on which row they are talking. I preffer of course doing it in reporting service and not adding a column in my dataset. Thanks. ...more >>

Hello. Whats the easiest way to add a column with a numeration to my table? I want the users to have an easier life finding on which row they are talking. I preffer of course doing it in reporting service and not adding a column in my dataset. Thanks. ...more >>

Hi, I have a report layout that contains two tables. The page-break before and after properties are set to false for both tables, however, despite only having a single row of data in each, the second table will not display on the same page. I've tried setting the interactive page height ...more >>

On my new development machine, I have SQL Server 2005 Developer (with Reporting Services) installed as the default instance and SQL Server 2000 installed as a named instance. I was unable to install SQL Server 2000 Reporting Services and get both it, and 2005 RS to work, so I opted to just ke...more >>

I have a report that I'd like to involve in delivering tons of PDFs for each of our customers for a billing cycle. There is a table that the report reads from that gives it all its data necessary for the report (which is a customer bill) and the table also has a column that has the file name ...more >>

All of my subscriptions, old and new, will not run. They were working last week, and nothing should have changed that would affect subscriptions. The status stays set to "New Subscription" and nothing gets logged in the logs. I looked through the SQL Jobs and watched it as I made a new subsc...more >>

Hi, I'm making use of parameters to filter data in an report. But the parameters appear in fixed-width listboxes in the report. Some values of the parameters are longer than the width of the listboxes. My question is how to adjust the width of these parameter listboxes. Any ideas? Regards...more >>

Will SRS support passing parameters from the main report to the subreport which calls a stored proc that does not contain any parameters ? it will automatically filter the data without the where clause. I used to be able to do this in Crystal reports which I don't need to specify a where cl...more >>

Hi All, I hope someone can help me. I am wondering if there is anyway to use the WebService to Render Reports without the users password. I do nothave it and since we use TN Authenticationwe should nto need it. the issue is if I use the Default Crddentials on the Web Service it trys to r...more >>

I'm using DevStudio 2005 with Reporting Services and SQL Server 2005. I have a report with two parameters - @StoreID and @ParkName. @StoreID is a "non-queried" parameter with "Allow null value" checked. @ParkName is a "From query" parameter with "Allow null value" checked. "Null" is checked ...more >>

Does anyone have a way to set up a Subscription for the last day of the month? We've been changing reports so they only have data on the last day of the month, but the report also needs to run on demand and return data. There must be a way. Thanks, Mike ...more >>

1. What format should i use to change data from '32560' to this '32,560' ? 2. How can i pull data for previous 13 months? ...more >>

In my report i need to change format to E_Month field; from this data '200502' change format to this '02/2005'. How should i change that? Thank you....more >>

I've finally got the SSRS installed, configured, and working!!! Scenario: We're in an Extranet environment. The Extranet Sites (using WSS 2.0) are in our DMZ and are accessed by outside clients. The SSRS Web Services (SQL 2005 SP2a) have also been placed into the DMZ with SSL. The SSRS datab...more >>

I have created a single page letter using a number of text boxes and one table, which is populated with static text along with some data from a single row results set. This works perfectly when the results set only contains one row, but when there are multiple data rows, the report still only ...more >>

I have a matrix where the columns show the number of attained grades for a location along with a subtotal. Location A B C Passes London 2 4 5 11 Each grade has a number of points, eg A is worth 4 points, B 3 points etc. I need to add an extra subtotal column to ...more >>

I have designed a few reports in VS2005 with multi-parameter controls. When I view these reports in VS they look fine, however once deployed and viewed in the webbrowser (MS Internet Explorer) the drop-down boxes are too small (or the font size is too big). Is there a way to adjust (resize)...more >>

Hi, I'm getting this error when using the postbackurl property on a web form button to access a report via the url. I get the same result if I use a link button control also. The url is correct, as it works if I use a hyperlink control. It would seem that the handler code for both the butto...more >>

Hi! Is it somehow possible to create a configuration file for a reporting server project. Something similar like the web.config or app.config file in .NET applications? What I wanna do is to store the link of a picture file. I don't want to hard-code that in every report. Are there any ...more >>

I have implemented SQL reports a few week ago and everything has been running fine until last weekend. What we are experiencing is that ALL reports (even the small ones) are timing out, yet I can run them fine in report designer. We are running on a clustered web server install- I checked the...more >>

I have a Division parameter (select one or many) and I am grouping my Sales Goal row by Division with columns for months. I can show the running year to date total across the columns ok, but I can't figure out how to reset the running value when I get to a new Division grouping. It is adding t...more >>

I’m a bit of novice when it comes to creating report models using SSRS 2005 and it is my understanding that a data source and a data source view can be a SSAS 2005 database. I can create a data source off of the “Adventure Works DW” 2005 SSAS database but I can’t seem to create a vi...more >>

I've been developing some reports. I have a requirement for a summary report and a detail report. To create the summary report, I copied the detail report, and made it into a "drill-down" report. I now have two reports that are basically the same. I thought about just using the "drill-down" ...more >>

Hi, Just setup a SSRS 2005 in a 2 servers environment, one serves as report database server, the other is report server. Both are in the same domain. Windows service and web service are both configured to use the same domain account. Authentication mode is the default "integrated windows authen...more >>

I inadvertantly enabled the "Enable My Reports to support user-owned folders for publishing and running personalized reports." setting under Site Settings. Now I have a folder called "Users Reports" under the Home folder. Now I have disabled the My Reports feature but the Users Folders folder...more >>