I am trying to understand the basic security that RS uses. During install, a userid is used to install/create the databases. That userid is then tied to the basic services, like scheduling etc... Is this correct? Are all services using that first-supplied ID? After that when users run a...more >>

I am allowing users to create One-time Schedule's (via the Web Service API) with "Stop this schedule on" automatically being set to the next day. However, the Subscriptions list is never cleared for the report, even though the schedules are weeks past the stop date. This results in dozens of...more >>

How to render image in HTML reports? I have a webapp which invokes Reporting Services web service to generate reports in HTML format. The reports are for internet users - the image is not accessible to these internet users because they cannot access the report server directly which is in the...more >>

Does RS natively allow the application of Rights Management to reports as or once they are rendered, e.g. to a web site or into a pdf file? If not do you have any insight into how this can be done? Are there plans to integrate with RM?...more >>

I am trying to toggle the visibility of a simple bar by the value of a parameter named DETAIL. This is the expression used =IIF(Parameters!DETAIL.Value=true,false,true) When I view the report in .NET IDE it displays fine, when deployed to the target server I recieve the following error Re...more >>

Hello there, Ok, I did find some snipped of codes here and there however, I still haven’t been able to get it to work correctly. If it is true that people were able to overcome the jump out of Frame while drilling down when using a costume page and the ReportViewer component, could yo...more >>

Just starting to work my way through the Blackburn & Vaughn book to figure out RS. One thing I need to figure out though so that I can sell this thing to my boss: we have a SQL 2000 database that holds all of our study data. It looks like that makes us good on the licensing, and I was plann...more >>

I'll be quick and too the point... 1: I have a stacked area chart. 2: Percentages are the values being marked. Issue: I need to make the 100 mark (text and line) on the y-axis to be red. I've tried writing an expression to get at the current "label" for the mark. I keep getting the follow...more >>

How do I get the schedule for a subscription represented as a RecurrencePattern? I have the string representation ("2004-12-22T13:30:00.000-08:001TrueTrueTrueTrueTrueTrueTrue"), but I would prefer not to parse this. Thanks, David Ribb ...more >>

Good afternoon Is it possible to fetch the Report - Server Directory (and Items) - Structure programmaticaly in C-Sharp for the specific user? (to represent in a Menuetree) Can someone point me a possible way? thanks in advance wishes Ralph ...more >>

I created the sql below as a stored procedure that passes in the sql statement as a paramater. I replace the double-quotes with single quotes and then simply run the sql. I have to uses exec instead of select or else it doen't iniate the query. Why doesn't sql RS recognize the query? It run...more >>

I need to retrieve two values from the report, one is a number and the other is a character. Then depending on the value of the character value, I would need to return a value to one textbox and another value to another textbox. For example (sudo code for the Custom Code option): if accou...more >>

Hi! Is it possible to fill lisboxes dynamically? What I want to do is select a time frame from one listbox, say Year-Month, and pass a fieldname as a value to the query/stored proc that fills the second listbox. I know that it is possible to take a value from one listbox and use it in another one ...more >>

I have a report that uses a table where each data record is displayed using three table rows. When the report pages it sometimes breaks after the first or second row of the three. I would like to have the three rows always on the same page. I can not find a keep together property where I can b...more >>

Is there an option to include a 'data table' (to show values) as part of the graph - as is available with Excel?...more >>

I am using a stored procedure in one of my report and it is not generating a list of fields for my report. I believe the reason I'm not able to see any fields is because in the stored proc I'm building the query string in a variable called @SQLString. At the end of the stored proc I'm calling ...more >>

I am attempting to uninstall a version of SQLRS so that I can install the developer edition. The previous version installed, Standard Edition, was not installed by me. It seems to only have the help files installed; there is no Report Server, Report Manager, or SQLRS databases. I am not sure w...more >>

I am using the expression below to display a zero (number 0) instead of NULL =IIF(ISNOTHING(SUM(FIELDS!Dis.Value)),0, SUM(FIELDS!Dis.Value)) Whats wrong in this ? It gives me a blank but NO ERROR .. Thanks ...more >>

Hi, Please let me know if I can get any documentation or examples on creating a rendering extension. Thanks, Rekha ...more >>

Hi All .. I want to hide columns in a Table based on the level of drilldowns. Say I have a report with Country,State,City,Count first level I want to show only Country,Count and second level Country,State,Count and so on. I tried giving the toggle item property of the Column to a textbox in th...more >>

Hello, How can I create a total at the bottom and on the right in a matrix type report. Thanks, Jim. ...more >>

Our desires might be misguided, so I would like to hear what some of the more learned members have to say: Issue 1: It appears that Reporting Services supports a folder paradigm that nicely models how we desire to organize our reports. However, this folder paradigm is not supported in V...more >>

Can graphs be created when the datasource/dataset is an mdx statement? The fields available from the mdx are the combination of time and a data field. How are these specified in the graph?...more >>

Our clients would like to have the ability to print report sets. We define a report set as a package of individual stand-alone reports that are printed all at once with consecutive page numbering. An example: Joe User chooses Report A, Report B, Report C and Report D as a report set. Whe...more >>

Hi, I need custom format string for displaying percentage values. If negative values are there it should be displayed within paranthesis(brackets), it should display two decimal values also. Example: Present Value Format ------------------------ -0.21% Required Value Format ----------...more >>

Hi, I Have a problem for which i need ur guidance.I have a aspx page from which i call the report using the report viewer object.What i need to accomplish the report has to be sorted on clicking the column headings. I went through the net and worked on many examples what they are doing is ...more >>