I have created a report that has optional (sometimes hidden) elements I then put this report as a subreport in another. When the subreport's elements are hidden, the size of the subreport in the main report doesn't adjust accordingly. Yet the elements of the subreport move up to take up...more >>

Hi, When I installed RS, I received an error at the end stating that the server could not be initialized and that I'd have to do it manually. So I tried running the following and received the resulting error.... Rsactivate.exe -c "C:\Program Files\Microsoft SQL Server\MSSQL\Report g Serv...more >>

I when setting the background color for a data point programatically, I want two colors. 'Firebrick' for bad values and 'ForestGreen' for good. So I have a simple global function to handle this. Sometimes though, for no explainable reason, even though my bar chart has green and red series, ...more >>

I am new to reporting services. On a detail table of my report, I would like to print a large comment field after each row. The comment should span the entire width of the table. (Sort of like the outlook preview row capability) Is this possible? Thanks, Denise...more >>

I have a matrix report with hierarchical grouping that i've deployed to several end-users. The report contains 3 tiers of column groups and their corresponding counts/subtotals. Initially, only the 1st tier's data is visible. The 2nd and 3rd tiers' visibility can be toggled by the 1st and 2...more >>

Hello! I am having problems retrieving list of fields when using stored procedure as Dataset Source. I noticed that Reporting Services can retrieve field list if stored procedure is trivial (simple select etc.). In my case, I am insrting into temporary table and after some manipulations ...more >>

Can some one pls let me know, how do I make RS to display the custom error page when there us error in report. Error could be anything like bad parameter data. Thanks, Mahesh ...more >>

What I'd liek to be able to do is display dropdowns (like the dropdowns in the standard reportviewer component with queried parameters (eg, values come from a datasource). For example Employee Sales Summary in SampleReports includes a field for employee name/id... which is automatically pop...more >>

A picture paints 1000 words (Well here's 6 words and a diagram of our configuration -- I hope its a enough.) ----RS----Firewall-----Website----SQL----Firewall---------------------- (internal) (DMZ) (Internet) How do I give Internet c...more >>

Where can I go to find out what error message 25602 means? Thanks for your help. Henry...more >>

I need one of my column titles to be "transfers". In that column, 8 of the other columns must be tottaled per row. Does someone have an example expression please? Thanks, Trint ...more >>

I am trying to test the Sample Printer Delivery EXtension. I have built the assembly and moved it into the RM and RS bin folders. My RSReportServer.config file addition looks like this: <Extension Name="Printer Delivery Sample" Type="Microsoft.Samples.ReportingServices.PrinterDeliverySample...more >>

Hello: RS Newbie here. I have created a report with a parameter that has an ALL value that should display all records when that particular parameter is selected. Here is the code for my dataset: SELECT dbo.Locations.Location, dbo.BuilderWO.LotNum, dbo.BuilderWO.WONum, dbo.Builder...more >>

I have a report that has a summary matrix containing all urls for a client which will drill to a second report which is a detail matrix that shows detail for the selected url from report #1. The problem is that when they drill to report #2 ... if they expand the matrix to show individual deta...more >>

I have a report in reporting services with a single level of grouping: Order > Items When I return the result the report is fine, but if I try to drill down into an order, the screen flashes (as in a refresh), and then pushes the item I opened to the top of the screen. It seems to b...more >>

Hey guys, Anyone know why my main report works but when i click on a link i've created on the main report to link to another report, the other report doesn't show up (IE just says 'done' and nothing is displayed)? The reports link and load correctly when i'm using the preview tab within ...more >>

I have a detailed report that needs a lot of inputs, and when I use a first report and use "jump to report" to pass in parameters, the URL is too long and IE does not open it. Any ideas? ...more >>

Dose anybody know if it is possible to access a DB table from SQL Srvr, and another table from Oracle in the same report? Is this even possible and if yes, how? Than you, Tigan...more >>

Please help me if possible. My report takes a parameter say "name". I want reports to be generated automatically for various values of "name" and each of the generated report should be sent as email to the person every month or so. How do I go about achieving this? I am very new to reportin...more >>

Will RS allow columns to be snaked, like a newspaper? I need to create a report like a price list or food menu with two columns. The second column's (on the same page) should pick up where the first left off. Joel...more >>

Hi, Does anybody know if (or how) I can have multiple pie charts on the same chart? (I'm using RS 2000 SP2) I have two fields in my category group, and four in my series group and I want two pies - one for each field in the category, each with four slices (one for each series). What ...more >>

When I try get a report from reporting services appear the next error: Reporting Services Error -------------------------------------------------------------------------------- An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection t...more >>

Hello, Is there a way to name Excel sheets when I export a report ? My report generate several sheets and I would like to name each one. Thanks for your help....more >>

hi, can you be more detailing? I've been following a guide from a book, there's this query: ="SELECT * FROM vProductProfitability WHERE (Year = @Year) AND (Mon thNumberOfYear = @Month) AND (Category IN (“+Parameters!CategoryStrin g.Value+”))” yes, like what you said, you created a ne...more >>

I am a novice of using reporting services in sql server. is there any tutorial for learning how to use the sql server reporting services in ASP.NET?? Regarding the license charge, i am going to use SQL server enterprise edition as DB server, is there any additional license charges if i use the s...more >>