Hi, currently I test a website using the application center test. My web site is a sharepoint site with some webparts. most of these webparts access some olap cubes directly, and near every page has a webpart which call reportserver to display the list of available reports. all reside on...more >>

when we install report server database, a login and password is needed to connect to the RS server database. but my boss change the password in the server so i cant access to the report server again as the report server said login in failed. how can i tell teh reporting service the new pas...more >>

I'm receiving an, "The expression for the chart ‘chart1’ refers to the field ‘Bill_Sum’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope." Error whenever I use the fields from my similar r...more >>

I have a database which stores word documents into tables as BLOB fields. I need to work out what size each WORD document is. Do you know how can I work out the individual size of each word document? __________ 'sp_spaceused worddoc_attached' only gives me the overall size of the data in...more >>

Hi, Is there a way to find out(via table lookup) which database in an given instance serves as a reporter database?. More specifically, i need to report on some reprots and i do not want to check every database in an instance to find out which one is used by reporting services. ...more >>

Hello, Is it possible to either: a) disable the help icon on the navigation bar b) change the location it links to one of our help files I tried to change the image to visible = false, but do to cross frame security I was getting permission denied messages. Any technique would be ap...more >>

Hi - I'm drawing a blank right now on how to insert subtotals into my table on a report. I know there's an Insert --> Subtotals *somewhere* but I'm not finding it. I've right-clicked on my cells, rows, and columns and I'm not seeing it. My table is set up like (toggles shown)... + cust ...more >>

I was wondering if someone could provide a bit of direction for this problem. I have a dataset which is populated via a stored procedure. The stored procedure executes some dynamic sql and I call the sql using exec(cSQL) I have also tried sp_ExecuteSQL cSQL The proc runs fine when c...more >>

First, I have SP1. Microsoft SQL Server Reporting Services Version 8.00.878.00 I created a snapshot - to ensure the db query is not the cause. I am working on the production hardware (beefy) - and I am the only one on it. The HTML version is quite fast off the snapshot (maybe 20 secon...more >>

I get this error message when I try to create a DataSet for an Oracle procedure that has an OUT Parameter. PLS-00306: wrong number or types of parameters in call to 'procedure name' The Error happens when I click on Refresh Fields. I can execute procedures with a REFCURSOR OUT Parameter ...more >>

I have Server2003/SQL2000/IIS6 and have just installed Reporting services. I have two websites on the server. Access to reports is fine using the http://servername/reportServer, and using IUSR_servername, but I would like to have reports available via the Internet using domain names. Saw th...more >>

I'm using ReportViewer to display SQL Reports in an ASP.NET application . I have links from one report to another, and am using Jump to report (from Navigation tab)to do it. I like this way better than jump to url because it makes it easier to pass around my parameters. It works fine except t...more >>

Hi, I am trying to have the report manager render the report always in full screen (full screen/Restore Down toggle). I mean have the toggle to always collapse and not show Home/folders and view/properties/subscriptions tabs. Thanks, Sam...more >>

Are users that are added to report security (or to folder security) can use web service? What I found was that I tried to add ASAPNET account to a report through RS management site (and that worked). And then tried to call RS WS with this account - just plainly called rs with default creden...more >>

Default value or value provided for the report parameter 'ParamaterName' is not a valid value. (rsInvalidReportParameter) I am getting this error when I am trying to run a deployed report. However, this is driving me mad because in the report preview within VS.Net the report works fine and...more >>

I am calculating the pct of one item to the total (Ex. Fields!FieldName.Value / Sum(Fields!FieldName.Value) ) My problem comes in when I try to total this number in my groups. RS doesn't like: Sum(Fields!FieldName.Value / Sum(Fields!FieldName.Value), "Group1") How else can somethin...more >>

I have a data driven subscription. I would like to include a link, however, I want to include the link from the database. So i select the "Get the value from the database" button under "Include Link". Then i select a field. No matter what field i select, or what value the field has in it, the su...more >>

I have Web application and I am trying to integrate Reports from SQL Reporting Service in it. I can render a report to a page from my application. The problem is the if a report has links to other reports then those links send you strait to Report Service site and not back to my application. ...more >>

Is it possible to hide a row of data if for instance no data exists in that row. so my report isn't 300 pages long when it should just be 30? I was looking at the visibility element but didn't see anything to hide based on expression. Thanks, CJ ...more >>

I have updated this - I really need help! If you read this before, see the bottom for additional info. ---- Due to configuration changes, I had to uninstall RS (which was running just fine). Now I cannot reinstall it. I have a test server that is a domain controller. It is running Windows...more >>

I'm using a transparent image in a table cell. I'm using "green bar" style formatting in the table. My background formatting of the cell, which previously worked before, disappears. Dragging an image to a table cell, causes the textbox to be deleted. The textbox contained the backgroundcolo...more >>

When browsing the folders and reports the links at the top are set up with https except for Help. My site forces https... easy way to change it?...more >>

I recently implemented Reporting Services (w/ SP1) on a 2003 Server w/ SQL Srvr 2000(SP3). On the server is a group of ID's from my company's domain. This group is given the Browser role which works to a point of navigating folders. When the user chooses a report they are re-authenticated ...more >>

Alright, so tabular setup rocks compared to Crystals free form placement. I view this much like HTML tables. Awesome right? Well, one of the greatest attributes I think that exists in HTML is the Column Span property (colspan). Does this exist in Report Designer? That is, make a column spa...more >>

Is there any way to have headers on the matrix group columns. I am trying to produce a matrix in a tabular format, however, when i insert group rows I cannot insert header descriptions....more >>

Do all expressions have to be on one line? Can you declare variables in them like in Crystal Reports Formulas? Can you use other formulas as values? As in you set up a textbox that will give you a value with an expression, then in another expression you reference the value of that text box? ...more >>

Has anyone had luck exporting to Excel from the standard reports provided with SQLH2? I have also tried exporting to PDF which works but it won't print reports on one page, i.e. it prints half on the first page and then the remainder on a second page. I can't find a way to reduce the font siz...more >>

Hi, Is there any way to directly access a value contained in, for example, a textbox? If I were to create a textbox ('textbox1') with a default 'value' attribute of "Hello World!", how would I make 'textbox2' get the value of 'textbox1' and set its own 'value' to equal it? I thought m...more >>

Is there a good guide out there that I can reference for expressions? Crystal's formula editor seems very strong in comparison, and frankly if we can't find any decent documentation with good examples, we may just ditch reporting services for Crystal. We have several legacy reports in Crysta...more >>

Hi! Does anyone know how to compute a 'mode' average instead of the 'mean' average that the aggregate function 'AVG' returns? Is there another function, or some kind of parameter for the AVG function? Thanks, Craig...more >>

I want my report be accessible for everybody. So i enable anonymous access (IUSR_MACHINE) on the virtual site ReportServer. On my report, i allow IUSR_MACHINE the Browser Role. Administrators have all Role on my report. When i want to acces to the admin page (http://localhost/Reports), I have...more >>