Is there a way to add an interactive button to a rendered report that would expand all of the detail and clicking it again would collapse all of the detail. I'm a newbie at Reporting Services. I thought this would be nice to have since i could essentially have detail and summary reports in o...more >>

Hello everybody, I have problem to make a simple line report: My Query's dataset: select VALUE_IND, DATE_IND from uc.TB_INDI as TI, uc.TB_DEF_IND as TDI where TDI.LIB_DEF_IND = @param1 and TDI.NO_DEF_IND = TI.NO_DEF_IND and TI.NO_PRJ = @param2 The result of this query is (from my test ...more >>

I have a custom web app that will allow clients to launch a SQL RS report. I'm trying to work out the details of how we will pass parameters into the report from the ASP.Net web app. Essentially, I don't want users to be able to alter the parameters to the report as they will be generated...more >>

I saw a demo of a report using interactive sorting about a week ago. I can not figure out though how to get this feature in my report. I believe the video was of Brian Welcker?? Does anyone have any advice on how todo this? I am running a W2K3 Server and RS with all the latest SP's. Thanks...more >>

I am a new RS user. I cut my teeth developing MS Access Reports. In RS, how does one indicate whether the subreport can grow or shrink depending on the number of records in the Subreport. On my new RS reports, the subreport always shrinks depending on the number of records. I want the Subr...more >>

Does anyone know how to create a line on the X axis manually? I've got a graph that has a ton of points on the x axis but I'd like to automatically create a mark on the x axis every 100 records. Thanks....more >>

My report has 5 tables that are populated from 5 different datasets and each table is seperated by a page break so that they get exported to different worksheets in excel. My question is.....is it possible to create a link/bookmark that can jump from one table to another in the same report an...more >>

We are experiencing an issue with the search function from the html report viewer control. When the find is used on a specific item, the search will execute and the focus of the report will change to the first instance of the the item, but It will not highlight it. The parameter bar itse...more >>

I have a stacked barchart with point labels applied. For some time periods some of the values are zero. When this occurs, the zero lables stack up at the bottom of the chart and appear very unattractive. Is there a way I can conditionally format the point labels so that they only show if gr...more >>

I have searched this site and the internet but can not find and article or discussion related to a means of scheduling the execution of a report and have the report programmatically printed. Does anyone else have such a need and how have they approached such a solution? TIA Ron ...more >>

Hi I am exporting the r.s. reports to pdf fomat.I am viewing the report in Adobe Reader 7.0.I get the error as "file is damaged and could not be repaired" I am dumping the report bytes in browser like this Response.ContentType = "application/pdf" Response.BinaryWri...more >>

I would like to use my own subscription setup screens, but am having a little trouble. I basically need to be able to grab a report and schedule it. As far as I can tell, I think I only need the following tables: ReportServer.dbo.Schedule, ReportServer.dbo.Subscriptions, ReportServer.dbo.R...more >>

How does Reporting Services assign graph colors? Is it by value? Is it random? Is it by category? I have 3 graphs and I want to create one legend for all the graphs manually using a table....more >>

I have a line chart with an x-axis of dates. When I enable "time-scaled values" on the x-axis of the chart properties, I get this warning and the chart does not graph the data properly. "The sorting applied to the category grouping of the chart ‘chart2’ is different from the grou...more >>

Why is it not possible for me to create a static table in Reporting services? I have a table that will be making some calls to a custom assembly, but it requires NO database queries to build itself. When i leave the "dataset" area blank, the report will not compile. Is it really impossib...more >>

Hello EveryBody, I am designing report using report designer...I have defined two dataset.. First Dataset is just returning all the Category(i.e select CategoryName from Category) and in the second dataset i am passing that CategoryName to get all the products belongs to that category... S...more >>

Kyle! ...more >>

I just setup sql server reporting services. I developed a couple of reports in my development machine and they work fine. I install SQL Server Reporting services on the server and the database is on a different server. That seems to be working fine. Now, I deployed my reports to the web se...more >>

