Although MS says over and over that RS can be used via SOAP web services (not URL Access) with any SOAP-capable application to execute and return rendered reports, I've searched for hours trying to find even one example where a non-.NET application (like VB6 or Classic ASP) constructs a comple...more >>

I have data in rows that I want to display in columns based on a value in each row. Here's an example of the data: Employee ID Type Code Amount 123 PAY BONUS 1,000 123 PAY SALARY 5,0...more >>

I have two reports that I created, one using the wizard which simply has some Account Name, Parent Account and Opportunity Revenue. I'll call this the Report #1. I want a user to be able to click one of the Account Names and have it open a second report that lists details on the opportunity. I'l...more >>

Hello, I am trying to create a filter on the data used in a table. This table has NO other groups, is only one level, etc. Very simple. I get to the 'Filter' tab by right clicking on the detail row and selecting 'Edit Group', and chosing the 'Filter tab'. I have a DateTime field that I...more >>

Hello Everyone, I trying to build an SQL statement that includes the last twelve months in the report. When I use the DATEADD function ie >= DATEADD(MM, - 12, GETDATE())) the report brings back data 12 months from the current date. I would like to include the whole month not just the current ...more >>

I have 3 tables inside a list, all of which use the same dataset. The layout is something like this: List Table1 Table2 Table3 The List has a group defined on it, lets assume the grouped column is named Entity. What I want when the report renders is this: Table1 for Entity...more >>

