I have posted this before as well and seems like no one has any solution for this problem (even microsoft). Posting it again please help me, see below. I have two reports(lets say Report1 and Report2) and both have filter parameters as start date and end date. Report1 has drilldown ability...more >>

I really like the data driven subscription functionality but I'm having trouble with the nitty gritty of customizing subsctiption email content. Here's my example - we send out a report each week to those who have not booked time against our project management system. I want to include a h...more >>

I've installed reporting service many times and it worked well until yesterday I installed the reporting service to a different directory (D:\ drive.) The sql server is installed on D:\ too. When I tried to open a report solution, I got an error message "D:\MSSQL\Reporting Services\Samples...more >>

Hello All, I have a table with 2 groups in my report. When I edit a group I can specify the expression to "group on" for the groups. I would like to be able to make the expression, for the top group, a value from a report parameter so that the user can specify this when the report is gen...more >>

Hi, I need to display the total of all series at the top of each stacked column. E.g for Jan, sales for item 1 is 20, item 2 is 15 & item 3 is 50. Instead of showing 20, 15 and 50 respectively, I need to show the total 85 at the top of the stacked column. However, I can't seemd to find any wa...more >>

Will RS 2005 integrate well with whidbey membership & profiles? David ...more >>

I am trying to run reports from a web application. If I am on the machine with reporting services then the report will pull up. If I try from a PC that doesn't have reporting services I get a "Page cannot be displayed" error. I have checked permissions on most everything I could think of. Ple...more >>

Hi, I have in the same server SQL Server 2000 and SQL Reporting Services, my question is, if i uninstall the SQL Server 2000 this affects the Reporting services performance? I don´t know if the reporting services uses some file, dll, etc of the Local SQL Server. By the way, My Report...more >>

