I have a set of reports that use the graphically created dataset. In the = SelectCommand, I need to use "IN" in the where (SELECT FullName, = CheckInTime, CheckOutTime, Minutes FROM dbo.CheckIn Where Login IN = (@People) AND CheckInTime > @CheckIn AND CheckOutTime < @CheckOut). On the form, I ...more >>

How do you uninstall SQL 2k5 report service/server? THanks. ...more >>

Hi everyone, I am currently using SSRS 2000. I have a chart that shows everything that we have shipped by specific part number. The Y axis displays the quantity and X axis shows the date. Well, the X axis I grouped it by year then by month, so it can display Jan 04, Dec 05, Mar 07, etc. bu...more >>

Anyone thought of a clever way to create a proper outline format - for example using the results from a recursive hierarchy via the Level function? The recommended approach seems to be to use the left pad textbox attribute, setting it to a formula based on the indentation level desired (e.g.,...more >>

Hi! I has added this pack for MOSS2007 server but can't add Reporting Services web-part in any site. In the Site Collection Features don't available Report Server Integration Feature in the list. Anybody have information for resolving this issue? Thanks! Andrey....more >>

SSRS 2005. I merged two cells in a table. now want to paste into that cell but get: Microsoft Report Designer Cannot change part of a merged cell. Thanks for any help or information! ...more >>

I have been fighting with this error for a couple of days and am looking to see if there is any new information on how to get around this bogous error message. Using the wizard to build the report. I have hard coded in my values instead of using parameters, Then received the error message t...more >>

Can anyone let me know how I check which Service Pack I do have in SQL Server Reporting Services. The second problem is in the reporting services I can see all the pages but when I export in to PDF I can see proper page break, any idea what's the problem. Thanks ...more >>

Is it possible to use the textbox name as a reference in an expression or formula? Meaning, if I have a texbox called Textbox54 and I want it to equal the value from Textbox30 can this be done by simply saying =Textbox30 (or something similar)? I have 2 datasets in my project. 2 separate ...more >>

Hi Group, I'm using VS2003 / SQL2000 sp4 /WinXP sp2 and WinServer2003 I have a report with subreports with a structure similar to this: Report <List> ... <Subreport> <Table> <Row1> <Row2> <Row3> ...more >>

Hello, I am trying to retrieve pdf(s) from our server using a UNC path. I created a textbox with the value "=Fields!DisplayLink.Value". I coded my Action property with a constant to test to see how it works in "Jump to URL" \\RALEIGH\Purchase\179\1046\200710\17910461001070724.pdf and the p...more >>

I have a drilldown report where with 2 levels . It's expand/collapse fine when you view the report, but when you export the report to Excel, it no longer has the collapsable operation in the Excel. What i need to do to able to expand/collapse report in the Excel? Thanks....more >>

I have a table <ClearanceORDER> The Fields of interest are <ClearDate> , <ClearanceType>, <ClearanceOrderID> The Problem: When an order is Canceled (CNCL) or Change of address (COA) there is an entry in this table for it. The entry should look like this: ClearDate ClearanceType ...more >>

We have a SSRS report that needs to update a specific table in the SQL db it is using to let us know when an invoice has been printed, and we'd like to flag that specific invoice (or set of invoices). Is this possible? I had thought about creating a stored procedure that gets called that rea...more >>

Hi I need one urgent help. When Passing Date as aparameter to linked report from Parent report, the format of date is Automatically changing from dd/mm/yy to mm/dd/ yy. How to restrict it? What is the solution for it in SP or rdl? TIA. Puneet ...more >>

I am rendering a report from RS that has multiple tables. After each table I have it setup to have a page break. This causes each table to be written to a different sheet within the excel workbook. This is fine. What I would like to know is if there is a way to write the table name to the ...more >>

I've recently migrated to sql 2005 and I'm trying to find a solution to some new requests. I need to setup a system that process excel spreadsheet received by email. The sheets will contain data coming from veterinaries that - after an integration with centrally stored data - should trigger a ...more >>

I'm having a reportViewer inside an UpdatePanel, and this seems to cause problems. Anybody who has made this work? Please give me some sample-code if someone has a solution that works! ...more >>

Hello. I have googled for answers to this problem, but while finding posts that seemed similar to my problem no solution has been found. I have a report that contains a table header and footer. I want the header (the column headers) to appear on each page, and the footer (a totals row) to appe...more >>

Hi everyone! I have made a cube in Analysis Services Project, with "time elapsed measures": - the first one is "totaltime elapsed" and it is defined in th SQL Server database as DATETIME - the second one is a calculated measure: "totaltime elapsed" / number of calls. I can see that th...more >>

I switched my reports datasource and made sure the new query outputs the same fields. However i now get this error... Report item expression can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope I've checked everywhere to confirm...more >>

Hi, I have a background image I'm using as a form within my report. the problem is that I needed to reduce the resolution of the image to 96 dpi in order to work with it and line things up within the ssrs/vs2005 report editor. However because the image is only 96 dpi, it looks awful wh...more >>

I want to upload PDF and Excel files to the Report Server database. I would like to display them in a custom web application. When working with the ReportViewer control, I can easily show reports. I can't figure out the process on how to show a PDF to a user. In particular, if the user selec...more >>

Hi, I have to make a report that shows 2 tables one above the other. The both tables have grouping values, and I want in each page to display the both tables so I'm making a page break in each group/ table. The problem is that the both tables goes to separate pages...what I want is a full pa...more >>

Is there anyway to do a simple line chart that compares 5 fields? For example, X axis shows fieldA, fieldB, fieldC, etc where Y axis is the value. I'm having such a hard time with this, the report keeps wanting to take the Sum or Count (aggregate) of fields. The values don't need summed, the...more >>

In Excel we can freeze panes and split report data so that when you scroll over you don't loose focus of the groups on the leftmost pane. Can we do something like this in Report Manager? I want to be able to freeze my row groupings so that when the report is exported to Excel, the users won'...more >>

I am using a Reporting Services 2005 with the SP2. I want to select as default (Select All) row on the multivalue dropdown list, which is going to virtually select all my options on the dropdown list. Is there any way to accomplish that? Thanks a lot. ...more >>

When I try to open the report manager (SQL Server 2005), I get an error that says "Response is not well-formed XML - Error". This is the first time that I have see this error, has anyone else seen it? Any idea about how to fix it? I tried deleting the Report and Report Server directories in...more >>

Calculation bind to a hierarchy. I have a report that shows values bind to a geograpich hierarchy dimension: [Cube Dim Geographic].[Location].[Country Description].&[Sverige].&[Norr].&[1. Insjön] I want to set the only SalesChannelId from a parameter and not the whole hierarchy. Is it ...more >>

Hi all, I am representing some data in a SSRS table. This data is grouped, and I hide the details with the visibility attribute that is triggered by some field. This works fine. I also added interactive sort on some columns and limited them to the current scope. However, each time I sort, ...more >>

Summary - Subscription cannot be created for reports using an xml datasource when running in sharepoint integrated mode . Details - I am using SQL 2005 with RS running in MOSS integrated mode. One of the reports uses a MOSS web service as it's data source. It runs fine when the datasource r...more >>

I have a quick question. I want to restrict the Start Date parameter should be greater than or equal to 01/01/1900, right now If a user input the start date i.e 01/01/1000 the report blown out and gave error. Is there any coding or any other way I can restrict the Reporting Service Data Par...more >>

I have a report with 2 parameters, that are part of a hierarchy, that I want to delete. I delete the query parameter via the designer and the query mapping dialog and then the report parameters. When I build I get an error saying the the query parameter I have deleted cannot find the the delet...more >>

Hi, I am searching for a free tool to generate Barcodes in SQL Report Services. Has anyone an idea? Regards Otto ...more >>

Hi everyone, Im currently using SSRS 2000. I have a report that pulls data since 2001. I used Datepart('m", Fields!Shipped_Date.Value) to break it down into months. It works except that it doesnt separate the year. It'll group all of january together but 2001,2002,2003, etc, together. Then w...more >>

Hello I have a report server running on a win2003 sp1 domain controller. The reportServer database is sql2005 sp2 also running on the domain controller. Now I´m trying to configure a report. The reports datasource is a SqlServer 2000 database also running on the domain controller The con...more >>

Can we use GetExecutionInfo from a stored procedure? What information does GetExecutionInfo provide?...more >>

My Page Header contains a text control. It has the following datasource: =ReportItems!txtMyHiddenTitle.Value This works well and shows the content of MyHiddenTitle in the header of the first page - but thats where it stops. None of the subsequent pages display the value. Seems odd. It works for...more >>

Re: Report joining data from Oracle and SQL Server Datasets? I've got a table on an Oracle 9i and another on SQL Server 2005. Any way to join them into a report using SSRS? ...more >>

Currently, when I create a new subscription, my Network ID is automatically put into the To box of the Report Delivery Options form. Is there any way to change this so that the actual email address of the user is put into this field? TIA Dean ...more >>

Is it possible to publish reports in a project to different target folders? It seem like all of the reports must be sent to the same folder and then moved, which is quite annoying. Am I missing something? TIA Dean ...more >>

I am trying to calculate a subtotal for a group in a report using embedded code. When the report runs it shows a 0 in the footer for the first grouping of records then the correct total for the first group shows in the footer for the next group of records. should be is showing 10...more >>

I have the usual report with date range parameters (from, to) that I have set up as datetime format so that users can get the fancy calendar applet. thats all fine and good. My problem is that I have creative users that like to hand enter all kinds of date values other than the expected <mm/dd...more >>

Hi, Does anyone know how to do this ? I need to create a multi-tier parameter entry screen for a reporting service project. For example, I have one dropdown box - the user selects an item and that Item will deterimine what is in a different list box, then the user can select multiple it...more >>

Hi -- We have SQL Server 2000 and I just found out that it comes with Reporting Services. How do I create reports? Thanks Rich ...more >>

*this was also posted on the web forum sql 2005 sp2 exchange 2003 sp2 i've got the report server setup to relay through the exchange server for delivering reports. all reports are exported to excel and emailed successfully with the exception of the largest report at about 16mb. the...more >>

Hi, I made some reports and I deployed them on my local report server. I want someone in the Intranet to be able to view them. I did set up the role to make the intranet group to be able to browse my reports. They can view the list of the report when they access it from http://server/Rep...more >>

I have scheduled the first report at this customers site to send out e-mails of reports. It is sending out the report just fine and including the PDF file that I requested however I also checked the Include Link box in the schedule because of the requirements of the users wanting to hide deta...more >>

Can anyone tell me where I can find the Web Part for SSRS Deep Integration as a Visual Studio Web Part Control that can be picked from within the Visual Studio Toolbox? Is there such a beast or do we need to recreate one using the ReportViewer Control? Is that feasible in fact? -- St...more >>

Hi, I installed a RS server (SQL 2005) without SSL. But, when I try to access the reports (http://192.168.2.1/reports) I get a redirect to a SSL page (https//192.168.2.1/reports). I checked the IIS configuration, no SSL option is selected. How can I disable the SSL redirection? Thanks in...more >>

Hi, Does any one know how to combine the data as one report (rdl) from accessing two data sources (ODBC) without using integration services? any extend method? as I know one rdl should be able to connect to one data source only. pleaae help & advise For example: SQL2005: source 1: mssql 2...more >>

Tribe, I'm struggling with the poorly implemented image handling in SSRS (which is represented through ASP.NET via Microsoft.Reporting.WebForms) First off, SSRS/Reporting team - External Images should mean exactly that. The report should express EXACTLY what I enter into the Value field fo...more >>

I have installed Report Services 2005 Developer Edition on a Vista machine, along with SQL Server Database Engine 2005 Developer Edition. I am not able to perform some functions, apparently due to permissions but I do not know what to do. When I open the Report Manager via Internet Explorer ...more >>

Hi We are using Reporting Services 2000 to view staff CRM activites (from CRM system). There is a Description fields that details the activity. The staff uses HTML emails which are also saved in the description field When we run the Reporting services report - we are getting the HTML ...more >>

How can i create a link to go back to the initial report when I have jumped to another report and have the initial report redisplay using the same parameters as had been choosen originally? TIA Dean ...more >>

How can you make a nested data region linked to the parent data region? According to the BOL it should be possible, but I can't figure out how to filter the nested dataset by the current row in the parent dataset. This is very confusing and I haven't found any examples or clear explanation on ...more >>

SSRS noob here. I'm on VS 2005. Two dumb questions: 1. is it possible to have sql inside the expression logic for a parameter? For example: select to_char(sysdate-30,'dd-MON-YY') from dual 2. If Not, Why on earth not? Why have to learn a new syntax? 3. and If Not, is there any way t...more >>

I have created a linked server on my SQL 2005 Server box. I have run test queries with no problem: select columnname from lnkserver...tablename where columnname = 'somename' Running same query in RS gives me: TITLE: Microsoft Report Designer ------------------------------ An error oc...more >>

Hi, I'm making a repport that shows data for a period of 4 Months. The repport make a page break per month. With the grids I don't have problems because I group the data in month, but I need to do the same with the charts. I want to show a chart in each page (one chart per month). There ...more >>

I am new to Reporting Service, I got the sample code, there is a method used to connect reporting service, http://servername/reports/ReportService2005.asmx, But i don't find ReportService2005.asmx. I chekced http://servername/reports/ folder ts is not there, how to get this file? Is ...more >>

I am looking for the actual interface that will allow me to interface with the SSRS Web Part from the Sharepoint Deep Integration suite. It appears that it needs a doclib interface, I guessed it was the IListProvder but now find it is not and not even IRowProvider. Can you / they tell me what ...more >>

Hi All, This is my first reporting services post (as I am pretty new to working with this new technology), so if I am unclear on anything or ignorant on anything please forgive me! Current Situation: ------------------------- I am exporting a report to PDF (in a Windows service). The pa...more >>