I use the User.UserID to populate a parameter. When calling the report the first time a list of parameters are prompted, at this time the field that uses user.userID is disabled. However after filling the parameters and submitting the request the field that uses user.useriD is now enabled for ...more >>

Hi, I am using Drillthrough in table Cell in one of my report. Table cell displays sum which is sometimes Zero. And when sum is zero, I don't want Drillthrough featur at that point, so that I can avoid unnecessary click. I tried using expression =IIF( sum =0, "", ReportName) but th...more >>

Hello, I'm trying to change the color of a chart region based on a report parameter and I'm not having any luck. Can any one tell me where I change this? I see all of the available color palattes, but I don't want to use those. The regions need to be a specific color based on the report ...more >>

I just read from another post that there is an implicit KeepTogether on Subreports. Apparently, this is a property that cannot be turned off and causes subreport data to be pushed to a new page if it can't fit on the current page. The only advice given was to avoid using subreports if you don...more >>

Hi All, I am having an issue with filtering on the series group in a chart in SSRS. (Dundas Product) I keeping getting the same error no matter what I Try. "An error has occured at report processing. The processing of the filtered expression for chart 'chart1' cannot be performed. Compari...more >>

I have a table in side of a table and need to be able to capture the row height of each group from the outer table, so that I can make sure that the inner table height is the same. ...more >>

I need help setting up a Read connection to a MS Access table. The Access file is not located on the same machine that many of the SQL servers reside. Everything works great on the local machine using the ODBC Drivers Provider as a one of the rds. The DSN file on the local development machi...more >>

how could i make the report to be printed in "Landscape" mode in sql reporting. ...more >>

Hi, I am using Drillthrough in table Cell in one of my report. Table cell displays sum which is sometimes Zero. And when sum is zero, I don't want Drillthrough featur at that point, so that I can avoid unnecessary click. I tried using expression =IIF( sum =0, "", ReportName) but th...more >>

I have resized the elements of my report so that they will render correctly in a browser window. I have deleted the report from within Report Manager, but when I deploy my report from Report Designer (or update it from within Report Manager), it still looks as it did before. How can I manu...more >>

I have three subreports that are sitting in the detail section of a grouped table. I pass in the appropriate parameters and everything is working well with the subreports in terms of the data. I have created a group header for the subreports and turned on the repeat on new page option. This is...more >>

In the detail row of my matrix, I have three textboxes called txt1, txt2, and txt3. They hold the values from my dataset fld1, fld2, fld3 accordingly. In the fourth textbox in that row(txt4), I'd like to show the sum of those three fields. I know that I can use an expression like: = Fields!...more >>

I've to create an instance reference to my custom assembly by constructor method. It works well with a Code into the report .rdl like this: -------------------------------------- <Code> Public Obj As MyClass Protected Overrides Sub OnInit() dim MyArg as String = 4 Obj = new MyClass(MyArg)...more >>

Hi all, I have developed an employee time report that has Start and End Date parameters which have default values, the third parameter is a dropdown list of employees also with a default of "All". We want to send email to each employee with only their information on it. So I created a data ...more >>

I need the SRS runtime. I have the following -- Windows 2003 server -- SQL server 200 installed. -- IIS 6.0 installed -- .net framework I tried to install SRS, but VS.net is required. And when I try to install VS.net, Frontpage server extensions (FPSE) are required. Can someone help ...more >>

We're getting ready to launch Reporting Services and are looking for a way to document the business logic and metadata behind the reports. Does reporting Svc. offer a quick & easy way to do this? ...more >>

I'm just wondering - is there a way to use MS Report Designer's API's to generate the actual RDL file with all groupings, sortings, etc., as it is done using the Report Wizard. I know, there is an example to generate a simple RDL file, using XmlTextWriter approach to generate a file manualy ...more >>

Is there a way to kick off a report using a command line script? For instance, I want a report to run only after a certain table in the database has been updated (monthly) and I would like the report emailed as a PDF to a user. I cannot use the My Subscriptions to do this b/c I don't know when...more >>

Hello, I realize this topic has been beaten to death but I'm still having trouble with a report. I'm trying to open up an asp.net page in a new window. Here is what I'm using based on examples I've read here so far: = "javascript:void(window.open('"http://www.mysite.com/subdir/form.a...more >>

Hello, I've seen the RDL is schema and to say the least its quite massive. We'd like to generate RDL files from a schema that leaves out UI definitions. Is there a more light weight schema for this? Is there also a white paper that describes the schema parts and what they mean? Thanks ...more >>

Can other report items be 'superimposed' on charts?? I have a chart and want to annotate it with text or a table, etc. It works fine within ReportDesigner - by bringing the report item to the front. The preview in ReportDesigner looks great. However, when the report is deployed, the report...more >>

I am trying to setup a report on the report server that connects to Oracle 9i. The Oracle 9i client is installed on the report server, but we still get the error: An error has occurred during report processing. (rsProcessingAborted) System.Data.OracleClient requires Oracle client software versi...more >>

Has anyone been successful in reporting on Outlook Calendar data in SRS 2000? If so, can you please share how you connected to the data. ...more >>

We are running the June CTP. When some users go to htttp://theserver/Reports, all they see is the word 'Home' and a line across the page. This happens even though I have added these users as both Administrators and Users. I imagine that this has something to do with the domain, but I don't s...more >>

Using this expression to get the percentage of two fields. The problem is when both fields contain values of 0 then I get 'NaN%' . How can I rewrite the expression to give 0% =ROUND(((SUM(Fields!P2_OPENED.Value)/SUM(Fields!P2_CLOSED.Value)) *100),2) & "%" & vbcrlf & "" Thanks, ...more >>

I'd like to create a report in which the column headers are located along the left edge of the page and the detail rows/groupings are located across the top. Detail rows would then be added from left to right, not top to bottom. Is there a way to do this in Reporting Services? -- Todd P...more >>

I am using the reporting services reportviewer control from Visual Studio® 2005 Beta 2. When I run a repmote report I get the following error: [WebException: The request was aborted: The connection was closed unexpectedly.] I can access the report from my browser doing a straight url a...more >>

I am trying to get into SSIS I am not a developer but a complete newbie, I want and need to bring together data from different sources for reporting services, score carding and anaysis services ect for our company I am managing to move data from a to b ok however this does not cover all the task...more >>

As I would like to execute a stored procedure within the Report Creation Wizard. But only SQL String are allowed. How can I "put" my stored procedure in this data view ? (I try EXEC my_stored_proc in the SQL String area but not working...) I would like to do it because I have almost 60 fie...more >>