I am using RS SP1, and to use a hidden parameter that is NOT read only, after uploading the report into report manager.. at this stage the report works FINE, with all the other parameters (not hidden) working, they are combinations of query based lookups with query based defaults, and ones with ...more >>

I'm using a parameter stored procedure for which I construct the SQL in the stored procedure. I have an ASP application that build a csv string of values that I pass to the procedure. RS doesn't recognize the field in the select. What is another way that I can build a query and get RS to re...more >>

If not, can you give me an idea how extensive the changes will be? Thanks, -Steve ...more >>

I have a report that I just created that has a month and year parameter. this report is needed at the first of every month to show the activity of previous month. I would like to create a subscription that executes this report automatically. Can I set up reporting services to automatically ru...more >>

Can I cause a report to be rendered and printed using a URL?...more >>

I cannot find a simple string or number within ANY and EVERY Excel file and the only pdf I have EVER exported. My colleague System Administrator has tried DOS and Search... also to no avail... I have tried DOS, Windows Explorer Search..., Copernic Desktop Search and MSN Desktop Search (Beta -...more >>

All, One of my dataset queries is an MDX statement that includes a StrToMember function to determine a time member. The function itself includes a number of quotes. (i.e. StrToMember("[Time].[All Time].["+ltrim(str(Year(Now())))+"].[Q"+iif(Month(Now())>=10,"1"....) The query runs fine until...more >>

Hi have a problem with config. I am tryin to deploy to a remote server. I am using SQL authentication. I have identical usernames and password for a Windows account and a SQL account. When I open <server>/reportServer, after passwd auth, i get the list of all reports and I can click on th...more >>

I have a report with one group level where I am hiding detail and only showing group totals. This report is summarized/grouped by device (like a system name) and I am trying to calc the total number of devices monitored which would be equal to the number of groups I have on the report. I hav...more >>

I have multiple reports being sent to various clients. I need to change the from address on each report based on report's category and client. Is there anyway I can change the "from" attribute of email report? I checked the RSServerConfig.xml, and looked the Email configuration section, but...more >>

I am using the current formula and it works. #,###,;(#,###,) How do change this formula to display the zeros as dashes? Thanks in Advance ...more >>

Hi, I am not sure if this is possible or not, but here it goes. I currently have 3 different chart reports, say 1, 2, 3. The users of these reports pick which report they would like to run from a drop down in the application. The remaining parameters for all of the reports are all the ...more >>

Brian, I have posted this a few times and am not able to get a response from it. We (and some other people in the newsgroup) are experiencing an issue where when you export to Excel the last row can come up missing. Is this being addressed in SP2 or a hotfix? Regards, -- Chris Hanle...more >>

Hello, Can someone plese comment on whether or not this is being addressed in SP2? Specifically, there are times when the Export to Excel causes the last row to truncate. -- Chris Hanley...more >>

There are definite areas where RS could use improvement. Is there an active wish list to submit suggestions? ...more >>

Hi, I have just reinstalled Reporting Services on win 2003 server that was added to a domain and has been renamed. Two strange things happen: 1) In IE I am prompted for an ID and password with a basic security prompt. 2) After supplying the credentials I get some of the report manager web p...more >>

Support for Rendering Reports in a Winform appears to be missing - no render component (a.k.a. Crystal Reports). It seems the report must be downloaded (PDF or HTML) as file then open Adobe or IE to view. More work yet to view within Windows app. What is best approach and are there any ...more >>

I have a report with two subreports in a table that run fine. But when I try to export the report to Excel the two subreports don't show. I get a "Subreports within table/matrix cells are ignored." message. Is there a way around this? Thanks! Jean ...more >>

Especially in a multi-server environment where I have RS installed with separate servers for the DB and IIS Report Manager. I'm guessing there's some kind of @@version or version number hidden somewhere, but where? I am inheriting a deployment from a previous dba and I don't know if SP1 was...more >>

Hello, Has anyone succesfully setup the Printer Delivery Sample?? I have followed the instructions I have found on this however it keeps telling me that the printer is not installed. I do have the printer installed on both the workstation and server. I have followed the instructions given bel...more >>

Hello, I have a subscription that sends a web archive report to my email address. When I view the report in Outlook 2002, I am prompted with a Windows login box. The report cosists of two tables and a chart. In addition there is a 2k attachment with a long name consisting of number, lette...more >>

I am trying to set up a data driven subscription where one of the fields returned from the query is sent as the content of the email. This works fine for a one line email by selecting that column in the Comment field of the delivery extension screen but I need to create a multi-line email. ...more >>

Hi, I have created numerous reports using reporting services so far and studied every thing I could regarding performance. I have a question regarding caching the results of a more general query Vs dynamic query with parameters. Say I have a report which takes up different parameters. Which w...more >>

In my report I am using 4 parameters i.e UID, LocationID, StartDate and EndDate. I am passing the UID parameter to a report in a URL. Based on UID, Locations will be displayed. I don't want to Show UID on the report parameters header, But I want to show all other parameters on the report, s...more >>

Hi, I am rendering a report in PDF Format when a user needs in my Web Form(on click of a button) When this report is rendered in PDF format, Is there a way to send him the report by Email. An Email has to be sent when a report is rendered by a particular user. Is there an option for ...more >>

Is it possible to use report parameters when calling a SQL Server UDF (User Defined Function)? Let's say that I have a simple UDF uf_test1 that takes one string parameter @P1 and returns the parameter value as its output. I have tried creating a simple test dataset in a report that uses a query...more >>