Hi All I am new to Reportin Svc. Can anyone lead me to proper documentation as well as Web site of this Reporting Svc, and how can I use it in conjuction of ..Net Framework.... Thanks Silent Ocean ...more >>

Hi all, I need to make the report orientation style as landscape, I tried to change the report height n width, it seemed to be working but I realised not when I exported the report to a .pdf file... the page was devided vertically into to report halves! any help?...more >>

Hi, I need to know how to generate a PostScript file from data stored in an SQL Server 2000 table. This is part of my college project which requires me to generate bank statements for customers in the form of PS files which have to be converted to PDF files later. Thanks, Satish....more >>

I have simple but big report (38000 records, 15 different columns). When I trying to export this report in Excel, RS stops responding and returns "Server unavailable". But CSV format works fine....more >>

I have HUGE problem with RS! I have big report (38000 records). After rendering, "aspnet_wp.exe" holds about 400 MB of RAM! And don't wish to give away for several hours!...more >>

Is it possible in RS2000SP1? I wish let user to hide (or show) some columns....more >>

I want to give access to my reports inside my asp.net application. ( a small portal application ) As users logon to portal, I will give credentials myself inside asp.net application for reports. I do not want users to access to ( http://server/reportserver ) If I restrict IP ACCESS to s...more >>

This may sound strange, but is there anyway to collapse a detail line on a report if all of the fields in the detail line are null? I have a report that has several levels of grouping, and it is entirely possible that all the fields in the actual detail line of a table will be null. In this...more >>

"Setup could not initialize the report server. You must manually initialize the report server before using it for the first time. For more information, see the Reporting Services setup documentation." I keep getting this error after an unistall - reinstall or Rep Services on 2003 server. ...more >>

Does anyone know if the security model in Analysis Services will offer anything better than that in SQL Server 2000 AS? Specifically will it offer a way to override the security like Reporting Services. We are thinking of using OWP, but want to manage the security ourselves, not Windows au...more >>

I have a report with several textboxes that contain a formula, such as "=reportitems!textbox2.value - reportitems!textbox1.value". In this case, textboxes 1 and 2 may or may not contain another formula, such as "=sum(fields!x.value)". My problem is that the original textboxes render ok, but ...more >>

Hi, I'd like to show a blank row after specific rows of my dataset. As I can't use expressions in row width or in any other layout option, I decided to include these blank rows in the result set itself. But the matrix object auto orders the row groups, so all blank rows came together instead...more >>

Hi! A customer of mine has the following requirement for a reporting solution: They have a set of predefined reports which can be created by developers during the implementation phase of the solution. But furthermore they also need the possibility to create their own reports during the li...more >>

I have a report that is run directly and also called by other reports, thus a need for both hidden and non-hidden parameters. As you know, in order to feed a hidden parameter in SP1, PromptUser must be checked and PromptString empty. However, this technique fails if there is another paramete...more >>

Is it possible to display parameters in a drill-through report? After drill-through from ReportA to ReportB, I need to display a "LinkTo" parameter so the user can select whether ReportB should drill-through to ReportC or ReportD....more >>

A Payment can contain multiple contributors My dataset looks like this: PaymentID, PaymentAmount, PaymentDate,Payer,PayerContribution 1, 100, 1/1/2001, Fred, 100 2, 200, 2/2/2001, Paul , 100 2, 200, 2/2/2001, Peter , 100 Now I am grouping on PaymentID to get a report that lloks like s this ...more >>

Hi all, I have a stored procedure with one parameter that I can successfully send a report parameter to and obtain results. However, I want to add additional optional report parameters as I do with Text CommandTypes. If I define an additional Report parameter and add it to the Filter tab,...more >>

Hello everyone, I am very new to SQL Repotring Servieces so please bare with me as I think this is an easy question. I have a report that uses an excel spreedsheet as a data source. I have everything working great except for one field on the report. What I need to do is count the number...more >>

I am embedding my RS reports into .aspx pages. If I don't have my webapp installed in the same website as reporting services(default) or my webapp resides on a different webserver than rep services none of my postbacks on my reports work. EG...If I have a toggle for a hidden row the toggle b...more >>

I have a date/time field how can I create a group on monthly basic? ...more >>

How to pass a parameter to a SQL store procedure?...more >>

Hello, My used-to-be-stable SQL server 2000 running on windows 2000 server has started freezing whenever I make attempt to open the enterprise manager. It does so at an interval of 1/2- days and the solution at this point is to restart the machine. This makes me to restart the machine at an i...more >>