I have a web service report viewer control that I use to display reports to end users and have a slight problem with the datetime types and default values. Basically, I have a report that has a from and to date. The question is when I make the web service call to return parameters I am not...more >>

Any suggestions on the best reference book to help with building simple-moderately difficult reports for a beginner? This looks pretty good but wonder if it might be too advanced 'Hitchhiker's Guide to SQL Server 2000 Reporting Services' Thanks! ...more >>

I've hunted all over for the answer to this without success... I'm trying to display a company logo at the top of the report, but read from the database whether the logo is left justified, right justified, or centered. I figured I would just adjust the Left property of the image to get it ...more >>

I have designed a report in visual studio that includes some rectangles that contain sets of fields. The report looks great and runs great in visual studio. My problem occurs when I upload the file to the report server and view the report with Report Manager (or directly via a url). Viewing th...more >>

I have multiple groups and would like to have a separate column-heading row for each but I just want it to print once per gouping instance. Is this possible? CustName ----------- Smith Order Nbr ----------- 256 981 ...more >>

Hi all.... I installed a 120-day evaluation version of Repoting Services. I'm using Visual Studio .NET as the develoment environment. As a first report, I tried to connect to an Oracle 7.3.4 database but when I use a very simple query, such as SELECT * FROM POLIZA, in query designer I g...more >>

I am trying to set up a custom security extension. I've followed the setup from the msdn article as well as the Microsoft Reporting Services in Action sample. I keep getting an error when I try to start the ReportServer Service after changing the config file. Can anyone help? Thanks in A...more >>

Is there a way to suppress a line from showing on a report if the value for the a field is null ...more >>

I am making a report which uses a stored procedure. One of the parameter inputs is a date which I am trying to display in the report. Since the parameter is declared in the SP and not the report, I am having trouble figuring out how to display the parameter input in a textbox in the report. ...more >>

Hi, I don't have the 2005 Beta installed and have just viewed the "Using the New Visual Studio 2005 Report Controls" web-cast by Brian Welcker on the web. I was in particular interested in using the reports without Reporting Services. Pretty impressive, I thought, until the "Save As" part wa...more >>

This is really weird: Using Asp.Net, I am using the Web Service Render method to render a report to PDF. I have 4 different reports I do this for. Three of the reports work fine consistently. The last report will only render if I have a System.IO.StreamWriter command to log that the ...more >>

Hi, I have a textbox that functions more like a text area. It contains a pig paragraph. I want to highlight some words by either underline or maybe italics. I know you can highlight all text, but can you highlight a few words in a text? All reports are rendered in PDF. Any help is appr...more >>