When I run the web-based report viewer (http://url/ReportServer?<parameters>), it is caching the results. I can go to another part of my web app and change some data, but when I go back to the report, it doesn't reflect changes. Also, if I change the report and redeploy from Vis. Studio an...more >>

Have a report containing a single matrix. Have narrowed the matrix to 2.5 inches wide and specified 2 columns in the report layout. I am aware that previewing the report will only display data in the first column and that's what it does. However, when I Print Preview or Export to PDF, I stil...more >>

I have a column chart where each value has a URL Navigational action associated with it. Originally the navigation worked just fine - no problems. However, I noticed that the 3-D graphical effect of the normal columns was rather chintzy so I added the Cylinder property to the columns; they...more >>

I have a test program that attempts to call the LogonUser operation via SOAP. All it gets back is an HTML page (not a SOAP error response!) saying there is a configuration error. The log file contains only this: aspnet_wp!library!dd8!03/30/2005-13:41:42:: e ERROR: Throwing Microsoft....more >>

I want to do a visibility check. If I'm looking at the first page of a multipage report, I want an item to be hidden. If I'm looking on all pages except page 1, I want the item to be visible. Is this possible? How? I've tried creating a page footer, and added a textbox which shows the page numbe...more >>

Does anyone know if there is an escape sequnce you can use in Report Definition Language? Some data I'm including inside of a tag contains the '>' character, and it appears to be confusing things. I'd like to retain that character by escaping it. Thanks....more >>

I have a report where I added a reference to System.Web and in the Code section, added a function to accept a string and return a hash using the System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(strInput,"md5") function. It works great in the IDE, but when I deploy an...more >>

I have a subreport with a single dataset, parameter and bound table. The subreport may return zero rows to the parent report. I have tried several ways to generate a "No data" message in the location of the subreport on the parent report, but to no avail. Generating the message in the subre...more >>

I was just wondering if SSRS will support geographical mapping in the 2005 version. I know there are ways to get around it now, but does anyone know if the 2005 version will support maps out of the box? Thanks. ...more >>

I am using a lot of "BookmarkIds" and "Jump To Bookmarks" in a certain report to Navigate around. There is a menu at the top of the report that allows you to hyperlink down to more detail below. Problem is this: When I hyperlink from the menu (at the top of the report) down to more detail, I exp...more >>

Hi, I'm trying to create a line graph/chart in reporting services. I have 2 stored procedures that outputs the count of 2 tables that created 2 datasets. Both these procedures use a field called acctdates. I'm trying to use the acctdates as the catagory field and the 2 counts i...more >>

ReportManager ok button doesn't work, I access the reoport manager http://213.63.184.203/reports apperantly everything is ok. But when try to create a new role the ok button doesn't wok. What can be wrong? Thanks in advance Maria João ...more >>

When I click a drilldown [+] on a report in the browser the page starts at the point where I start (click) the drill. Everything above the click-point is above and I have to scroll up to see it. Is there a way to keep the heading visible on a report using drill? ...more >>

I have my logo in the page header. How do I get my logo to show on all pages of the report?...more >>

When I export to a file, say excel, I want certain textboxes to not show up. How can I hide them on export? brad...more >>

I need to create data reporting forms that does not necesserily have repeating rows, but are composed of field names (test labels) and values (read/calculated from database fields) scattered on page (similar to a manual data entry form). I can do this with Cristal Reports but is this possible ...more >>

If I set visibility = false for a subreport, does the store procedure associated with the subreport still execute? Thanks,...more >>

Is it possible for Reporting Services with SP1 to use a port other than 443 for SSL? Our web server already has a web site running on port 443 which we can't move. ...more >>

I have an application that generates rdl and deploys them. Users could use report manager and set credentials on the data source( integrated with reprot) and subscribe to the reports. How could i maintained the user entered data while the report is modified through my application and would lik...more >>

Hi, I'm using a script (through rs utility) to automate the creation of a lot of subscriptions. Everything works fine if I don't use a parameter in my report, but when I use it I always get the Error Code "rsInvalidParameters", with the Error Message "The value of parameter 'Parameters' ...more >>

Folks, I have a font problem when exporting a report to a PDF. It looks good when we look at the report in ReportManager but when we export it to PDF, PDF gets a different font instead "Arial Narrow". My goal here is to find this is some thing to do with ReportingService configuration? Or ...more >>

When creating a Report using the Report Wizard you are asked to select a Table Style from Bolb, Casual, Compact etc. I read somewhere that you can add your own Table Style by editing a XML File, but I can't remember where or what the XML File Name was. Does anybody know? Many thanks in ...more >>

Hi, When opening the reportmanager (via http or https) I get the following error: "The underlying connection was closed: The limit set on the message length was exceeded. " (it directly loads the page https://machine/reports/Pages/Folder.aspx) We are using windows 2003 server. The re...more >>

I have a report that reads from a view and in the report parameters I am using "like <param value>%". The problem is that some of the values in the datbase are nulls and I need those returned as well as the non null values. Any help on this would be greatly appreciated. -- Jerry...more >>

I am fairly new to Reporting Services. That said I have created a report that runs daily and via a subscription sends the report as email. This works fine day in and day out, however some days there is no data for the report. On the days when the report contains no data I don't want a blank r...more >>

Dear Friends I had worked on C# code to RENDER the report in PDF format. Also i had these PDF file in a shareable folder of application server. I was looking forward for any one solution : a) I was looking forward to print the PDF file in client by connecting to server and starting this pr...more >>

Hi All, I have a text box with static data, I need to hide the textbox based on the condition, if =Sum(Fields!TotalSessions.Value) > 1 then I need to show the text box else I need to hide the text box. How to write the condition and where do I add the text to the text box. Balaji -- ...more >>

Hi, I have a report to start with. From that report i want to navigate to another report, where i have to choose from a parameterlist. When i do this i get an error, that i have to give a default value with it. But i don't want to give a value with it because i want to choose from the list....more >>

I have a very simple report which generates a large amount or rows - 63,000. When I run the report all goes to plan and the data it brought back and I can page through its 1336 returned pages. But I need to be able to export all of this data ro excel, but when I try it works away for a bit bef...more >>