I have about 5 tables on a report. Is there a way to insert a break between the tables to prevent tables from being chopped on a page break? Thank you! ...more >>

Hi. I'm using Reporting services for my company's web site and it worked fine until I tried to activate SSL : now when I try to deploy new reports from VS.NET I'm asked to login to https://www.mysite.com/reportserver and no credentials are accepted. Debugging from VS.NET I can see a call withou...more >>

I am using DB2 as my datasource. I have a query that takes 10 sec. I needed to add report parameters to this query, so I converted it into an expression. However, now the report is taking longer than the original query - just because I converted the query into an expression... Has any...more >>

I have two datasets in my report with some common column names. If I drag Col1 from Dataset2 onto a detail line in a table, the formula looks like this: =First(Fields!Col1.Value, "DataSet1") (I don't know why it defaults to First on a detail line.) I want to print every row so I have to get...more >>

im having problems, when i render a report inside of the report viewer control it seems to ignore all page breaks, but if i export it to tiff it renders them well, could subreports be the cause for this? ...more >>

Hello, This is my scenario I want to set up reporting service for multiple users to use. Each user will have full control to their own folder but not others folder Requirement - Create SubFolder - Add report - Add Data Source Optional - Add subscription What is the best way...more >>

(Reposting, reworded) I am writing a C# Web application with a web form that displays a report using URL access method. The URL displays the report for the user, and then they can pick their parameters and run the report. I want to know: how can I display the report to the user the next time...more >>

Has anyone seen this execption before? If so, what does it really mean? The parameter value provided for 'snapshotID' does not match the parameter type. --> The parameter value provided for 'snapshotID' does not match the parameter type. --> String was not recognized as a valid DateTime....more >>

I'm trying to create a Scatter Chart to show a distribution based on data from a database. The x-axis is a time-series and the y-axis needs a running number (like rownumber). However, the rownumber aggregate function does not work, or my understaning of rownumber and how the chart uses it is w...more >>

I don't get it. I'm trying to use Reporting Services to deploy my reports. They always "forget" the datasource. I can run it on my local machine but when I move it up to the co-lo it will work for a while and then it will just fart. and forget the datasource I try to set it through the admin ...more >>

Hello! We are using a SortBy parameter and a Direction parameter for our report. We are using dynamic sorting to allow the user to click on a column header and sort that column. A click checks whether or not it is sorted asc or desc and if it is, it changes the sorting to the direction it isn...more >>

Hi, I was wondering if it's possible to change the color of the gray border that appears around the reportviewer window when viewing through a browser. I would like to change this to navy blue to match my company's color scheme but all I'm able to do through the style sheet is add a blue borde...more >>

It is my understanding that data items can not exist in a header (or footer). Yet in multi page reports it is often a requirement to reprint a heading that has data in it. What is the best way to address this issue? Thanks, Gary ...more >>

Hello. I'm trying to conditionally count a field, for example: iif(Fields!GrantCodeID.Value = 70, 1, 0) GrantCode is a field and whenever it equals 70, I want to count it so I can display the count after the detail. Any help is much appreciated. Thanks!...more >>

In my table I have a Group that has 4 different filters, yielding 4 different results. I use a Count to display the total of these results for EACH result (4 totals). What I really want to do is display only the TOTAL total of these 4 groups. If I didn't explain this clearly here is an examp...more >>

What is the best way to let the user choose report parameters and then save them? When the user looks at the report with saved parameters again, it should show refreshed data for the same parameter selection. I know how to pass parameters to a report on the URL, but how can I find out what ...more >>

Is there any way to avoid text boxes in tables looking so bad in the Report Preview tab of Visual Studio? The characters are being cut off at the lower left hand corner, and it looks terrible! Products like Crystal are way better at giving you a WYSIWYG preview of a report, but I find this just ...more >>

Hi, I try to make a custom toolbar that navigates like the HTML toolbar. This should support going to next page etc. I'm trying to set the page in the deviceInfo string to pass it to the rs.Render method. I used the code like in ms- help://MS.RSBOL80.1033/RSPROG/htm/rsp_prog_soapapi_de...more >>

hi, can anyone suggest me some books on RS which describes in detail abt the analysis services action for RS Report and how to pass parameters dynamically from the url, from analysis manager... I need a book which can describe in detail. can anyone suggest me with a book. Thanks in ...more >>

hi, how can we pass parameters to the report dynamicallt thru the url ???? i'm stuck up there . could any one help me plzz ...more >>

How to show multiple resultsets (returned from the single Stored procedure) in a report? Syed Shahzad Ali ssali197@yahoo.com...more >>

I have several fields in the report that are concatenations of two or more datafields in the dataset. What we have found is that RS is padding out the fields to the full size from the database, so if we put together, it doesn't look right. For example, if I go to put firstname and lastname to...more >>