I'm checking for zero using the IIF statement below. The IFF statement is inside a calculation field. I'm using the field on a table. When the statement is true it is returning a blank not "n/a." Why? This only seems to occur for calcuations. =iif( Fields!PREV_BENEFITS_PAID_YTD.Value...more >>

To make a long story short. I have a custom assembly which works fine on my development pc; however when I deploy it to the production server, I get #error where my assembly is supposed to return a value. My assembly on works on the production server only if I turn off security with caspol.e...more >>

Hey guys, I try to hide some sections of my report using the expression editor. I tryed to find what language the expression editor is but I did not found it. Does someone knows any references about expressions in RS? Thanks! ...more >>

Hi, I am looking for some help with builing parameters in a report. A have a report that displays sales persons. What I need to do is either allow entry of the sales person number directly OR use a set of cascading parameters that start at country, then region, then state, followed by off...more >>

How do you increase or decrease the size of a pie chart? The only way it seems to work for me is if I make the table bigger or smaller....more >>

Hello, I have a licensed SQL 2000 in our department, and want to have the reporting services. According to MS, I should get it for free. The trial version that we have been running has been expired. I was told that I should get it from the vendor as an update, but they don't know anything a...more >>

Hey folks! First, if I am understanding correctly, even though I remove the BUILTIN\Administrators from any roles and/or access in RS, they still have full access to Report Manager, system settings and all. Is this correct? If the above is true, has anyone found any way to circumvent this....more >>

the key is in your post above my first post where you ask "how can I build UI for it" - that is the key - you have to build your own custom user interface for the report parameters. Instead of using a drop down list to display the allowable parameter values, use a list box, which supports sel...more >>

Hello can anyone tell me how to set & unset the a default parameter for a report using the webservice api ? ...more >>

I have Report With 10 Parameters 3 of these are optional in the Stored Proc which Returns the required data for the report. All the parameters are combos driven by stored procs. What I need to do is once 7 of the Parameters ahve been filled to be able to generate the report without having to ...more >>

From the references tab, I see I can create an instance reference, but I do not see how I can instantiate that class with a constructor that has arguments. Does it only do the default New() constructor? I would like something like: m_MyClass = New MyClass(Version as Integer)...more >>

I am trying to just take an existing report and modify it's subscription to make it run ASAP. The idea is to create a file copy of a report as soon as the report is run. I know it would be easier to just get the report via the API and save it as a file, but one of the requirements is that if ...more >>

Hi, We had a production problem and had re-install reporting services from scratch. All the reports are working fine after running the rsconfig and rskeymgmt tools. The only problem is I am unable to see the toolbar to create the folder when i browse to the server: http://server/Reports/P...more >>

Hello EveryBody, I do have report which is returning all the products based on the category selected in the dropdown list... I do have a question, How can i select multiple category from dropdown list ? Thx...more >>

Hi, How do i make parameters invisible. Scenario: I am doing the dynamic sorting. I put 2 textboxes next to the table header asc/desc and am doing osrting sending values by parameters and reloading the report with sorted options. But how do i make them invisible parameters ?i.e, the parame...more >>

Hi, I need to change the colors of my pie chart. The pie chart consists of five pieces, which represent the severity of the piece (i.e, 30% of the users have more than 5 problmes) so I need this piece to be red (no problems should be green, for this matter). I can't seem to find a way to co...more >>

I have an AVG(Fields!HT.Value) [in seconds] in Report Layout. I want to dispay it as "hh:mm:ss" format. Please , help. ...more >>

Hi, I'm quite new to Reporting Services so a dumbed-down answer may be more helpful. :) I want to generate a report which has a logaritmic scale vertically from 0,0001 up to 1000 with the scale values shown being ten times higher than the previous scale value (logarithmic - duh!) and I ...more >>

Hello, I have a very simple report... SELECT AmountDue from Table where DueDate Between @Dt1 and @Dt2... So in above case i will see two parameter in my report. Is there any way so that i can select dates from calendar control in Reporting Service ? Thx...more >>

Hello, We have a dental practice that uses SQL server as a database and a practice management system. I need develop a report by using Reporting Services to be able to print statements per patient. Is there any reports already developed for healthcare companies so that I can check and see wha...more >>

Hi, I have a report, in which one of the parameters is the users initials. (windows account). Is there somehow i can test in the report if the parameter equals this account - and if not redirect to an error page. Comes down to : Is it possible to redirect from inside a report - based on ...more >>

I've created a web reference to a copy of Reporting Services (2000) on my work network using VS 2005. I then have the following code in my test page; Imports mw03aste Partial Class rs Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System...more >>

I have a SP that takes a parameter @strSQL char(8000). The paramter is basically a select query, that returns a list of ID's. When the SP is exectued I execute @strSQL, which returns the list of ID's in question, which I can then process according to business rules. I use this format, bec...more >>

I have a RS server that has been running fine. Everything was setup, all security was working, credentials were being passed through all was GOOD! However, due to some other business requirements I had to update the 2003 server to SP1. I updated RS to SP1 first. Everything seemed to work...more >>

We are customizing Report Manager and have been able to get the reportingservices.css style sheet working well. As we will be calling reports from within Report Manager, we would like to apply the HTMLviewer.css file to every report called through Report Manger. This would enable us to g...more >>