Is it possible to simply add an .RDL to an asp.net project, and access the report dynamically without any report url or anything. I just want to pass the database authentication to the .RDL [reportViewer?] and a few parameters, and run the report. But I do not want the report to exist in a...more >>

Hello all, This is a really dumb question and I am sure that the answer is No, but I have to ask it to see what other options/solutions might be available to me. A client currently uses a Crystal Report Viewer control that allows users to email an exported report from a desktop application...more >>

Solution: This happens to me quite a bit...its because the designer removes the code that defines what values are passed to your stored procedure. You have to select the report you're working on > Right-Click 'Code' > Locate the <Query> XML tag...and you'll have to re-define the <QueryPara...more >>

Hi Group, We are using Win 2000, SQL RS 2000sp2 and SQLServer 2000(sp3) and we are rendering to PDF. In most of our reports, in the body we have a title and a description, followed by a table with a grouping structure like this: Title GroupHeader1 (visible) GroupHeader2 ...more >>

I have a stored procedure that takes 4 seconds to run. When I display the results from the stored procedure from a report, it takes close to 3 minutes if not more. What could be the cause of this? (There is a subreport dependent on this main report...but it is super small and super quick).....more >>

I need to create a table that has column data from one data source (i.e. olap) and another column on the detail row that has data from another data source (i.e. sql). Can this be done? Is there a way to 'link' the data from these two data sources - i.e. based on product#, customer#, etc??...more >>

Hello, if my company owns 6 processor licenses for Sql Server, am I able to utilize Reporting Services or is their a separate license?...more >>

Can the 120 trial of SQL 2000 Reporting Services Trial be upgraded later? If not, is it possible to download SQL 2000 Reporting Services? I was told Reporting Services came on the SQL cd when I made the purchase but now am being told that it is on a seperate cd and must purchase additional med...more >>

We are attempting to dry run a SQL 2000 to SQL 2005 upgrade. We build a server in a test lab with reporting services 2000, SP1 successfully. Backed up our production (reporting services 2000 SP1) ReportServer databases and restored to the test lab server. Now we get the following error in r...more >>

Does anyone have mac users that can authenticate to reporting services and view reports? I have several mac users who are upset that they can not view any reports in reporting services and I don't know enough about macs to be of any help. Any browser recommendations or settings would be appreci...more >>

I have seen post regarding this topic before, but none have given a clear or satisfactory answer. I understand that multiple data sources cannot be directly linked. This alone seems to be a major limitation to this product! The standard answer seems to be to use subreports. This does n...more >>

I am working on a SQL reporting services where I create a report which has eventID, computer name and date the events generated. My EVentID is of int datatype when i populate the parameters like this: SELECT EventID AS ID, cast(EventID as Varchar(30)) AS Name FROM Events UNION SELECT Null, ...more >>

Does Reports Services come with either Microsoft SQL Standard/Enterprise Edition or Small Business Server? Thank you...more >>

I have several excel reports that are generated nightly that I am trying to get into our Report Server. Obviously I (or someone else) could go into the Report Manager on a daily basis and manually upload the files. This is not really feasible though, due to time and resource constraints, and t...more >>

Does anyone know how I can connecting to an analysis services cube that is located on a different server/domain than the one I am developing the report on. I am able to remote connect to the server and process the cube, however I don't know how to create a connection to the cube. I am worin...more >>

My name is Scott Moore, I am new to this group. I have worked with RS for the past year on a learn as I go basis. I need to find a good book for programming RS. I primarily work in C# and know that you can use code to create a report in RS. Unfortunatly I am someone that needs assistance in gett...more >>

Hi and hopefully thanks for the help. I have some issues with regard to deploying reports that I can design and preview. When I try to deploy I get the 'no report server found' at the directory I have created in IIS. Is this to do with settings in the virtual directory or something else...more >>