Let's say we have two (logical) sections within a report, one that displays a record from table_A and on the other one displays a Barchart based on the values fetched from table_B. Could we assign seperate queries (resultset) to above mentioned situation ? p.s. Right now, we are doing it throu...more >>

I've got a strange issue that has me scratching my head. I have a big report that is run on RS once every 24 hours and creates a snapshot so that is can be the front page on one of our intranet applications without getting executed more than once a day. So I I render in HTML. It seems like the ...more >>

I am trying to alter the color of a cell of a subtotal based on the value of the subtotal. Example: =IIF(Subtotal.Value < 20 ,"Brown","Blue") This doesn't work. How do I refer to the value of a subtotal inside an expression?? I think it has something to do with InScope(). I have definitely cli...more >>

Hi RS Support team, Have downloaded the RS2KSampleReports.zip and found that there is a small problem with the configuration of the table object in MDX_Expression.rdl. For example if you run the report for Vancouver the resultant report will be 21 pages long. The Product Category gets split over ...more >>

Is it possible to do the following in Reporting Services... In the query of the report have a column's critera be something along the lines of this: = ReportItem!Textbox25 In access it is possible through this syntax.. [Reports]![Report1]![Text5] Thanks ...more >>

I am logged on as a user with administrative privileges to my machine, yet when I go to the Report Manager, I have no tabs or Site Settings. How do I add the necessary privileges if I'm already the administrator?...more >>

Hi, I have a question on Reporting Services Security.Any help is greatly appreciated. we installed reporting services 2000 on Windows 2003 O/S. also applied SP1. Reprots are also deployed on this server. When we access report server or report manager. The following error is bein...more >>

If I have my header row set to "repeat on new page", is there a way to add the text "continued" to the header if the data has spilled over to the next page? I want to distinguish between the first time a group of data appears and when it is continuing on the next page. ie. Page 1: Janu...more >>

Hi, I linked the shared data source created in Report Manager to the report deployed to reporting services, but I'm having problem opening the report. The shared data source is setup as such: data source=[Database server];initial catalog=[Database name] However, I'm getting the following e...more >>

How would you set up a report item(text box or table cell) so that, when a navigation is configured for a hyperlink to a URL, after the user selects that link, on future visits to the page where they linked from, in at least the same session, the report item changes color? Thanks William Ku...more >>

The following problem is occuring when I try to access a table either via an oledb connection or via a linked server I can enter the query in the rs/text box and run it sucessfully. If I either goto edit the query via the query tool or select the data option. Visual Studio crashes. ...more >>

Hi: Is it possible to reference the background column in a cell on a table and apply it to another cells background? Thanks, ...more >>

Reporting services is throwing deadlock exceptions which if retried (up to 10 times) sometimes succeed. When those exceptions happen Reporting Services is coming to a halt waiting for the deadlock to resolve. Performance is unacceptably degraded then. In my test I am trying to run multiple concur...more >>

Hi Teros Just one question, is there any reason why CE and RS could be installed on the one machine, I have limited resources at hand, and I wish to prove my case for RS, however, I worried of corrupting my test installation of CE. Would there be any conflict errors? Kind Regards Rikes...more >>

Dear ALl, How to change dpi/resolutoin of the tiff being exported. Thank you Regards, Angus ...more >>

Is there any way to reference a Data Set field name dynamically in an expression? For example, I have 5 reports that have the same layout but reference different columns. For example, TextBox1 would be one of the following names depending on the report: =Fields!A_Total.Value =Fields!B_Tot...more >>

Is there any way to "configure" Reporting Services to render appropriately to *mobile* devices? ...more >>

URL : http://<Servername>/reports/ Error : The underlying connection was closed: Unable to connect to the remote server. OS Windows 2000 Server, ..Net 1.1 ASP.Net (not sure how to find version) I have VS 2000 and 2003 installed on this box I have tried reintalling RS twice.Searched this discu...more >>

Ok, this seems trivial, but I can not get RS to auto-grow/auto-shrink columns! I am using a matrix with 2 colum and 2 row elements. I have set the cangrow and canshrink properties of the cells to TRUE. However, it seems that column widths are being taking precedence. SO...how can I get t...more >>

Is there a way to insert a document (ex. word document) that can be downloaded from a website? Right now I have it passing parameters to pick a document and download it and open it from a link, but is there a way to show the document in the report?...more >>

Hello I would like to create a datasource (using the rs.exe utility and the actual *.rds file) in the same way reports (*.rdl) can be created, as described in this link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_9n79.asp. I know you ...more >>

Hello. I use VS.Net 2003 on my personal computer, and deloy to my web and SQL development server which has the VS server components installed. I can easily develop ASP.Net apps in this manner. However, I'm not sure how to install RS on my server and have the report designer be available in VS....more >>

I just attended a web cast for Reporting Services and heard (in Questions & Answers Sessions) that Reporting Services doesn't have any events ( Hope I heard it right ). I have following questions 1) In the absence of events, how do we do some of the common tasks that we normally accomplis...more >>

Hi, I want to set my group's background to different color. something like Group1 [Group1-A] [BGColor=Blue] [Group1-B] [BGColor=Green] [Group1-C] [BGColor=Red] Group2 [Group2-A] [BGColor=Blue] ...more >>

I have created a few reports which I have published to the reporting server. There is a group created something/Admins for example, that was assigned to some users. I have the entire folder that contains the reports in the manager set to allow browser previleges to view reports within. ...more >>

Using Report Manager (default viewer for Reporting Services) is possible to choose one parameter to be hide. This hide parameter has a default value and the user inform the others. thanks ...more >>

Hi, does anyone know if it's possible to dynamically create excel tabs/worksheets possibly via RS web service library or some other method. Thanks in advance, Jim...more >>

I have a report where the first column needs to be spanned over multiple rows. The first column is part of a group, just the group name is shown on the detail row with the details. The data looked like this: Group1 Detail 1 Group1 Detail 2 Group1 Detail 3 Group2 Detail 1 Group2 ...more >>

Feel silly asking it, but here it is: I am trying to create a bar chart that looks like the following: C L C CL CL C C CL CL CL CL CL CL CL ...more >>

Hi, I am new at reporting services and need help creating a flat file that will contain transaction logs like userid, amount, date and a comment line. I do not want the full report history since that would take a lot of space on the server. Is there such a way to create a flat file with plai...more >>

Hi there I was just wondering can I set BGcolor and color property to a value except the default color given in the list ? like color = 0047A1 Possible ?.. ...more >>

Is it possible to write out messages to the reporting server log files? If so, a sample code would be greatly appreciated. Thanks, Alex...more >>

Hi, I have set the Reporting WebServices WebService Directory Security in IIS to Windows Authentication. The authentication setting in the config file is set to "Windows" with Impersonation set to "true". I created an account called "RSAdminUser" with which to call the webservice. When ca...more >>

Hi, I need your help. I have report with subreport. Report has one information and if you click to one field I need subreport open and show another information. I created this report but the problem is User complain that he cannot go back to main report there is no back button inside html viewer...more >>

How could we export multiple Reports into a single PDF file, programatically ?...more >>

I'm using Reporting Service with Service Pack3 and I want to Apply my own stylesheet in reports. I want to give my own style class to Fonts, Headers etc. Can anyone help me ? Is it possible or not ?...more >>