Is it possible to jump to a bookmark on a report other than the one you are viewing? ...more >>

Hi: I need to upload files to our SQL Reporting Server programatically. A legacy application creates a pdf file on a daily basis. While I can manually upload the file, I would like to automate this process. Any ideas on how I can do this? I have seen some threads pointing to a utilty ...more >>

In the RS help documentation, the ListChildren method notes, "If no children exist, this method returns an empty CatalogItem object." So, I'm wondering how can I detect if no items were returned from my ListChildren call. I though something like this: Reports.ReportingServices.CatalogIt...more >>

I am trying to nest 2 data regions. I have two data tables using a different dataset but using the same data source. I am trying to nest these and I've put the second data table in the group footer of the first. How can I have the second data table work properly and filter by the current ...more >>

Well, I found a solution. I had to add permissions for ASP.NET user. But finally, after opening the page http://<ServerName>/Reports I got another error: "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The system cannot ...more >>

Hi, How can I make an export pdf file on landscape direction? thx. ...more >>

Hi, If you have a matrix with one group and 4 columns, and you select subtotals, is there a way to NOT display one of the totals in the subtotal row? Thanks ...more >>

I have a report that uses one data source connection, and the parameter drop down list requires a different data source connection. After the report is deployed, I want the report to use shared data source. I can only change to a single shared data source through the report properties on the...more >>

Hi there. I've read on the web that Reporting Services report can support ActiveX controls in the client area of the report (or at least that's what I interpreted). I'm able to add an in-house developed ActiveX control to the toolbox in Visual Studio but the control is grayed out and will no...more >>

Hi, RS is great - for a first release it's quite astounding. A few tweaks would make the designer first class: a) A box in the footer on the far right often renders in the middle or the right of the footer if I dynamically show/hide other elements in the centre of the footer. Oddly, this ...more >>

We have setup Reporting Services on a Server 2003 box with SMTP intalled on it. I am able to write a simple VB Script that uses CDO to send a e-mail out to a certain address (let's say to john@test.com). When I setup a subscription using the same e-mail address I get the error "The e-mail ...more >>

I have a report in which I'd like to display a phone number. Currrently, in SQL Server, the phone numbers appear as a string a numbers eg "4255551212" I'd like to display them with area code, then number such as "(425) 555-1212" I've tried playing aroud with formating options and I'm stum...more >>

We are currently setting up Reporting Services on a web server with a separate SQL server. Being new to Reporting Services, what risks are we being exposed to if SSL is not used? Has anyone experienced any security issues? Finally is there any alternative to SSL? ...more >>

Hello Can you add a grand total row to a matrix like a pivot table. Can you sum up results from a column in a matrix? Maybe add a calculated field to a matrix?...more >>

What is the best/easiest way to create a data-driven subscription programatically? Can I create a C# console application to call the ReportingService class? ...more >>

Hi to everybody. What I want to expose you is the next. (To begin, sorry for my poor english. I hope to make me understand). I have a Web Application (aspx) that is generating some reports using Sql Reporting Services. This application is running over a Windows 2003 Server. I would like to kn...more >>

Hi, Does anyone know if Microsoft is planning to support embedded fonts in the near future? We have been using Crystal Reports for our reporting. We are trying out Reporting Services for the new reports and we like what we see so far, but there is one major issue: embedded fonts. We ha...more >>

Hi . I am working with RS form authentication.I am fallowing MSDN whitepages. my Questions r (1) Is it possble to work with customsecurity without Using the Web Service implementation?if so how can i ? If no should i have adminsrtaive privillages on IIS (2) is it possible to call ...more >>

Hi Group, I saw that most of the people here fight with trying to keep a group toghether. Well, my problem is the opposite : I want the group to start right after the previous items. This is how the report looks like: <RptHeader> <RptBody> <Table> <Group_Facility...more >>

Hi there:- Anyone have any ideas on this one?? I was trying to implement the Form Authentication example (Using Forms Authentication in Reporting Services) from the MSDN but I am keep getting this error message “rsFailedToDecryptConfigInformation”. I followed all the necessary step...more >>

Hi, We have a question regarding the installation of RS to a WSS server. We have used STSADM to exlcude the site, checked the web configs for session state info present, placed the Report server web site in a separate application pool from WSS, applied Hotfix 859, and attempted manually activ...more >>

I created a Landscape Report for Legal Paper. When I export the report to Excel the report appears in Excel as Landscape for 8.5X11. Does anyone know how I can resolve this issue?...more >>

I am developing a single dynamic report in report designer and I have a small problem. My report has several parameters and I use MDX to query from a Cube(Analysis Services). Everything works fine until I want a field in the report to change dynamically when a user changes a parameter. Exampl...more >>

We started receiving these messages when asking the RS Web Service to serve up PDF files. The following code snippet streams out _Result to the client. _Result is being returned from the web service. Response.ClearHeaders() Response.ClearContent() ...more >>

Sorry if this is long, but if someone will have the patience to read it all he/she will probably find out that my problem is not so complicated. So here it goes: I'm building a report on a view that contains sales and budgets of products by Product category and month/week. The view has the fo...more >>

Hi, Im breaking my head trying to use a matrix........ :(( My first problem in having column headers for the static columns in the matrix, i solved it by using a table within the corner tag in the matrix,thanks to one of the posts here.... but when i export it to excel it throws a mes...more >>

Good day, I would like to know if it is possible to create a matrix report using an OLAP cube without having to write an MDX query. Much the same as with OWC where you could drag and drop. Please if anyone could help or point me in the right direction. Thanks ...more >>

Hi, is there an easy way to read within the RS-Report the depending datasource properties (e.g. Server, Username)???? Any ideas??? best regards BB ...more >>