Hi, I have reporting services installed on windows 2003 server. Embedded Images do display in designer preview, but they do not display in Report Manager or browser. When I use localhost instead of my machine name in report url, then images are displayed. I have installed service pac...more >>

I am using the reporting services web service (SOAP) and getting a 401 error access denied - this is using the defaultCredentials to consume the WebService The Reporting services webservice resides on one server and my aspx page on another. <identity impersonate="true"/> and <authentication...more >>

HI, When I type http://w2kserver1/Reports I get rsInternalerror with msg The profile for the user is a temporary profile and the same for http://w2kserver1/Reportserver. I'm not sure where to start to try to solve this issue. I am new to SQL Reporting Services, but plan to use it exte...more >>

Hi, How can I change the contents of a container reports page header based on the subreport that is being rendered? Thanks, John...more >>

Is there a way to reset TotalPages in a report ? I have successfully reset PageNumber using: http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx But would like to know if someone has figured a way to reset TotalPages using similar code.......more >>

Hi friends, When I tried to connect to a report server I am getting this error. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. The sql server database is on one machine with windows 2003 standard edition and report server is on another machine w...more >>

I get the error AuthzInitializeContextFromSid: Win32 error: 58 when subscriptions run, one to write to a share and the other is an email. This was all working just fine until I installed 2k3 sp1. Anyone have any ideas? Thanks, Sean...more >>

In the book "Hitchhiker's Guide to SQL Server 2000 Reporting Services" (page 297) says; Managing RETURN or OUTPUT Parameters 1. Create a report parameter and remove its prompt string completely so that the user is not prompted. 2. Give the parameter a default value and set its datatype...more >>

I have some fields for which I defined a link to an URL, but I couldn't find where to change the target, it opens the link in the same frame and I need to open a new window Is it posible? Thanks Ric ...more >>

Hello, I installed SP2 on one of the 2 reporting servers we have in our environment. Before the SP installation, Subscriptions were able to send the attached reports. Now the job reports an error. I set up the same subscription and reports to the server not running SP2 (with identical s...more >>

I have 15 Report Parameters. And I have all of them set up as drop downs. There is going to be times when the user selects all 15 and there are going to be times when the user might only select 5 or 6 Report Parameters. I want the parameters to be optional but I also want the parameters to ...more >>

I have a dataset that is created by a Stored Procedure that is cumulative of all values that I need to report against. The problem is that I need DISTINCT results of certain columns. To do it within the sproc would take a prohibitively long time and it would be ideal if I could do it within the ...more >>

I need a report to function differently when run on-demand, and when delivered as an Excel spreadsheet. Certain columns need to be invisible when run on-demand, then made visible as the user sees fit. When rendered as Excel, all columns need to be visible. Is there some RenderType property tha...more >>

Newbie question. I have searched the posts and have found a few that say the previous function works. The documentation in the online books is a little sketchy. Does someone have a detailed example? If not, could someone point me to more detailed documentation on this function? Thanks, ...more >>

This is the context of the error that occurs with every report we run: " Reporting Services Error An error has occurred during report processing. (rsProcessingAborted) Get Online Help The processing of sort expression for the table 'table1' cannot be performed. The comparison failed. Pl...more >>

We can design .rdlc in VS2005, and veiw the report in Report Viewer. Is it necessay to publish report to Sql Server in VS 2005? ...more >>

I recently posted this issue as a reply to Dajm (that was expericencing the same problem) but no one replied to us; so here we go again (I hope this does not bother any of you). I'm running RS SP2 on a Windows 2000 Server + SQL Server 2000 (all SP up to date). Localised language of OS & SQL...more >>

I have place the question for a while, but there are no answer untill now? Can not we do that?, I am anxious about that! ---------------------------------------------------------------------------- --------------------------------------- How can we contol the privilege of Drilling down? For e...more >>

Hello i want to send a email to my resources having a report as attachement. how can i achieve this task.? i dont want to use the SQL Reporting services email subscriptions. i am getting report as a stream object. and also dont want to write on disk due to some complications. Plz give me some ...more >>

Hi all, I'm having a problem with accessing a report. When I test it on my machine (2000 & reporting services installed on same machine) there's no problem. As soon as I try to access it vie the internet (I route through no-ip.org) then a window pops up wanting authentication. I want to ...more >>

How can we contol the privilege of Drilling down? For example: There are for sale area of a company. The manager of the company can view the total sale reoprt of whole company, and view the individual sales report of the four area. The sales can view the total sale reoprt of whole company, but...more >>