I performed an install of SSRS and SharePoint as noted in this document... http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx ....with one exception I installed everything (SQL Se...more >>

I wish to reference the value in a subreport in a calculated field elsewhere... this subreport has one txtbox, no grid or any other objects. is this possible? what is the syntax...?? i.e. =mysubReport.mytxtbox.value.............. thanks ...more >>

I have a simple reporting services 2005 report with just a body section which contains a table control with the following rows table header (RepeatOnNewPage = false) group header (RepeatOnNewPage = true) detail group footer (RepeatOnNewPage = false) table footer (RepeatOnNewPage = f...more >>

After suggestions from this newsgroup, I would like to use URL access to render reports to PDF from my web application. My web application (classic ASP 3.0) is secured by custom authentification (not Windows auth) so no single page cannot be accessed without signing on first, and every single ...more >>

Hi, I noticed that Reporting Services is running every 20 sec a stored proc GetMyRunningJobs, and every 10 sec queries and updates in the Event and Notification tables in the ReportServer database. I suppose for subscriptions. Is there any way to desactivate this if no subscriptions are us...more >>

I am designing a report which need to take parameter input by user when the report is open. Can anyone please tell me how to do this? Using MS SQL 2005 report. Thanks. ...more >>

We are looking to place a job posting for a developer experienced in SSIS and SSRS. Are there any recommendations for the best place to post the job offer? thank you, Bob M.. ...more >>

I have a matrix report with subtotals on the end of each row. I want to put in brackets the percentage of the subtotal that each value is in the row. I am not sure how to do this. Does anyone have any ideas? ...more >>

I'm using the control on an asp.net page. The first parameter is a multi value field which is populated by a query. How can I programaicattly select the first value as a default? I don't see anything in ReportParameter class that can do that. Thanks, Gilgamesh ...more >>

OS: WIN2K3, SQL: 2005 Standard. SP2 - All installs On my production server, using the Reporting Services Configuration Manager I'm able to get Reporting service to work OK. I check this by opening a browser and going to http://<servername>/reports. My problem is that although Initialization...more >>

When I use URL Access to render a report with specified parameters and a format (e.g. PDF), when I choose "Save" (instead of Open) the default filename is listed as "ThisReportName.pdf". I need to have the "Save As" name to be very specific (e.g. include the date and the customer ID, like EN...more >>

I have a report that works well, but would like to run it for other databases. How would I go about this? Could I create some sort of parameter in the report to call upon a different db? Thanks, Ryan...more >>

we published some reports and want to give user access to these via report manager UI to Certain Folders. Is it possible to hide the header which display SQL Server Reporting Services, Home, My Subscriptions etc.? thx ...more >>

http://www.google.com/accounts/VE?service=groups2&c=CNHcx6iS7qrZ0AEQsYSqltP04cOtAQ&hl=en I have data like Return|Item Cancelled|Item [CFY] Gifts I would like to display if data has | then display it in two text box like Textbox1 Return Textbox2 Item if data does not have | then displ...more >>

Hi, We have a 2 node cluster and realized when we were testing failover that reporting services was not installed on our 2nd node. So I tried to run the SQL 2005 install and got the message "Edition Change Check - Warning. To change an existing instance of SQL 2005 to a different edition, y...more >>

I'm a newbie with SSRS and I'd like to place a customer's name in the Page Header section so that the customer's name (and ID number, and addresss) appear at the top of every page in the right upper corner. But when I try to put a field in the Page Header I get "Fields cannot be used in page h...more >>

In a report I have a table with 3 detail lines. The property 'keeptogether' is set to true. However, if I call the report in IE and then export it to pdf, the detail region can be splitted: The first detail line is at the end of a page and the next 2 lines (of the same record) are on the next ...more >>

hi all..I'm new here and got a problem, and i hope you guys can help me. My problems: I want to create one card , size : height =2.25, width =4.5 and it should be on 2 page because I want to make it front and back. i 'm using rectangle and textbox, and i set the page break after first rec...more >>

I currently use Crystal Reports RDC that is called from an ASP 3.0 page (actually, the ASP page calls my custom VB COM+ code which then calls then RDC), supplies a CustomerID as a parameter to generate a report (e.g. on one customer) that is then exported as a PDF file and saved to the filesys...more >>

I am trying to setup SQL Server 2000 Reporting services with an SSL connection. The SQL Server (Windows Server 2003 SP2 Standard) and Reporting Server (Windows Server 2003 R2 SP2 Standard) are on separate machines. I have tried setting up Certificates from both and Stand-Alone and Enterprise...more >>

I have a table with one GROUP row in it. It is supposed to show results of who is a preferred vendor vs non-preferred vendor, sales amounts for the group, and their percentage of the whole. It shuld look like this: Vendor Sales percentage Preferred $9,000.00...more >>

since the IIF statement evaluates both the true and false conditions regardless... I need to find a replacement to it... my code is: =IIF(Fields!SOURCE_TRANSACTION_KEY.Value = nothing, "", Fields! SOURCE_TRANSACTION_KEY.Value.TOSTRING.SUBSTRING(3, 2)) I get the #ERROR value in my report ...more >>

Anyone have any suggestions on how I can go about getting Reporting Services Reports(about 2000 pages) printed by a 3rd party printshop? PDF export etc...more >>

I'm new to reports so please bear with me. I'm attempting to embed a subreport which uses a parameter that should be passed from the main report. Both reports work fine individually, but when I attempt to run the one with the subreport, my subreport is blank. I read somewhere on-line someth...more >>

I have a dataset that is made up of timesheet entries. Each entry has an associated date. These timesheet entries form a project accounting report that shows how many hours were worked on the project and how many hours were billed. I would like to filter the report so that only the timesheet entries...more >>

have developed a report on a test windows server machine in SSRS 2005 which I can access from i./e. http://localhost/reports DataSourcce is accessed using a sql login My colleague on his machine can not access. His error is: An error has occurred during report processing. (rsProcessingAb...more >>

I was wondering .. Is there an easy way to enumerate all data sources and their configuration parameters (e.g. connection strings) in a reporting services database ? Thanks a bunch....more >>

My C#.NET 2.0 web application uses the ReportViewer control on a popup ASPX page for print previewing the user selected report. If the user then clicks the Print icon, it prints the first page of the report then pops up a dialog with "An error occured during printing. (0x8007F303)". This...more >>

Can anyone help me. I work in a workgroup environment as opposed to domain controlled. The minute I do anything with reporting services or analysis services that is between machines I get problems. I can't deploy to SSAS or SSRS from my machine unless I log into my machine with a username a...more >>

In my first table properties i have expression in visibility tab is this =iif(Parameters!PrNmValue(0)="A",false,true) and In my second table properties i have expression in visibility tab is this =iif(Parameters!PrNmValue(0)="B",false,true) So if i check in parameter 'A' then it will show me ...more >>

I have a Parameter with 2 non-queried choices, Yes and No. I set the default to No. When the report displays, instead of the default value displaying in the dropdown, the users are being forced to choose. any ideas what would cause this or how to fix? TIA dean ...more >>

I have been using Reporting Services 2000 for a couple of years with no issues. Now have verion 2005 installed and building some reports. I created a report that no longer want and when I went to delete it by "showing details", selecting the correct checkbox and clicking delete, I am prompted to...more >>

I am looking to create a a report that displays a value that has been saved to a database using a rich text box (Infragistics WebHtmlEditor). The database (SQL server) value is a string that contains HTML markup (ex: <strong>test</strong>). Is it possible for reporting services to parse this ...more >>

Hi I tried to export my report to Excel and PDF, it is exporting correctly. But it leaves a page opened, which was opened when I clicked on Export Link. How to close that page? Is there any setting available for it? Or else how to close it using C#.Net code? Any help is appriciated. T...more >>

I've been trying to create a project accounting report whereby for each project, I can see the project broken down into cost category classes and then cost categories. For each class (rollup of the categories) and category, the report should display the budgeted hours, budgeted fees, actual ho...more >>

Hi! My client wants to send reports as emails. They don't want' PDF attachement. HTML seem to be the best way for that. I'm using Microsoft.Reporting.WinForms and LocalReport.Render I can't seem to find any other formats then Excel or PDF. But Microsoft reporting does reports for web as...more >>

I keep getting these errorrs. I am using RS 2000. What does this mean and how do I fix this issue? 2007-09-25 11:00:25 - + [000] Schedule 143 has already been cached by job 0xF155CEC465AE154F8A73A19FB303190D 2007-09-25 11:01:02 - + [162] Internal request (from SetJobNextRunDate [reason: ...more >>

How can I hide a column in a matrix? I set the visibility of the column that I want hidden to True but it still reserves that space in the report. I want the hidden column to take up no space. Stephanie...more >>

I have a report server in domain ‘A’ that through a data driven subscription tries to write to a UNC in domain ‘B’. In ‘Step 4’ of the ‘Create a data driven subscription’ wizard, you are asked to provide a username and password. If I supply domain credentials from domain A (A...more >>

I am using using some code which Implements IReportServerCredentials (see the object below) to pass credentials to a non local report server. This works fine and my reportviewer can get it's report from a non local server. When the report uses Analysis Services it displays the parameters part...more >>

Guys, I have asp.net code in which I am calling report using ReportViewer control in VS2005. The problem is that when ever I click on the drill down in the report, the report page jumps and aligns itself to top of the window and because of this the tabs (in our application) disappear (hidde...more >>

I have had a great deal of success in the past on other systems with deploying reports... BUT now, to save my life, I haven't been able to get the first report to deploy. I get these errors: A connection could not be made to the report server http://###.###.##.###/reportserver. Additional i...more >>

Hi I have three parameters, First is a string, called DateFilter, with On and Off available values. Second and third are date, Start and End Date I want to grey out the Start and End Date filter if the DateFilter is OFF... Is this possible? How? Thanks in advance for your help~ ...more >>

does anyone know if it is possible to add a filter to a report that is passed as a user-defined parameter? i know i can do this by modifying the sql that generates the report, but i'd like to do this inside of the report so as to not hit the database each time the user selects a different fil...more >>