Hi, im a Beginner and I have to start next week with create and programming some Reports with Reporting Services. Can anyone give me some good stuff where I find the first lessons what I have to do etc. Perphaps some links or e idea for some good books!? The installation wasn't a problem, it's...more >>

Hi all, I have an external IP for my server and I tried to connect it from out side, I notice that the link address appear on Status bar is my localhost's name link ... and that's why it can be accessed to view reports. It just work if I re-config my IP setting following external IP. Who ca...more >>

The web interface for ReportServer does not work in Mozilla Firefox 1.0: reports appear as blank pages. Is this due to use of ActiveX controls in the browser, or is there some other reason - and who's problem is it? brian...more >>

Hi, I am experiencing unacceptable performance when reading XML files using a custom XML data processing extensions with RS on SS 2000. The XML data processing extensions I have used is the one on the MSDN site (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql...more >>

Hi there, I was wandering if it is possible to create report parameters on the fly. for example. table returns one moment 3 values, other moment 6 values. depending how many values i would like to create report parameters... Could anyone help? Greetz, Hippo from [NL] -- remove xxx...more >>

Hi, I m facing a problem. I have Microsoft XP on my machine with SP2 and SQL Server 2000 Personal = Edition. I download the SQL Server 2000 SP3 from microsoft.com. I download three package file 1) sql2kasp3.exe 2) sql2kdesksp3.exe 3) sql2ksp3.exe I install the sql2ksp...more >>

This has got to be one of those "doh" things: how does one enable the Layout Toolbar? Thanks! ...more >>

We want to be able to render reports in our web application and therefore have no need for the folders, roles, permissions system, etc., supplied by ReportServer: we already have a user database and permissions system. It would be nice if we could load reports and render them directly, rath...more >>

I am trying Preview, DebugLocal, and Delploy a report that is overriding the OnInit method of the Code object as described in MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_rdl_7gma.asp I recieve error [BC30469] Reference to a non-shared member requi...more >>

I am new to SRS, so bear with me. Can I install SRS on my existing SQL box; install SRM on my existing web box on a different site; and install VS.NET with report designer on my desktop? ...more >>

I got the following message at the end of my install "Setup could not initialize the report server. you must manually initialize the report server befoer using it for the first time. For more information, see the Reporting Service setup documentation" In RSMSIxx.log file i found the follow...more >>

I installed VS .NET after installing Reporting Services. When I bring up VS, I don't see the Report Designer choices. What do I need to do to make them appear? ...more >>

Hi, I have an application with RS reports. When user runs a report, I want to have a button Cancel Report. I can find the jobID for this report and cancel it, but cursor on IE is still an hourglass and green circle with the text "Report is being generated" are still in the center of the br...more >>

Hi, We have an installation problem for REPORTING SERVICES on Windows 2000. At the end of the Setup procedure, the automatic launching of ReportServer fails and the Setup procedure UN-INSTALL the whole installation which makes impossible modifying any installation parameters to reach a runn...more >>

Anybody knows when RS SP2 will be available? Thanks. Victor ...more >>

I am new to reporting services, so forgive me if this is a simple question. I have a simple report with 2 levels of grouping such as this: Group 1 -Group 2 -item 1 -Item 2 I want to add a RowNumber to show the number (1, 2, 3, etc) before each item within Group 2. I read ...more >>

Please help, I have posted about this problem before and trawled other posts to help me but still can't find an answer! The story... WIndows 2003 server with latest SP's. SQL server 2000 with SP3a + Reporting Services + SP1. As administrator on machine able to upload and run reports. Create...more >>

Hi, Does anyone know which version(s) of SQL Server 2005/reporting services will support data driven subscriptions? Only Enterprise (or Developer) with SQL Server 2000 which is very limiting! Cheers, -- Ben...more >>

I have built my matrix and am trying to polish it for distribution, but am having trouble with formatting when using subtotals. The matrix is structured as follows. Jan Feb Mar ....... Total State Year1 10 8 15 ...... 117 Year2 ...more >>

Hello, I have been building a custom report viewing tool for use in some web applications. I was using the tutorial at http://www.codeproject.com/useritems/SQLRSViewer.asp as a base for my cod. Everything seemed to work until I attempted to load a report with parameters that were query b...more >>

Hi I'm trying to tidy up a report that has a detail row that's not needed but the subtotal row for that row is... hope that makes sense. The subtotal is in fact is an average of the detail row. If I hide the detail row, the AVG row also disappears! This is more or less what it looks like: M...more >>

I'm having a problem creating a Report Project within Visual Studio. I have VS.NET 2003 installed and I had then installed Sql Reporting Services with the latest service pack. If I try and then create a reporting project within a pre-existing solution, it gives me the following error. Cla...more >>

On a report we have a matrix. The data cell has the following expression: =iif(Fields!Score.Value=0, "", Fields!Score.Value) When we run the report, we get the following warning: The value expression for the textbox 'Score' references a field outside a...more >>

Hi My requirement is like this, i need to display message on footer(table footer ) depending upon the value of one of field column (LegendInd ,the value will be 1 for legend and null for no legend)which varies for rows.I want message at footer.I tried like this. I have table in which i displa...more >>

I've just installed SQL 2005 Beta 2 onto a Windows Server 2003 SP1 box. I've installed all the components, including Reporting Services. When I try to connect to the web site I get the message The request failed with HTTP status 407: Proxy Authentication Required. Anonymous access to th...more >>

On our report server, I would like to make the export option only present one rendering type, PDF. I do not want to make the change in the server configuration file as my understanding is that this would affect the export options for ALL reports on the report server. Can you enter any code ...more >>

Hi, I'm trying to use our existing Crystal Reports .rpt while trying to migrate from existing ASP to ASP.NET. Current Crystal reports all have a datasource which is .ttx having the format fields required to be populated by the stored procedures. While trying to use the same .RPT in ASP.NET w...more >>

Hi I'm designing a backup plan for Resporting Services Server. I have the follow doubt: What must be the frequency that I must run the "RSKeyMgmt.exe -e -f Path of file name -p Strong password" command? Everytime I make any change in the RS? ...more >>

Is it possible to change the default navigation bar that appears in Reporting Services? The Navigation bar that allows, page movement, viewing size, Export etc. ...more >>

Hi I was wondering if it is possible to open a report direct in excel without opening in the webbroser -- Thanks Francois...more >>

Hi all, I've been using Reporting Services for a while and I love it. However, all of a sudden I've run into a problem that I can't fix. I'm using an informix stored procedure as my datasource for a dataset. The problem is, informix doesn't return field names with a stored procedure and, ...more >>

Hi all, i've created a print button for users to obviously print their reports. When it's clicked, the webpage automatically renders the report into a html view. The i've written some javascript 'window.print() actually ;)' so it automatically begins printing. But when i look to the repo...more >>

Is it possible to somehow create charts that support drilldown? E.g. a pie-chart where you can click any area in the chart which will redirect you to another report? Thank you for any help. Regards, Jakob. -- http://www.dotninjas.dk...more >>

Hi, I have 2 Reports and I created a Custom assembly. I am referencing the Custom Assembly from both the reports and everything is working fine on my PC. I want to deploy those reports and the custom assembly to client. can somebody point me the steps i need to deploy the custom assembly at...more >>