Hi, The Report Manager web site is totally flawed in Mozilla based browsers such as Firefox 1.0. It is not good to have to switch to MSIE to use a web site in the 21st century. It not even as if it uses ActiveX. Some examples of flaws in case anyone in MS cares to address the issue are:...more >>

Hi, I have finally managed to get RS working on our servers. Now I have a few reports up in a folder called "Web Sales" and I now want to allow users to come and have a look. So, I did the following: Clicked through to home > Web Sales Clicked properties Clicked security Clicked on New Ro...more >>

How can I put a friendly name or tool tip on a hyperlink? This is the link I use in my graph, but I would like it to display the value when I hover. Thanks. ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=" & Fields!soldby.Value & "','popup','width=400,heig...more >>

I have indicated the field and set it to call the next report where I need to pass 4 parameters. I also set the fields parameters to the values to be passed (2 of these are parameters in the calling report and 2 are fields on the calling report) I set them up on next report's parameters to ...more >>

Do I have to reboot after changing RSReportServer.config? I am working with the alias and host names. I have the alias set to true, but it only puts in john_g. I need it to add '@domain.com' Can that be done in the config using the DefaultHostName? If so, just put domain.com in? Than...more >>

Hi All, I searched for this, but couldn't find anything, so bear with me. I'm also not a huge SQL expert. I need to use a variable in the WHERE clause like so: SELECT * FROM... WHERE @Newsletter IN (N'Subscribe', N'Unsubscribe') The deal being that each newsletter has it's own field ...more >>

Greetings... I have a report that is going to be distributed daily. I need the subject of the email to be something like, 'Sales Report for <date>' where date is the date it was ran for. I tried using the report parameter but it only gave me the parameter name, not the value. Does anyone kn...more >>

PREFACE: I have a field in my SQL Server database that is called "Ink" and is Text as the datatype. I have put into this field a Base64 String which represents serialized digital ink collected on a Tablet PC. I wrote a small piece of Custom Code in the Report to de-serialize the ink and...more >>

Hi there, We have ASP.NET application and we want to use SQL Server Reporting Services to display the report links to the end user. Report Server however won't be accessible from the internet for security reasons. The server side code in ASP.NET pages on the IIS server can access this repor...more >>

Hello, I have been working with Reporting Services for several months and really like it. I am using Visual Studio .net for developing reports. I have noticed a long delay when changing between the 'Layout Tab' and the 'Preview Tab'. The delay is between 10 and 15 seconds which may not seem like ...more >>

Is there a way to control the width of the columns that are produced when using a column chart?...more >>

We have the following setup: Machine 1: IIS - Reporting Services (with Reporting database on local SQL Server) Machine 2: SQL Server (Holds the data to be reported against) A share data source has been created pointing to Machine 2. It is using "Credentials stored securely in the Repor...more >>

How do I set the detail row to show all similar records? I created another report with same exact query and it shows all 25. Thanks, Trint ...more >>

Hi! Can someone tell me if there a way to determine the server and database that a Reporting Services's installation is using? Thanks in advance, Bob...more >>

Anyone know where I can find a sample RDL that is styled like an invoice form? Header - contains Sold To/Ship To Detail - Invoice Line Items Footer - contains invoice totals TIA Tina ...more >>

I open a report in a new browser and set the URL parameter RC:Zoom=PageWidth. The problem is when the user clicks and opens a linked report - none of the URL settings are inherited. How do I make these settings persist? Thanks...more >>

I am working through the issue of email not working through subscription, which seems to be an issue for many after scouring this forum and the net over the past few days. I have a 2003 Server running with RS, SP1 installed but I keep getting the error that the server saying ... "Failure sendi...more >>

Is there any way to localized parameter prompt? Thanks, Eric...more >>

I have a dot net web application that needs to, eventually, send a report by e-mail It doesn’t have a scheduled behavior. Is there any way of processing subscriptions from asp.net? Thanks! ...more >>

I am building a MATRIX (Cross tab) report where I want to show the counts by a provider by each month. Some of the months, a particular provider( parameter) does not work so that month should be shown as NULL or a ZERO.. The problem is that my join to the dictionary is based on this parameter ...more >>

I have a report, which contains student details and the courses to which the student is registered. I have 2 datasets, one which retrieves the student data, and another paramaterized report which retrieves all courses for this student. What I need to do is set this parameter to be the studen...more >>

I have a dataset that is comprised of several records of employees leave types and hours. Each leave type record is unique(sicks on record and vacation another). 2 fields of each record,I group on (Employee and TimePeriod) and the Leave type hours I want to display in separate columns. What ...more >>

hi everyone, I learnt from one of the treads here that inorder to export the report to pdf in a single page we need to set the width and height to be 11in and 8.5in.But when i print the report after exporting to pdf,it prints in the landscape mode.how Can it be made to print ...more >>

Hi everyone, Is there a Print Icon in the report viewer?Clicking on which the report has to be printed.If not,Can v had our custom icons in the report viewer. Thanks in advance.....more >>

Hi, Can I install reporting service to non-default IIS Web site? If Yes, How? Thanks. Sara...more >>

Good day, I hope some one can help. In the past I have used OWC to create much charts for the web but now see the light and have started to use SSRS. Only on thing though, is it possible for a SSRS chart to have trend lines. It is critical that I have trend lines in my chart, what the MD wa...more >>

Hi, Can anyone tell me how i change the print range of a RS report. My report is fine when viewed, but when i select print preview, it chops off a lot of the report and places it on a separate page. Is there any way of setting the entire report to prin on a single page? Also, how do i ...more >>