Is there a way to determine the total number of pages an HTML report contains when the report is fetched using the Render method of the RS web service interface? Surely this must be possible; the URL interface displays the page count in the ToolBar, so the information is apparently known som...more >>

Some tips please on PDF rendering. I have an invoice form report that should be one page in length, but when I render to PDF I get a 2nd page with header & footer but nothing in the middle. How do I stop this happening? brian smith ...more >>

I have a report that is working fine on the server, and used to be OK in VS.NET (RS SP1). After, I think, adding some extra grouping logic, when I switch to the Preview tab in VS.Net all I ever get is a blank page. Other reports still work fine. Is there some setting that controls this? brian ...more >>

hello, I'm implementing a data extension and I need to have the connection "edit" button available (since I'm using a connection to SqlServer). I don't see any property/member from IDbConnection and IDbConnectionExtension. Thanks, Pierre -- ------------------------------------------- Pi...more >>

I have set up a Linked Report with default parameters which I would like to cache. Whenever I go to the caching section on Reports Manager and try this, I get this warning "Credentials used to run this report are not stored ...(cant see the rest)". When I toggle back to the same screen, caching is...more >>

I have added a button in "Body" section of the report. If I want to open a text file or a word document; is it possible doing this by clicking that button? The purpose of this is to open a document which explains and describe what report is doing. Thanks ...more >>

I am using Matrix table for one of my reports .. I would like to have three column groupings; where first grouping is default. Other two should be based on the parameter selection. If '<None>' is selected from the parameter option I do not want to show that secondary grouping. Is it ...more >>

Hello, I started yesterday working with reporting services to get done some complex reports but I've encountered a lot troubles. For example, I created one report and set both with and height for the body, then added one rectangle and inside of it, I dragged a Chart. Till then everything looked ...more >>

I've got an error message when i try to run the report Description: ! Exception of type Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was thrown. File: c:\report\AgencyStatement.rdl but when i run preview, it is working just fine. I don't know what to look for and where...more >>

Hi All, How I can access a Parameter field(eg - Parameters!vcReportVersion.Value) within in Custom Code. Public Shared Function GetParameterText() As String Return Parameters!vcReportVersion.Value End Function This function gives the following error message : "There is an error on...more >>

I have values on 2 Sub- Reports that I need to do reference on the main report to do a particular calculation. I was wondering if there is anyway that I can reference the sub-report values from the main-report without making a specific call to the database just to obtain the one value that I n...more >>

Hello, I'm creating a boolean parameter in Report Designer and set {Label = "Yes", Value = True} and {Label = "No", Value = False}. Then on Preview Page I see to radio buttons, the first one is labeled "true" and the other one is "false". Is this a bug? Can I set the labels I want to this radi...more >>

We have a piece of software that is developing reports, but we'd like to add some other things to the final pdf output (word docs, possibly another pdf). Is it possible to use the PDF renderer from Reporting Services for anything other than generating a report PDF? Thanks, Graham...more >>

Hello: Does anyone know of a way to add a print button to the report viewer component or some workaorund like that so that users can print from the browser without first having to export to some sort of format? Also: We are having a lot of problems with PDF rendering when it comes to borde...more >>

Anyone know about DPE? Specifically, I want to know if it can help me to make a data source dynamic in a multi-user environment. I need to integrate SRS into my web app, which allows the user to select a database from a list before running a report. Several people could try to run the same rep...more >>

I have followed the steps from the readme file in the PrinterDeliverySample sample. I can subscribe to a report and use the printer delivery pointing at a network printer but when the subscription runs, it generates an error which says that the printer is not installed. What is different in the...more >>

Is it possible to cache a version of a report, meaning say I pass a parameter "CacheReport" which is a boolean. Can I only cache this report when this variable is set to true?...more >>

While primarily I am interested in setting the rc:LinkTarget value for a report when using Report Manager, all of the rc: and rs: parameter settings might be useful to adjust via the properties page of a report in Report Manager. I prefer the use of Report Manager. I do not want to use URL acces...more >>

Given that dual y-axis charts aren't yet possible, I'm very close to having Pareto Charts created (column & line w/data labels), however, scaling the Y-axis of the 2nd series (the cumulative percent line) is turing out to be tricky. It could be solved by finding an answer to either question below: ...more >>

How do I toggle visibility of a group of columns based upon visibility of a group? Only when a group is expanded, this group of columns should be visible. I am using Table data region. Thanks, Kirti...more >>

When the page header properties are set as 'PrintOnFirstPage' = False, so that it doesn't show on the first page, it still seems to take up space on the first page. Is there a way to compress this space? The pseudo report header that I created in the body (to show up only on page 1) is showin...more >>

After several hours of sifting through the discussion group and reviewing a multitued of users with a similiar problems, I finally stumbled across a posting that provided the fix. My problem was that subscriptions (email or fileshare) where failing. The ReportServerService log indicated "...Win32 ...more >>

