After installing delphi 2005 I am getting a security exception when trying to access the reports/report manager/web service of Reporting Services. I think it is Borland related - the stack trace shows borland in there now....How do I fix? =====================================================...more >>

Hi, I am a newbie to SQL Reporting Services. I am trying to evaluate whether to use SQL reporting services as opposed to crystal reports. I want to create paper based reports as well as web based reports. Is it fair to say that SQL Reporting Services focuses more on web based reports tha...more >>

Backstory: We are an AccessXP shop that is _slowly_ migrating to .Net. We have decided to move to Reporting Services for our reports as a first step. I have been tasked with creating a report viewer to use in Access XP that gives the same functionality, i.e., printing, zooming, etc. What I ha...more >>

Good day everyone! I am displaying a line chart by SOAP access of reporting services. The is rendered to my aspx page well for the first time, but if I change the parameters, and call rs.Render, it's supposed to show a different picture, but it's still showing the same one. The problem i...more >>

Hi All, I got a new machine. On my old machine, I had no problem using VS ..Net to deploy Report Projects to our Report Server. On my new machine, I installed IIS, installed VS .Net, enabled ASP.Net, performed a Report Designer installation of Reporting Services. After I create my repor...more >>

Hello, I put this to my jump to url field and it says hyperlink expression contains colon or a line terminator. ="javascript:void(window.open('"http://myServer/myApp/MyApp.aspx?myNum=" & Fields!myNum.Value & "','popup','width=340,height=20,left=270,top=180'))" What is problem? Thanks, J...more >>

I have SRS installed and running fine. Only issue is that there is no Reporting Service listed in Visual Studio Help Index. I have updated SRS Help with RSDocRefresh.msi and still I can not see SRS specific help.. Any Ideas would be appreciated. thanks ...more >>

Has anyone else out there had any problems with images rendering improperly in the reports? When I add our company logo (a gif) to a report, it looks fine in the development environment. Also, when I export the reports (say, to a pdf) the images are fine, but when I view the report in a browser ...more >>

Looking for information to troubleshoot this issue. Report server service is running. Report Manager operating OK. Just no email. SQL Agent is running. SQL Agent Jobs show successfully ran....more >>

Hi, I have installed report server with the samples on my m/c, however when a collegue of mine tries to access the sample using the url of my m/c it gives an error saying "The user domainname\user does not have sufficient rights to access the report" ...more >>

We have run into a critical performance issue with Excel rendering extension. Is there any way, undocumented or not, to render to MS Excel without formatting? I have searched this group and other resources and it looks like the answer is no. Though, I thought I would try just in case. Mi...more >>

Anyone know my reports are all suddenly throwing this back : Invalid object name 'ReportServerTempDB.dbo.ExecutionCache' ? ...more >>

Hi After a month long evaluation of Reporting Services my company has only one more question left. Will there ever be a stand alone Report Designer for Reporting Services (one that can be used without VS)? Thanks a lot Shawn...more >>

I have a report that receives a Soc. Sec. No. parameter. The first table I need data from is keyed on SSN. This table also has Id. column. I need to use the value in the ID column to retreive data from a different data table for another part of the report. From a design point of view h...more >>

I have an interesting situation. I have a classic ASP site (intranet) based on Forms Authentication. In order to create the sqlauthcookie that RS needs to be authenticated to the service, I have created an aspx page on the RS box, which is called from the classic ASP site, to run the code ne...more >>

I heard some talk in the past about a tool called Data Views, or something close to that name, that will be the end user tool for Reporting Services. Currently, I can't seem to find any information on it and my company is evaluating Reporting Services. We are looking for some sort of information...more >>

I have a set of data tables with their own datasets from different database tables. They go across the report page and all need to be linked together via an ID number. How can this be achieved or is there a better way of doing it other than in report tables? The data tables across the ...more >>

Hi everyone, I have a Web Form with data fields. What I want to do is to save these fields into an XML file (dynamically), then hook this XML (as a data source) to a SQL Report so that I don't have to save these data into a SQL Server database. Is it possible? If it is then can someone show m...more >>

I am writing a report that I need to return a background color for a cell in a table. The background color depends on what color is named in another cell. For example, if the cell (Quality_status.value) displays the word Green then the cell (Quanity_status.value) background color needs to be...more >>

I recently order Reporting Services for SQL STD Edition from MS's website. The server installation (on SBS2000) went fine. I am trying to install the client component (i.e. report designer) on my Windows XP client (with VS.Net 2003 installed). During installation it's prompting me for a CD key....more >>

Hi I cannot uninstall RS Developer Edition(Chinese version) on my laptop. I am running MSSQL Server 2000 with Service pack 3, XP Professional. Urgently need help. Any comments? Muffy...more >>

How do I check if a row is a subtotal or not? I have a report where one column shows Average hour rate. Right now, the subtotal line shows the Average column as a subtotal of all the other averages... So I'd like to have a statement that does something like if row is a subtitle row then s...more >>

Hi all ive created a strongly named assembly and installed it into the GAC on the Reporting Server Machine, this assembly opens a basically reads in the contents of a file. This all works if i reference the assembly in an app, and even in the code of the report designer, but does not work when...more >>

Hello, I have a report with 2 parameters ( 2 combo boxes ). I would like the content of the second combox box dynamically to change depending on what I select in the first combobox. Is it possible to achieve this in SQL reporting services ? Thank you Pascal ...more >>