Hi, I have an image in a report. (Set to External, Url is set to http://localhost/JB/images/name.gif). When I try to display the report in HTML or PDF, the image is not shown. All my webs are set to intergrated security. In the IIS log I see, that the report server tries to access the ima...more >>

how can I show datetime in military (24hr) time?...more >>

Those of us barcoding and 'special fonting' (including Arial Narrow) would love to hear that RS 2005 will support embedded fonts in PDF files. ...more >>

I would like to know if I can read text from a text file uploaded as a resource file, simply by using an expression - this would help me with a small-scale localization issue. I want each folder to have a file such as State.txt, with content of (for example) "Indiana". Other folders would have...more >>

I have a lengthly report that by business design uses the report webservice and HTMLFragment mode. Using the report toolbar is not an option. I would like to have a "bookmark toc" near the top of the report to jump to bookmarks lower in the document. However, like others have found, the b...more >>

Hey guys, does anybody know where I can find info about the planned release date for RS 2005 and what new features it will have? We're currently building an app that will have to grow over the next two years or so and I'd like to take future features into consideration (possible switch-over...more >>

Hi, With SQL Server 2000 and Reporting Services, I'd have to have an additional SQL Server license if I wanted to run Reporting Services on a server other the database server. I don't want to run Reporting Services on the same machine as SQL Server as I'm not so crazy about running IIS and ...more >>

HI, I am running Excel 2000 with RS. I have created a report and when I right click on the report and select 'Print With', 'Excel', the contents of the excel file are all machine code and does not contain anything from the report? How do you export to excel? Thanks...more >>

I have been working on a program for quite some time that prints invoices programatically with reporting services rs.render. It was supposed to replace an old program that sent the invoices to a dot matrix printer. This one sends to two very fast hp laserprinters. Unfortunately, the rendering p...more >>

I'm creating a report that looks through detail records and want it to sum amounts based on a record type. If FieldType = 1 to sum accounts in a range otherwise to sum all records with that account. The result is an error [BC30201] Expression expected. The formula I have so far is: =iif(...more >>

Hi! I am having difficulties understanding the licensing agreement for sql server 2005 and reporting services. As far as I understand according to this page http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx Data Driven Subscriptions is not supported in the standard edition....more >>

Is it possible to mark a textbox in a report to not be exported to csv. This would be similar to the "Data Output" tab for textboxes - but for csv instead of xml?...more >>

How do we return the user name of the person requesting the report? -- -Kevin...more >>

Hi All, Can any1 let me know how to transfer from one report server to another?? I want to move my reports from one server to another... How to do it?? Thanks in Advance......more >>

Hi, I am trying to create simple parameter list that include members of some dimension with their root 'All ...' member. I want to accomplish list like this All Countries France Germany USA .... Simple MDX, but in Reporting services dataset I get <null> 1000 France 100 Germany 100 ...more >>

Hi, My reports are hosted on a secure website (SSL). Most of the pages appear just fine, but the 4 links in the top-right corner of the screen ("Home", "My Subscriptions", "Site Settings", "Help") are broken as they are referring to pages using http:// when of course they should be using http...more >>

How do you change the LinkTarget default from _self to _blank i Report Manager? I don't see how to change the report URLs in Repor Manager to include &rc:LinkTarget=_blank I am trying to jump to a URL from a report that will open a new windo and the report is running in Report Manager Any hel...more >>

A client's server has just crashed due to ReportingServices endlessly creating logfiles - 33Mb every 2-3 minutes - until the C drive filled up (5GB). Looking at the log, it seems RS got itself into some sort of endless loop - repeating the same 4 line messages continuously, as shown below. ...more >>

Hello, I have a report that works fine when the execution is set to use the most recent data, but fails when I want to create a snapshot. The symptoms are that after hitting the apply button a logon window pops up 3 times, asking for my password again. After the third time it displays a "you...more >>