Hello, Is it possible to setup Reporting Services so that when each report is run the snapshot is saved for historical reporting purposes? So far the only way I can create historical reports is by manually clicking on the "New Subscription" button. Ideally we need a solution that will all...more >>

I put =RunningValue(Fields!FieldName.Value, Sum, Nothing) in a tables group footer. It displays the same total on every page. I put in a new details line on the table. It works fine. But prints itself all over page rather than once at bottom of each page. Help ! Chris Brooksbank ...more >>

I have a statement report. There is a table which contains the statement line details. The printout of this may last several pages. Assume it lasts n pages. The bottom of page1 should show the total debits and total credits for page 1 only. The bottom of page 2 should show the total debits an...more >>

Expressions accept VB.net run-time library Custom Code accepts everything that is available in VB.Net. Is there a list on MSDN of what this is? Obviously I am new to RS and VB so your help is appreciaited. thanks...more >>

A'ight, I'm having a heck of a time with subreports and parameters passed on to 'em. What I have is a list of items, and within that list is a second list. Within that second list is a subreport that should take the id number of that 2nd list entry and pass it to a subreport which is displayed b...more >>

Hi, we are changing at the moment our reporting system from crystal report to MS Reporting services. Our reports are highly customizable during display. In Crystal Reports we were using scripts into the reports to set the text align and the column back- and foreground color by user decisions. It...more >>

Is this possible? All of our users are required to login to our website in order to access their applications they have particular access to. is there a way to pass the same from variable to the first Report parameter. Currently i have it set up (development environment) that all report parameter...more >>

Hi, group I am trying to figure out how to filter out empty reports. I am writing a report that is delivered to the recipients whenever there is some data in the report based on the query criteria I specified. But the thing is that RS sends out report even there is no data in that report. C...more >>

How do I put the power of SQL RS into the hands of your average financial analyst or manager who doesn't know XML and doesn't ever want to use Visual Studio? Most of these people will still use crystal reports until they have their own report designer tool. I have read some predictions that 3r...more >>

I am currently using the global execution time in my reports, but I would also like to show the user what time they view the report. I guess in Crystal they distinguish between the two as "Data Date" which would be the execution time and then "Print Date" which is the date and time the report i...more >>

Hello, I am designing a SRS integration where the data source for a report must be changed depending on which database the user chooses. There are any number of databases, all having the same schema. The user can select which database they want to query in a drop-down list in the web applicati...more >>

I have read some threads about how to use an existing dataset or datatable from a .net program in SSRS. Data Extensions and stored procedures have been mentioned as ways to gap the incompatibility between .net and SSRS. What about creating a table from a datatable. Would it be possible to tak...more >>

Hello, Is there a querystring parameter I can use to hide the Navigation Pane on the MSRS report manager. I want to embed the "My Reports" folder into a frame, but don't want the end user to be able to navigate out of that page by clicking on the "Home" link or search. Anyhow know how I'd ...more >>

Problem: I need to add filters on a Dataset. The current dataset is based on a stored procedure that I would prefere NOT to touch. Question: Is it possible to build a new dataset based on the first dataset? (This would inable me to filter on the data output). Or are there other suggestions for...more >>

Is it possible to programmatically export a published report to a pdf file in SQL Server Reporting Services. I need to know if SQL Reporting Services allows that to be done programmatically in code without user interaction. If so can you point me as to where I can see some code samples or if a...more >>

Does anyone know how to pass a SQL statement to a dataset of a report? You used to be able to do this with Crystal and found it a really helpful tool. Any help would be appreciated ...more >>

Hi All, I'm having problems with the DateTime Locale in my reports. I would like the user to be able to enter a parameter, which is a date in the en-IE locale (Ireland) i.e. dd/mm/yy. The problem is that only en-US locale seems to work i.e. mm/dd/yy. So, while 06/13/04 works, 13/06/04 prod...more >>

I'm in a search for a solution. I need to keep a group together. If it doesn't fit on the same page as the previous group it should start on a new page. I cannot believe reporting services unable to provide this. Ok, table's grouping doesn't have keeptogether option (but the table itself has...)....more >>

Hello. How can I make an expression in matrix subtotal as (sum1) & "/" & (sum2)? Thank's....more >>

When trying to install Rs on Win2003 server running standard SQL2k SP3a I get into strange situation. On start of installation I get statement that asp.net and Visual studio are not installed or not running (they are installed and running) Than it proceedes to install Reporting services, goes thro...more >>

Hi Is it possible to use an output paramater from a stored procedure. I've had a few goes but I don't get any data returned. In the Data Tab when I hit the execute button and I fill in the input paramaters (leaving the output paramater blank) No data fills the data grid. But when I try to ru...more >>