I am trying to write my first data processing extension. The project is based upon the Event Log example in chapter 13 of Hitchhiker's Guide to SQL Server 2000 Reporting Services. The assembly has been copied to the various directories and the various config files have been modified. The exte...more >>

'With the introduction of Windows Web Server 2003 you cannot have SQL Server installed on the same machine (big time security issue) it must remain separate on it own server then how is a customer to run SQL Reporting Services letting them directly on SQL Server? Is there a way ...more >>

RS2005 ships with a version of visual studio 2005 for report development. What if I have visual studio 2005 on my local machine. How can I add the rs2005 shell locally? Are they any license issues? Thanks...more >>

Does anyone know of a way to completely reinstall reporting services? I tried to do it through the SQL Server 2005 install and at somepoint it told me the only way to modify/reinstall an existing installation for this component was to do it through Control Panel > Add/Remove Programs. I tried t...more >>

Hi all, Does anyone knows how can I add some javascript code into the html page which contains a report into the report manager?. Let's the following scenario, suppose that any user wants to execute some reports from report manager, first the user goes to http://server/reports after that he/...more >>

I currently have a windows service written using VS2003/.NET 1.1 and = this accesses reports from an SQL2000RS server and distributes them via = email. My customer wants to use SQL2005RS in order to facilitate end-user = report creation; is it possible to access SQL2005RS from .NET 1.1 as I = ...more >>

Hello, I am trying to dynamically create a Page Break in a Group using a parameter (Parameters!GroupBreak1). I tried entering the following text into the <PageBreakAtEnd> element in my <Grouping> element: =CBool(iif(Parameters!GroupBreak1.Value = "true", true, false)) I also tried wi...more >>

I suspect the answer is "yes - any modern reporting tool allows this" - but I need to ask anyway, so please bear with me :-) Given a report which contains 2 tables (or lists) - both of which have a dynamic number of rows - as the creator of the report, do I have good control over things li...more >>

I am a RS newbe, and I have common reports but different data sources. Is there a way to modify the data source for an instance of a report without changing the values in the ReportServer database? -- Bob...more >>

How can I set the default e-mail address (fully qualified name) when creating a new report subscription? (i.e. john.doe@ipc.org)? Can you create a history report if there is no default parameter available? Thank you. ...more >>

I have given subscription access to a domain group in reporting services. Well when the users create a file share subscription and the subscription launches they are getting the message "Failure writing file .pdf : Error impersonating user." Thanks, -- Andrew MCSA,MCDBA...more >>

Hi everybody, does anybody knows, if it is possible to pass input from an ASP-page (not ..NET) to RS and populate the dataset with the given values? We are trying to use the RS so the user is able to print out, export to excel or pdf AFTER he/she did the collection of the data. For example ...more >>

Please try this if you want... 1 For a .RDL file, right click on the file its self and select "properties" 2 Click the "Summary" tab and enter information in any of the text fields (Subject, author, ....) 3 Save it and then copy the file on another computer, is your metadata missing j...more >>

I have a stored procedure that takes the user name as a parameter and returns the list of reports that belongs to the user. I need to show this list in a drop down box. When I tried to do this, i get a "forward dependency" error. Is there a way customize the list box so that it takes a paramet...more >>

I have an XML file that I receive from a vendor and would like to report from this data every morning. Can anyone send me a link where I can do this? I do not have a schema at this time but I think I can create one if needed. Thanks Scott ...more >>

Hi all, Does any version of Reporting Services support embedding vector based images (such as EMF's, or WMF's) into Reports? Rob ...more >>

I have a report that I want to create and I would like to know the best way to lay it out. I want a report that looks like a full page form (i.e., like a survey form). Would I use a table with many detail rows for each row I want on my report or is there a better way?...more >>

I am using a custom assembly. My assembly has to read a particular file and take some values from it. I set the required permissions and everything works good. However I dont want to hardcode the location of my text file. I decided to put the text file in the same location as dll file i.e in...more >>

Hello All, I am having problem with attaching stored procedure to the report. I have a stored procedure whose output is in temporary table whose columns are not fixed, it will increase depends on condition inshort its an dynamic table. I want to attach the output of this SP to Report inshort ...more >>

Hi, I am trying to create a Matrix with each dynamically created column having a differnet background colour. Any ideas on how to achieve this ? If I could access the column number some how I could just apply conditional formatting based on the column number, but I cant seem to find out ho...more >>

I have a report server (separate box) and a SQL Server (separate box). I have a report that uses a stored procedure to return a dataset. The stored procedure tests for parameter errors and returns an error message if any parameter is not correct. If I log into the report server it returns e...more >>

Hi is it possible to work on with in .net 2002 IDE with reporting services. If yes, than what extra i may need to install? Thanks in advance ...more >>

Dear all, i need to extend the functionality of the textbox in reporting services to implement text justification align. i made a research and found the concept of "custom report items" but it's implmented as image i also see the sample of polygonCL in SDK extention samples i am aski...more >>

I'm having problems with extra pages when doing a page break on a group in a table. I know this is a problem in SRS 2000, but are there any work-arounds for this?...more >>

Hi. I';ve had an installation of reporting services running fine for months now. This morning, I started getting the following error when trying to access the report manager: "Unable to communicate with report server. Please verify that the report server is operational" Also, the Report...more >>