I have some reports that need to run for about 10 minutes. I changed the parameter on the report to "Do not timeout report execution" but I still get a connection timout error. What else do I need to change? I get the following error in IE: 10060 - Connection timeout Internet Security and...more >>

I tried to let RS do the grouping, but the dataset is too large (and RS takes too long). So, I am doing the grouping in my query via the "With Rollup" GroupBy clause. But, how do I display it the same way I did my matrix? Is there an article someone can point me to? Here's a more detaile...more >>

Hi, When I attempt to open any reportserver RDL (after deploying), the RDL file opends in Visual Studio .NET as an XML file and I am unable to figure out how to make the report open in Reporting Services Design View. Here are the version numbers of the assorted pieces of software involved: ...more >>

I know RS doesn't offer this now. I'm trying to figure out a workaround. I need to: -run a report on a schedule -render it to excel -password protect it -email it Subscriptions would be fine if it weren't for the password issue. I've got DotNet code create the reprot and render ...more >>

My Reporting Services Web Site is on a Windows 2003 Server. The site has a dedicated IP address and SSL Certification installed and configured properly. We are using the Integrated Windows authentication method for security. Everything was working fine until I changed the IP address in Web site ...more >>

I have some reports with parameters that use queried default values. I am using them as a workaround to get data from the dataset into the page header. They work just fine when I call the report from the SQL Server Reporting Services web interface. I am having trouble getting them to work when ...more >>

How can I set the default units? I don't think in inches. Also, is pt the same as px? How are they different for this program? And what is pc?...more >>

Hello, Is it possible to use jump to url feature to call a stored procedure and pass a parameter from a detail line? Thanks, Jim. ...more >>

Hello, I have an installation of Reporting Services that is layed out as follows: Server_1 - contains the Report Server and Report Manager components Server_2 - contains the Report Server Databases Recently, I noticed on Server_2(SQL Server 2000 db server) that there are thousands of Sched...more >>

I have a problem that is hopefully solvable with MDX or with Report Designer. I'm building a nested report, with "Jump to report" navigation. One report takes EmployeeID and CustomerAccountID as parameters to query an OLAP cube. The query and report works when I just type in the IDs, but I have...more >>

I'm currentily in the process of comparing Reporting Services to Crystal Reports, and the one glaring difference, (for me at least,) is the fact that Crystal supports file based reporting, and SQL RS doesn't . Any idea if this will ever change, and when?...more >>

Is it possible to view reports via the Pocket Explorer provided by Windows Mobile Editon 2003 Second Edition? I can view the portal (Report Manager) but it does not display the report itself. Thank you MP ...more >>

Hi all, I have a report that has 2 groups and a detail section, arranged like this: Group 1 Header Group 2 Header details Group 2 Footer Group 1 Footer In my Group 2 Footer, I have an expression like this: =iif( Fields!ApprovedCapital_Project.Value =0,cdbl(0),iif(max( cd...more >>

I seem to be having trouble getting the cells to word wrap and resize the height when I export a report to Excel. In the report there's a cell where the text, on occasion, is longer than the cell width. When it's rendered in Report Manager (or exported to any other format (PDF, TIFF)) the text...more >>

Is there a report viewer for a window application? I need to plug a report into a Vb.Net windows app. Thanks. ...more >>

Hi - Can someone please explain the split of processing that occurs (i.e. what processing occurs where) in terms of between the Reporting Services server itself vs. on the repository server (if different)? Specifically, we see that there are many scheduled jobs in the SQL Agent on the reposit...more >>

What is everyone using to represent a checkbox in their reports? All replies are welcome. Thanks ...more >>

Hello, I am trying to create a schedule to add snapshots of a certain report to report history. So in Report Manager, I go to History and create a schedule to to this. In my understanding, i need to create a job to execute this shedule. So i go to Enterprise Manager to create a job. But af...more >>

Hi All, I have a VB Application that lists all the reports on my report server in a treeview control. Now all i need to do is open a report when it is clicked on in my app.. What is the VB code to do this? Thanks Sanjeev ...more >>

I've added some extra columns that are returned in the dataset produced by a stored procedure. The problem is that they're not showing up in the expressions selection dialog. Is there a way to force it to update?...more >>

I have set up a report with a standard email subscription. The report is set up as "renderfrom snapshot", the subscription is set up with a snapshotUpdated trigger. When I create a snapshot by checking the "create snapshot when apply is pressed", then the emails are generated just fine. I h...more >>

I have the following scenario: Machine 1: IIS Server - running Reporting Services Machine 2: SQL Server - stores all data that a report will use These servers run in a Windows 2000 Active Directory domain. The IIS web site has the directory security set to Windows authentication and An...more >>

I have an installation of SQL Reporting Standard running and I have both the report server and Reports directories configured to NOT allow Anyonymous Access and to use Windows Authentication. When we access the report manager internally (ie. inside our firewall) by going to http://reportser...more >>

Hi everybody. I've to make somthing like a table in RS, but instead to habe dynamic rows, i would like to have dynamic columns. I see that it may be possible with matrix, but RS told me that i can only have grouping expression in my cells, and i don't want it. Thanks four your help. -...more >>

Hello, I have the same problem with Reporting Services and Linked Server. The Reporting Services receive data source from stored procedure, which executes inside it stored procedure on the Linked Server. If Reporting Service successfully forms the report, then everything is OK, but if there ...more >>

Hello, Is it possible to configure a report so that certain users have the possiblity to select all the parameters (administrators) and that the others (employed) can selected only part of the parameters? Thanks for your help Nico...more >>