Hi, I have created a report using reproting services. With the help of .Net ReportViewer contrl, i am displaying the report in my web page. But after inheriting the master page, i am not able to view the reprot in the webpage. Although the reprot is being generated and i am also able to re...more >>

Hi, Help!! I have created and deployed my Analysis Database using SQL Server 2005. Next, I intend to create a report model based on this database, so that can perform ad-hoc reporting via Report builder. But, I can't seem to be able to create report model based on the Analysis databas...more >>

I have installed SQL Server 2005, including Reporting Services 2005 on Windows XP Professional in a standalone environment. I can see the Reports and ReportServer folders in IIS in Administrative Tools and all settings appear to be appropriate. My first problem is that, when I try to acces...more >>

If I call the ListChildren() in ReportingService2005, and the network is connected, it works great. If I call the ListChildren() in ReportingService2005, and the network is not connected, I get a really ugly exception. I'd like to find an API in ReportingService2005 to detect if reporting ...more >>

I need to make a textbox1 say "Pass" or "Fail" depending on the value in another textbox2. Textbox2 has an expression assigned to it: =Sum(Fields!TotAgents.Value, "NumAgts") which returns a 0 or greater number. I am struggling with the syntax of linking the textbox1 text to the result of ...more >>

Hello. I have javascript in a bunch of my reports so that when jumping to a url in the action property everything would go to a new browser window. Everything is working just fine (after I upgraded the service pack so I could do it) but now all of a sudden it doesn't work on any of the reports...more >>

Hello Everyone, First, I have done a search for this problem already, but have not been able to find exactly what I'm looking for. I know that you can connect to a sql2000 db from RS2005. However, when I try to run a report from the 2005 report manager I get this message; "An error has ...more >>

I am using the following expressing to prevent NaN from being displayed in a field. I am still receiving the NaN in the field. What is wrong with my statement? =IIF(SUM(Fields!OIL_REV_VOL.Value) <> 0, ROUND(Fields!OIL_REV.Value/Fields!OIL_REV_VOL.Value),2),0)...more >>

Is there any way that I can view the actual sql that a report generates after parameters have been filled out. ...more >>

Is there a way in Reporting Services to create an optional multivalue prompt whereby the user does not need to do anything to the prompt to completely skip it. For example, let's say a report has the following prompts: Year Month Country State City If the user wants to complete the Year...more >>

Hi All, I've been playing around with SRS 2005 enterprise on Windows 2003 SP1 as an pre-cursor to upgrading our existing SRS 2000 solutions. It's been a remarkable "interesting" procedure so far, with everything from SQL 2005 failing to install from a network share (finally found you need t...more >>

RS2000 If a report have several parameter dropdowns, the data for each populated dropdown is fetched again when data for non populated drop down is fetched. Is there a way to handle postbacks events/viewstate more effective? Regards Martin Bring...more >>

We have a report that is very slow in production but runs fine in development environment. The stored procedure executes in like 0.3 seconds running in Query Analyzer in both environments. If we uses production connection string in develop environment it still runs quick. Looking at t...more >>

Hi I am running reporting services 2005 against a SQL Analysis Services 2000 datasource. reporting services is running on a development server and the analysis services datasource points to a different server. On my local pc the report compiles and previews ok in the development envir...more >>

It is not possible to sort by value which is not selected as report field. In my scenario, I've selected monthname as field and I can not sort it chronologically :( Kamel ...more >>

What has anyone done with large amounts of text in a table with regard to page breaks? I've found that the page break happens before the large block of text starts regardless of where it starts on the page. Even if there is 3/4 of the page empty it will always page break. Here's an example....more >>

I can't seem to figure out how to add data-bound images to a report when the database only holds the url for the images, not the binary images themselves. Do images really need to be stored in the database in order to be data-bound? If so, I wonder if it is possible to create a sp that can d...more >>