I can access the Reports Manager and all the tab pages in the manager from my home PC by authenticating the username and password, BUT THE REPORTS THAT I UPLOAD WILL NOT RENDER REMOTELY. If I log into the actual server, I can see and view the reports just fine. I am using SQL Server 2000...more >>

So I have a report that has a header, and in the body there is a table. The table has a heading row. When I export this report to excel, the freeze pane is put under the header. Is there a way to specify the location of the freeze pane when the report is exported to excel? I would like to have...more >>

I can only get to my Reports from http://localhost/reportserver, the http://localhost/reports is not working, it is only showing me part of the page. What can I do to fix this? I am only seeing the top tool bar and the part that says; home - my subscriptions - help Any ideas of how to tro...more >>

i've already read the MS help file saying this can't be done, but there are lots of people out there smarter than MS. Has anyone come up with a way to take a multiple select paramter and pass it into a stored procedure yet? I noticed there is a built in function string.join which concatona...more >>

I am having an issue with the winforms viewer where it always shows the report in full print width (8.5" for this report) regardless of the "InteractiveSize" property. - The report itself is 7" wide in the designer - .75 margins on each side. - "InteractiveSize" is set to "7in, 11in" In ...more >>

We installed sql 2005 server and reporting services (standard edition) on window2003 with sp1 and IIS 6.0 is running on it as well. I am in local admin and got error when i try to connect report server: Cannot execute a program. The command being executed was "C:\WINNT\Microsoft.NET\Framew...more >>

Okay, here is the scenario. I have an analysis services cube and a report model generated from a OLAP datasource in reporting services. My first problem is that when I try to create a report using the report builder from my local pc I get data source connection errors, but if I remote deskto...more >>

We installed sql 2005 server and reporting services (standard edition) on window2003 with sp1 and IIS 6.0 is running on it as well. I am in local admin and got error when i try to connect report server: Cannot execute a program. The command being executed was "C:\WINNT\Microsoft.NET\Framew...more >>

Hi- I dug through the archives and found this helpful bit from Robert Bruckner from September 2005: Sum(Fields!Reg_Hours.Value) / Sum(Fields!Reg_Hours.Value, "MatrixRowGroupName") I'm doing this; no error, but getting 100% for each item in my group. Any suggestions? 99% (ha) of what I do ...more >>

Trying to build a report that will return information on many contacts. SELECT ContactExtensionBase.ContactId, ContactBase.LastName, FROM ContactExtensionBase INNER JOIN ContactBase ON ContactExtensionBase.ContactId = ContactBase.ContactId WHERE (Contact...more >>

I use the javascript method to launch most of my drilldowns into their own IE window: ="javascript:void(window.open('" & Globals!ReportServerUrl & "?/Sales/Dashboard Drilldown - By Stage" & .... But now that we just switched to Sharepoint Integrated mode with my reports now residing in a do...more >>

Hello All, I am a newbie here coming from a Crystal development background and intermediate skills with SQL. I seem to have various issues creating all sorts of RS reports. I'm trying to start with "more modest" reports to ease myself into the groove of using RS, but some things that seem s...more >>

Here's the scenario: I want to be able to create a report (typically these reports are "table like" reports ... in other words, several columns with a list of data underneath) and I want to be able to re-order the columns (not the rows) in these reports at runtime. So, for instance, if the ...more >>

I need some help on SQL reporting 2005 -Grouping and page break. I am displaying list of Lobbyist Names in one my reports order by Names. I want to Group all the names starts with 'A' and introduce page break at the end. Then all the names start with 'B' and show it in next page and so on...more >>

Hi, I need to have a few folders in a reporting system to organise my reports. All of the reports connect to the same database. The only solution I can see is to make a separate Visual Studio project up for each folder I want on my report server. This means I need a separate shared data sou...more >>

Dear all, what is the easiest way to rerun a set of time-scheduled subscriptions on a report? I need to rerun inflow on the Data Warehouse and rerun these reports. BR, Bert ...more >>

Hi, I have a report which has a subtotal and users can click on the subtotal and go to a sub report. However, when people click on the subtotal they are shown a blank screen (Apart from the standard reporting services header). When I right-click on the blank screen and view the properties of t...more >>

Hi all, using SQL2000 sp4 How can I see why a report is not loading in browser. Just hangs with hour glass. not even the paremeter input fields are loading? I haven't even clicked view report? other reports are fine. thanks, gv ...more >>

Is there any way to send a quantity to the print que to deterimine the number of copies to print? I need to deliver a copy of a report to each department that is reflected on areport. Let's say for example, I have a report that has 3 departments with line items to be produced by each departme...more >>

Hi guys, We have 2 database one in US another in UK. I am developing 2 reports one for US and another for UK.. Is there any way to pass/give the connection dynamically? Regards, Sri...more >>

Is there any way of adding subreports to a "container" report at runtime? I need to make the reports composable and would prefer not to have the superset of all reports in the container and just toggle visibility. Right now the only solution seems to be to generate my own RDL on-the-fly, which...more >>

Dear all, I'm a noob to SQL Reporting Services but have plenty of experience with other MS applications (including excel and access). I was wondering whether it's possible to combine a cross-tab and a chart within a single report. If so, how do you do this? I believe the power of a report (...more >>

could u please tell me how to validate inputput parameters in reporting server ...more >>

I want to combine several reports into a single report to print out. I want the correct page numbering on each of the individual reports so I don't want to use subreports on a main report. Is there a way to combine reports into a single report to allow the user to print without having to print ...more >>

Does anyone know of a way to relocate the "View Report" button for reports? ...more >>

Hello, I have pulled al my hair out and have no more hair left, so I hope someone can help. I have a function I'm trying to use in my SSRS 2005 Report (Report-->Parameters-->Code tab): Function funAdditions(pFields As Fields) As String if pFields!FA00902_AMOUNT.Value > 0 and pFields!FA0...more >>

Hi, I would like to allow my users to create report templates and save them. The reports should get their data from my business objects. I'm not really sure where to begin with this.. I image that i'll need to setup reporting services. Currently I have rdlc client reports and report vi...more >>

I am having a problem trying to get the correct data on the report. It is a typical schema where we have clients, doctors and both of those have doctors. I am unable to show clients, client addresses and doctors on the same report builder report. I can get 2 of those not 3. any ideas? (i...more >>

I am having problems with my matrix that is embedded in a list. I used a workaround to create a horizontal table (matrix + list). Now, when i run my report, the row sizes of the matrix always shrink, even if i put CanGrow and CanShrink to false. So now, i haev set CanGrow to true, and have ...more >>

I have a report that compares estimated commission to written (actual, invoiced) commission. I want to filter out records where the difference between estimated and written is within 10% of the estimated commission...in other words, if they were close, I don't need to see it. I am having a he...more >>

Is there any way to get the Reporting Server to preserve the height of a cell in a matrix? Currently, i set CanGrow and CanShrink to false (because i've already designed the matrix cells to fit the text). However, with these both set to false, the height is automatically changed to about 50 pi...more >>

Is there any news regarding subreports in Excel? I've search this particular newsgroup and it seems as though this is by design! I am using VS 2005 to create the reports, on SQL Server 2005 Enterprise. Thanks for any help! ...more >>

Hi, I have a requirement where I need to query two cubes from two different database and show results in the same report. I have created two connections and a dataset on each of the connection. Can I now join these two datasets? The two cubes I am querying are a main cube and an archive of th...more >>

When we try to delete a folder in de report manager we get an internal error from the Report server . In the log we find: w3wp!library!8!04/25/2007-12:46:33:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the rep...more >>

I`m a new RS user so please bear with me. I have a report that is run for two different companies. Both companies want their logo on the report. It was set up by a colleague to have two reports and they choose the one applicable to them. Surely there is a way to use the same report and pass a ...more >>

it is stupidity to change color and background for each reports.. ...more >>

In SRS 2000/2005, is there a way to get usage tracking for report access? Is there a way to track how often a particular report is accessed and with what parameters? This would be extremely useful. ...more >>

I just installed Reporting Services 2005 but when I start up SQL Server Business Intelligence Development Studio I'm stuck. I don't even have "create new project" as an option on my file menu, instead I have "create team project" or "create file". I previously had Visual Studio with Team Foun...more >>

We have SS 2000 and SSRS 2000. SSRS is connecting as a Windows account of "NT Authority\Network Service". That account is in both RSEXEC roles in ReportServer and ReportServerTempDB. When we log into the Report Server website as a domain name (which on the server has admin rights), it works ...more >>

I have been tasked with creating a quick little command script to export the rsdbkey on a regular basis, is there a switch to make it NOT ask me if I really want to export the key? I tried the usual -y & /y but they didn't help me any. /? didn't offer any help either. Thanks! ...more >>

I have a client table and a clientdoctors table. In the data source view i see all the needed tables in the diagram organizer pane. I also see the relationship between the clientdoctors table (which holds clientid and doctorid), as well as client table and doctor table. That all looks fin...more >>

When exporting a report to excel, Is there any way to keep the table header from scrolling up in the excel output when a user scrolls down through the data? I noticed that anything that's put above the page header is frozen when the report is exported to excel. But when I tried placing the ta...more >>

I am attempting to deploy a report that I created with "Business Intelligent Projects". When I attempt the deploy I get a message that my user account doesn't have the rights to do it. It is an administrative account and the same one used to start the service. I have another developme...more >>

I want to chances the Connection String in a C# WinForm Program to use the same Report (with RS) for diferents Companies. Each Company have in one diferent DB....more >>

We have a "Change Management" Dept that MUST deploy all reports into Production. I have the same ability from my machine and I can deploy the solution (or each individual project) without problems (but they don't like it since I am just a developer). When CM deploys (they take my solution...more >>

I've been searching high and low for an example of this which I thought Reporting Services could do. We want to have a report which can be scheduled to produce an Excel file for each of 40-50 variations on a parameter automatically. So for example if I want the same report produced for area ma...more >>

I've got a report with 4 parameters to a stored procedure. The parameters all work in the stored procedure when I run it in Query Analyzer, but only one of them works in the report. Is there a way to see what's being passed to the sproc? I don't have admin rights to the DB so I can't use ...more >>

Hi everyone, After reading through countless Microsoft pages I'm still very confused about how to setup a correct datasource connection. I have a database server where all the data is kept, and a reports server that I would like to use only to generate and deploy reports to. I have Visual Stu...more >>

On Apr 24, 8:42 am, RSub <R...@discussions.microsoft.com> wrote: > Hi All, > The below IIF statement is not working for me. > =IIf(Trim(Fields!BillType.Value)= "IN" AND (Fields!User9.Value)= 1, > "Address:" = Format(Fields!Addr1.Value & " " & Fields!Addr2.Value & " " & > Fields!City.Value & " "...more >>

I created a SSRS report that has three different sub reports in it. From the design view, it works perfect. but after a deploying it on the intranet it shows the following error.: "Error: Sub report couldn't be shown". I tried to research different forums in internet unfortunately i couldn't g...more >>

I have a reporting services project and noticed my installed instance (default) did not install Reporting Services. After much pain, I ended up uninstalling the SQL 2005 instance. The Reporting Services Service was not installed. I attempt to re-install all of SQL 2005 from the command prompt ...more >>

Hi All, The below IIF statement is not working for me. =IIf(Trim(Fields!BillType.Value)= "IN" AND (Fields!User9.Value)= 1, "Address:" = Format(Fields!Addr1.Value & " " & Fields!Addr2.Value & " " & Fields!City.Value & " " & Fields!State.Value & " " & Fields!Zip.Value & " " & Fields!Country.Va...more >>

I have a daily report which is delivered daily in web archive format. The file is normally around 1.2 MB. If someone attempts to forward the report it turns into a 8-9 MB email. Any suggestions as to why? Thanks....more >>

How to rename the "My reports" folder. My browser language is in french and user are speaking french. The report manager only show "My reports" but I want to see "Mes rapports" I know that is the "listChildren" method that add My report. Is there a way to change this? ...more >>

Can I only install SQL Server 2005 Reporting Service component on my server which already has SQl Serevr 2000 server database installed. So I can use 2005 Reporting Service features by accessing my SQL 2000 database. Thanks for suggestions, ...more >>

Does anyone know how to display a pop up window when a user clicks on a folder in Report Manger. Our managers would like each user to accept a disclaimer before they are allowed to run reports. Right now I created a folder that says "I have read and accepted etc...." so the users have to cli...more >>

Hello folks, When working in Visual Studio 2005 Reporting Services, I have been cursed with a small problem that I have run out of remedy ideas for. On the data tab of a report I am no longer able to use the TAB key on the keyboard to format my SQL. I say no longer because i was using Visual...more >>

Hi. I'm just starting to develop reports using Visual Studio 2005 and Reporting Services 2005 and am still trying to get my head round things. One immediate problem I could use some advice on is this. I'm trying to reproduce a report that, in its original incarnation as an asp page, display...more >>

Hi When you are exporting a report from SSRS 2005 to Excel, it is the first column in your tables the one wich sets the row heigh in Excel. For example, I had a table with an 'observations' columns. There I had some text, but it always was being cut because all rows had a heigh of 12.45 Now...more >>

Hi All I am trying to solve an issue with the Sharepoint Integration process. Everything seems to have installed correctly. Installation of MOSS on the MOSS server, SQL & Reporting Services on the SQL05 server. At the Central Admin ->Reporting Services->Grant Database Access I get an error ...more >>

Any ideas as to how to keep Reporting Services awake? I have tried setting up a simple report that gets the current time and then created a subscription that runs ever 5 minutes, but it often still takes time to open the home page. ...more >>

Hi! I'm new to reporting services and have a question for you. I've managed to get a single value from a custom assembly method and publish it on a report, what I want to do now is to fill a chart with data from my custom assembly method, the data is returned like a dataset. Displayin...more >>

Does anyone know of a tool for documenting reports in Reporting Services. I've made some MS Word documents with parts of the documentation, and added comments to different parts of the desgin, but I'm looking for something that can structure the whole thing a bit better. Any suggestions? ...more >>

Hi, I am doing some researches about how the reporting services can be use on the public (internet) instead of just intranet. Could someone please give me a hint (link / sample) about how this can be achived and how security is this on the internet. Thanks Ed...more >>