Hi, I am trying to render a report from a console application. The report takes a while to execute and so, the synchronous web service method, Render() returns a timeout error. I tried to use the Asynchronous alternative and I find that the code just hangs at the EndRender() function. I have...more >>

I have the following query in an access database that works just fine: SELECT [SALES ORDER].ACCOUNTMANAGER, [SALES ORDER].ORDERAMOUNT, Sum([SALES ORDER]![PRODREVENUE]+[SALES ORDER]![SVCREVENUE]+[SALES ORDER]![TRREVENUE]) AS TTLREV, Sum([SALES ORDER]![PRODMARGIN]+[SALES ORDER]![SVCMARGIN]+[SALES...more >>

Hi Guys I have an application which consists of a navigation bar and a frame. When a user selects a hyperlink on the navigation bar that particular report is displayed in the frame. Now these reports contains links through which the user can jump to some other report which is not present in t...more >>

Greetings all: I am in the process of re-writing multiple reports for a custom-developed enterprise system, of which all the current reports are based in Crystal Decisions. We are using Visual Studio 2003, and are running SSRS 2000, with planned upgrades to version 2005 on both. The problem I...more >>

Hi experts! I wrote a WebService which serves as datasource for the reports in Reporting Services. The WebMethod takes 1 string parameter. I created 2 corresponding parameters in the report (one report parameter and one dataset parameter). When I call the WebMethod by the browser and enter...more >>

I have a result set of consisting of names and addresses. each person at a particular address (1-n people) gets an identical groupid to group them in a "Family". My report lists each column, groupid, name, address, with one row for each person. I would like for it to group on the groupid, the...more >>

SSRS2005. There are several data sources and reports that were created during testing/learning, and I'd like to delete them. I can go to 127.0.0.1/reportserver and see them but can't delete them. Entries pointing to them are stored in the sqlserver database (catalog table) but I really don't wan...more >>

Hello, Is there a way to allow a multi-valued parameter to provide the default values from another parameter? I have done this successfully when using separate datasets, however within the same dataset, using only one selected parameter value I always receive the error: "The [Hierarchy] ...more >>

Hi, I have a simple report that displays several records having 2 fields, date field and Quantity field I ma,aged to alternate the colors of line (RosntBrown and black) bu I need also to display the max Qty in a color different of the other ones, how this can be achieved Thanks...more >>

Hi, I need to export 5 .rdl files to a single excel workbook file as different sheets. How to export them? I need to write .net code or what? If yes then how? Please guide me on that. TIA ...more >>

Hi I guess the SP1 MultiValue Parameter great disappearing Select All option has been done to death on this news group by now. That isn't exactly my problem but it's related. I've actually solved the basic problem, thanks to suggestions in Brian Welcker's blog (https://blogs.msdn.com...more >>

Hi! I have found a very strange issue with the reportviewer. The CanGrow property doesnt seem to work! This one of my tablecells: <TableCell> <ReportItems> <Textbox Name="textbox13"> <rd:DefaultName>textbox13</rd:DefaultName> ...more >>

Hi! Im working with VS2005 and I have created a winforms application that uses the reportviewer to show a report. I have a header with some text, a table which I populate from a datasource, and an image which I also need to populate from a datasource. The problem is that the image doesnt sh...more >>

I have a data set with some info - PK, Field1, Field2, Field3 etc. I need to dynamically display columns base don Field1, with Field 2 and Field 3 displaying once for each Field 1. The PK is the row. I figured this out easily enough with column groupings. My next step is to organize it in su...more >>

Hello. I am using Reporting Services 2000 and Microsoft Excel 2003 running on Windows XP Professional. I have a report that contains sales information that I am exporting to Excel. The first two lines of the report contain title information. They span all columns of the report. For example, th...more >>

Any word on when Reporting Services will work with IIS7/Vista? Joel Johnson ...more >>

I allow user to select database during running of my program. So, the program populate dataset for reportviewer just before call RefreshReport as follows: mObjAdaptor.Fill(Me.rep_DataSet.MyQuery) Me.ReportViewer1.LocalReport.SetParameters(mReportParameters) Me.ReportView...more >>

Hi all, I need to get 20 rows of data from the SQL Server DB to put in 20 Textboxes always one item of one row. It's about Text in various languages, so each language needs 20 textstrings. I don't want to call the Stored Procedure 20 times. So I thought in calling it one time, get the data o...more >>

In SQL Svr Mgmt Studio, the keyword "VARCHAR" does not turn blue as it does in '00 Query Analyzer. Is there some change in the datatype? Thx...more >>

Hello All, I am developing an application that queries a database for a large amount of data. The SQL server is not local so the time to query the data can take some time. Once I have the data locally, I send it to the ReportViewer to display. The ReportViewer then shows the "Processing" ...more >>

Hi, I am running SQL Server 2005 and Windows Vista Ultimate. I have a simple report with 2 textboxes on the layout: one for the title and one to display current execution time. Reports runs ok but when I try and change anything on report properties->execution (for instance to cache the...more >>

Hi There, I have this matrix report that shows sales for last couple of years and is grouping on 5 different regions and separate years on different columns, I want to calculate the % Sales for each region in another column. how do I accomplish this in Reporting Services? I think the static...more >>

I have read all the articles regarding this issue. I would like to implent an "select all" function in the multivalued prompt. The multivalued datavalues comes from a table. e.x. select label,value from basetable union select 'All' as label,'%' as value The user choice comes in the para...more >>

hai i have dropdown listbox i have seleect the (product id) and click the button error occur the same path first display the report but i select the value in dropdown list error occur error: The path of the item "/ReportProject3/TestReortForFunds & Program_ID = 2" is not valid. The path...more >>

Is anyone aware of a way (directly, otherwise, or even 3rd party) of making it so that you can scroll values inside of a chart control? For example, if I want to put employees along the Y axis, and sales across the X axis (horizontal bar chart), if I have around 100 employees, the data beco...more >>

I set a border and interactive sort action properties to columns in a report. When I render the report using a URL I lose those column header properties. Is there a URL command to pass those settings with the URL? (I'm using 'rs:Command=Render&rs:Format=HTML4.0' plus passing some params) For mo...more >>

Hi there, When I insert a table in a list and Click on preview i got this error: "The table 'table1' is in a list that has no group expressions defined for it. To use a data region in a list, the list must have group expressions. Regards Zahid ...more >>

Hi I successfully created a 2005 report server but not when I assess from internet explorer i cant see the reports we created, only SQL Reporting Serices Heading and HOME also my developers cant deploy to http:\\server\reportserver does any one know whats wrong, or whta the default permissio...more >>

Dear all, I have 2 server, Server_A is IIS, Server_B is Reporting Server(SQL2005). I create a web project under Server_A and drop a reportviewer on the default.aspx. I then enter the Server URL and Report path. And build the project. I can then browse the report without any problem if URL ...more >>

I've been developing reports in VS2005 using a database accessed by Microsoft ODBC's driver (to a Cache database). I've been testing by deploying the reports to a 2003 server running SS2005. Now I find out that the company doesn't have a license for SS2005, just a developer license. Does it matt...more >>

How does SSRS generate the page content? Any reading, sites that you can share? ...more >>

I have two datasets, each of which are pretty much exactly alike. Each dataset has a corresponding matrix on the report and thats all there is. When I run each query they work fine but when i preview the report I get the following: An error occurred during local report processing. An interna...more >>

I have created several reports using the Visual Studio 2005 tools. I would love to be able to organize my reports in subfolders. I can't seem to be able to do that. I can do it in Reporting services, however, whenever I update any reports and re-deploy them from within Visual Studio, it doe...more >>

Hi All, I would like to show pagefooter on first page only. I tried with Visibility -> Hidden = IIF(Globals!PageNumber=1,False,True) It succesfully hide but showing space on other pages. Please suggest any solution. Kind Regards Zahid ...more >>

Hi, The account of the person who set up this system has now been deleted...about a year after he left. I've managed to recreate a report and subscriptions and get rid of the problem. How is this managed correctly?? Does the creator effect the subscription at run time?? It seems to. I...more >>

Hello I have field in a table where the value will be the hyperlink in Jump to URL. The value in that field could be concatenated with several string and I want seperate hyperlinks. For example, if the field holds the value www.google.com,www.msn.com,www.yahoo.com I want 3 different h...more >>

Hi all, Can anybody tell me how to remove the space between report body and footer? Thanks - Munny ...more >>

Hi, I am writing a report to get information from one of my Sharepoint Services List. I am using Visual Studio.net 2005. I create a new Business Intelligence Report through the Wizard, create an XML dataset, point that to the Sharepoint Web Service (http://<myserver>/__vti_bin/lists.asmx). ...more >>

Hi I got a report than can grow depending on what information it gets. My problem is that When I have a large text for a textbox. Example of the problem: I have a few textgroups thats gonna be printed out on a pdf. On page 1 we start of with some adresses and stuff and in the middle of the pa...more >>

We have just upgraded out systems to use SQL 2005 and the new ReportViewer control within our applications. Whilst this works OK on most sites, one or two cannot render any reports, but get the cryptic message "Client found response content type of 'text/html; charset=utf-8', but expected '...more >>

Hi, Is there a way to link the Hidden-property of a Textbox on a Reporting Services Report to it's Value? When the Value is empty (""), then I want the TextBox be Hidden. In case you don't ide the Textbox, there is still white space taken. Now I have to check in every Hidden-property of...more >>

Hi, I have VS 2005 and SQL Server 2005 installed.How do i create reports using Reporting Services ?? I can't find any tab like " Reporting Services" under File | new | project . What should I do ?? ...more >>

I have a report with an imbedded SubReport. I have set up the subreport control to pass a parameter from the parent report to the subreport. However, I'm stuck trying to actually use that parameter within the subreport. This parameter will be used within a SQL statement in the dataset tab. ...more >>

Has anyone had success in getting a report to generate by using an SSIS package as it's data source? If so - can you share how you got it to work - a couple of us who are pretty able bodied can't seem to get it to work as Microsoft reports it should. ...more >>

Hi All, I have a report with one group. In the group footer there is a TextBox ( name: txtTotal) that displays a total dollar amount for that group. I would like to show a Grand Total dollar amount in the table footer of the report. So the Grand Total dollar amount would ideally be a sum of t...more >>

We have developed a custom security extension for SSRS 2005. It reads data from our SQL Server database to handle logins and authorization. We can login interactively using and things are processed as expected, including the ability to accept valid logins, reject invalid attempts and run rep...more >>

Hi, I have got a report which uses two different datasets that combined give me the required output. I am now required to combine the two datasets into a single data region and sequence it appropriately. Is there an easy way to do this within reporting services? The sources of the datasets ...more >>

I have a column used in my report that has values such as: 496.1000 These are money values and thus I require them to be in the format: 496.10 How do I get rid of the two extra zeroes? (my sql statement actually does it, but they still appear in reporting services for some reason) T...more >>

We have a process wherein the production DB is replicated to a server.subscriberA nightly and then a job processes the database for reporting services. Whenever the job fails we have to redo the process all over again. By the time we are finished it is already late in the day and our custome...more >>

Hello, I took over a report that someone else created. This report uses external assemblies in C# which I was able to figure out how they work. What I can't figure out is how the rows are grouped in this table in the report layout view. There are 2 rows that are used as page headers, and...more >>