hi. could anyone pls tell me how to pass parameter values on url to an olap RS 2005 report? i tried to do it as such and got an error. parameter name is AbsenceTypesAbsenceTypes parameter value is =[Absence Types].[Absence Types].[Absence Type].&[Absent Days] this is the link: http://local...more >>

Hi All, A quick question for the reporting services community. Is it posible for me to call a report (outputting to a pdf file) from a stored procedure? I understand I could probably achieve what I want using a ..net language but was wondering whether this was posible through SQL. I'm guess...more >>

I would like to know if anyone has a suggestion of a book for biginners. Reporting Services seems to be a very difficult thing to get informaion on. The only thing that has been remotly helpful has been information from people more expreianced. I would like book for reference. I ordered the boo...more >>

Greetings, trying to install sp2 on our reporting server, following the instructions I am trying to make a backup copy of the encryption keys using the rskeymgmt utilitiy, and when I run the command and reply to the verification msg, I get this msg back The local NT Service is disabled 0x80...more >>

Hi, my date settings on my system is set to british dd/MM/yyyy , however functions I use in the heading of the report like .... ="Received between "&CDate(Parameters!StartDate.Value) & " and " &CDate(Parameters!EndDate.Value) ..... keep returning the date in MM/dd/yyyy format. Any idea...more >>

Can anyone confirm the SQL 2005 reporting services Sep/CTP can work under Windows XP environment? I look at the services under Administrative Tools->Services, SQL Server Reporting Services (SQL 2005) is started. everything look fine, but when I use the Business Intelligence Development S...more >>

Is there a way to re-position the subtotal in a matrix report such that the subtotal is displayed at the beginning of the report instead of at the end. Currently: Q1 10 Q2 5 Q3 10 Q4 3 Total 28 Need: Total 28 Q1 10 Q2 5 Q3 10 Q4 3 Than...more >>

I have a horizontal 100% stacked bar chart. If I select Show labels and do not specify any format code, I get the integers from 0 to 100 (intervals of 20) displayed on the axis. I want to have them formatted as a percent, i.e. 20% instead of just 20. If I put P0 or p0 as a format code, the lab...more >>

Hi, I have a report with some parameters. Can the values users enter for those parameters for a given report run be saved in a Database? Basically we would like parameters to always default to the last values a user selected the last time he/she ran a report. Is this supported out of th...more >>

I have installed SQL Server September CTP (Full Install) on a Windows 2003 Server with IIS 6 setup with SSL. I have also installed Visual Studio 2005 (Full Install). I installed the custom security extension example that comes with the server install and the AdventureWorks sample reports...more >>

I think I am having an installation issue. This is the error I get The underlying connection was closed: Could not establish secure channel for SSL/TLS. I am using a server that already has a certificate installed. Any Ideas...more >>

Hi I have a colour stored in a database as a Integer. This value comes from using .Net Color.ToArgb() method. I am having trouble trying to convert this integer back into a format that I can use as the background colour for a text box. For example The System.Color.Red.ToArgb() = -655...more >>

If we use the CancelJob method anbd cancel a new/running report, is the underlying sql connection and process also cancelled/killed/released. I have not found any documentation on this and am in the process of setting up a test that will help me determine this. ===================== Thank...more >>

Hi I am new to Reporting Services Matrix report element and I am having trouble with subtotals. I want to add subtotals the "Person" in the following matrix report eleement. When I select the "Person" group and right click and select subtotals I get the following Product Person ...more >>

Hi, does anyone know an URL with an example of using "StoredProcedure" as "Command type" in reporting services. Normally it defaults to "Text" instead of "StoredProcedure" thanks, Ludo ...more >>

Hello, I keep my reports c:\Inetpub\wwwroot\MyApp\Reports\ folder, how should I set my ReportPath for report viewer to see it in my APS.NET application. Thanks, ...more >>

Hi All What do i need to set up reporting services? Is there anywhere i can get an installation procedure? Thank you in advance. ...more >>

When I open IE from a computer other than the local machine (Which holds both SQL & IIS Services) - and goto http://myreportserver/reports - You are prompted for username and password. Then the homepage comes up no problem. You click on a folder - you see the reports in a list. You click on...more >>

I have noticed a few posts here and have searched the web over to no avail. Would someone be so gracious as to point me (us) in the right direction? I know someone is holding back :-) Is there a way to validate user input parameters and return a custom (user friendly) error message back whe...more >>

Hi all, I'm expected to write some reports using RS-2000 and most of those reports want to give the user the option of entering one or more items for that parameter input box i.e.(me, you, them) and get a result set that finds all information related to (me,you,them). I'm using a stored pr...more >>

Does anyone know a way to gain control of the color palate to the point of picking your own colors and/or patterns? Also even using data driven colors? Thanks...more >>

I have a report with some of the parameter values in French. When I run the report from the view tab, selecting parameters works fine. When I attempt to create a subscription, I get "There is an error in XML document (1, 6319)". When I view the log, I see mention of an invalid character. W...more >>

Hello, I've been trying to create a report using a dataset filled with a MDX query. That query needs to have parameters (they come from report parameters). I've done everything, including what is described in msdn2 and still cant get it to work. (The problem is not with the query, if i sub...more >>

I have a drill down report with 2 layers that drills down. If I put =RowNumber(Nothing) I get the total number of rows returned. How would I calculate the numbers of rows per drill down layer? So not the total number of rows, but only the first group number of rows. I hope this makes sense. ...more >>

Should I create a new dataset in order to populate a multi select parameter drop down box for users? I am trying to capture all Companies stored in our backend database as a drop down selection to users. Thanks!...more >>

When deploying to a local report manager i.e. http://localhost/reportserver i get this error An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Could not load type Microsoft.ReportingServices.Interfaces.IRenderStream from...more >>

Well,i installed sql 2005 ctp septemper successfuly with RS. When I try 2 connect 2 ReportServer it fails and i get this message: An error occurred loading a configuration file: Failed to start monitoring changes to 'm\Visual Studio Projects\ProjectAlarm'. Where m is the place on the server whe...more >>

Hello, I need to allow user outside the domain to access reporting services reports. Can you please let me know how I need to configure reporting Services for this? and what user accounts should be set up? thank you -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/F...more >>

I have 12 reports in my project. The 12 reports need a same function. Now I copy the fucntion to the user code in every reports. Can I share a function accross reports? ...more >>