Hi group, First time i am using reportservice.render method to render the report in my aspx page. Here is the code snippet result = rs.Render(report,"HTML4.0",null,null,paramValue,credentials,null,out encoding,out mimetype,out paramvalues,out warning,out streamidsh.SessionId = rs.SessionHe...more >>

sorry to bug you all but does anyone know when this will be released. i can see that the beta is available now. thanks for your time ...more >>

I need to provide both Active Directory (for intranet users) and Forms Authentication (for extranet users). According to the MSDN article on Forms Authentication "It is not possible to run a report server under a mixed-mode security system (for example, both Windows and Forms Authentication)....more >>

I installed the SP2 and sure enough, the print icon came up. When I click on the icon, the print dialog is displayed where the Preview button when clicked gives me a 500% zoomed view of the report. Why is that? Even when I print it, it shows a very enlarged version of the report and consequen...more >>

I have 10 Databases with same query to extract same info from all databases. One thing I can do is to create 10 different datasets to get my results or join 10 queries in one big query. But what I really would like to do is to create one dataset and pass a database-name parameter so users ...more >>

I'm having problems getting the right properties out. I get the launch date in a column, but that overwrites with the cube like, [Zone Id].[A].[B].[C] it inserts the launch date, where the C column should be. In the 2nd query below, I can get both the date and the value of C, but it gives me do...more >>

Is there a bug in SQL Server Reporting Services which produces an error like The value expression for the query parameter ‘@homebase’ refers to a non-existing report parameter ‘homebase_1’ I made some changes in the dataset (1 of them) and it starts giving me this error for no reason...more >>

My report subscription got the following error. Before the subscription was run, I changed the Reporting Service's Windows Service logon account from local system account to a local user with adm rights. I'm using developer editions for sql server and reporting service, running everyt...more >>

I am attempting to access an Access database file located on one of our servers on the network through Reporting Services Report Manager and am receiving the error below. I have already setup our Report Server Service account to a domain account that has full Access to the file. I am able to run...more >>

Hi all, I'm using a Reporting Services webpart for Sharepoint. I made the reports using Parameters with the SELECT UNION statement to bring 'ALL' the rows, something like this: SELECT priority AS prior, prioridad AS value FROM dbo.priority WHERE (priority <> ' ') UNION ...more >>

I have two matrizes on the same report which are populated from different datsets ,they are both grouped by month and having same row groups (showing some numbers in each month). My probelm is that the second one is a bit wider than the first one .How can I get them both in the same width. Th...more >>

I have a report on my development server which opens fine in report manager from MyComputer. I am not asked for credentials until I try to export it to pdf. At that point, no matter what uid and pwd I enter the pdf will not come up. When exporting the same report to Excel or HTML I am not a...more >>

I am trying to get a report to display. I created a new report to add to the Report Manager. Some older reports already exist. The report I created is using the same data source name as the older reports. When I uploaded the report, I could not run it. I got the error message: The report...more >>

I have the following report: Case Nbr code (Report Group1) 1234 (Report Group2) 0 INVS1 0 INVS3 3456 ...more >>

I have a report that I exported to Excel which contains dates in one column. About 10% of the dates show up as ######## accross the width of the cell. The column is plenty wide enough and if you double-click one of these cells the date shows up fine. It also does it on a column that has per...more >>

Dear all, Sorry if this is a little trivial to the more (or even the less) experienced amongst you, but I can't find any mention of it: If I have a textbox, say txtTotal, with value "=Fields!Item1.Value + Fields!Item2.Value", how do I acces that value from a different text box (for insta...more >>

I have a table in SQL SERVER with two columns that look kinda like this: type: amount: trav 2.00 spend 1.50 matrix 3.00 spend 5.25 spend 2.25 trav 3.15 When these columns get to the report, they need to be split as columns of those three types: trav spe...more >>

I have two or more filters for a metrix, but I found the 'And/Or' column is disable in filter tab of Matrix properties Dialog. In addition, the filters element in RDL is defined here: <Filters> <Filter Name"...">...</Filter> </Filters> If there are two filters, the default relati...more >>

create a dataset with this select select null as key_value union select 1 as key_value union select 2 as key_value now stick a table into the report with this dataset now try to filter out key_values that are null. I just can't get this to work. What am I doing wrong. I have tried...more >>

I want to make a report with parameter query, for example: mdx: select {[Time].[1998]} on rows,{[Measures].[Unit Sales]} on columns from "Sales" where @parameter1 The datasoure provider is msolap 8.0; The vs.net 2003 complained the following info: "The ICommandWithParameters interface ...more >>

hi, I have read a lot of other posts here about using custom Forms Authentication, but am still having trouble comprending some points. I understand the custom authentication piece (LogonUser) and understand how CheckAccess() works. Its setting up users that confuses me. Do users have to...more >>

Has anyone successfully installed the Exchange Pack for Reporting Services? I've attempted a couple of times and continue to get "Object Reference not set to an instance of object", which causes the install to rollback. Does anyone know how to correct this problem? This question was origin...more >>

I've installed report services and configured the email service by entering a <smtpserver>192.168.1.100</smtpserver> value and a <from>from@test.com</from> value. Then a subscription was made, however no email was sent. I'm using Windows 2003 a What kinds of troubleshooting can be done to...more >>

Can I create a user programmatically (without using the ReportManager UI)? If so, how?...more >>

Hello, I am struggeling with my .PDF file exports. One of our reports outputs 250 pages in the web interface. When I ask to output a PDF version of it, the file contains only the first page but I really don't know why. Could it be a problem with the .RDL file?!? Thanks! Marc Lacou...more >>

Hi NG, in my report (html-view) i got the following value (i.e) -43.988.224,29 ? field-type is currency After export in pdf i got something like that: 0761<; ; 1557/5<#0 ander othe unknown characters. Any suggests? frank www.xax.de ...more >>

I have written a report on the sample database that breaks by customer and sales order and prints details for each orderline within a product group. When I select a range of orders and render the report to PDF then some of the detail rows are missing but when I select only one order then al...more >>

Hi Group, I am trying to share the session of my web-application with ReportServer so that i can use session variables set in my web-application as parameter values in report. Is there any way around. Please let me know.. Thanks in advance Sandeep ...more >>

Where do I find the install for Reporting Services. Is it a separate program from the SQL Server install?...more >>

Is it possible to change ReportViewer that is shipped with Microsoft Reporting Services into a web part ?? Thanks for your help ...more >>

I've successfully set up RS to use Forms Authentication. However, here's something strange. The first time I access Report Manager (say after a reboot) and enter the admin credentials, RS churns and churns, then I end up back at the login screen. If I enter the same credentials again, I get...more >>

Hello. I have a report that was written in Crystal Reports and need to rewrite it in Reporting Services. The datasource for the old report uses an ADO recordset that is created at runtime (ASP page) and then passed into the report. Can this be done with RS? Thanks in advance, Mike...more >>

Hello, I am looking for some good book suggestions. We are in the testing phase to see if RS will work for us. I am also wondering the following questions: 1. Does it work with webservices? 2. We have a website that has some reports based upon specific projects. Is there a way to make...more >>

HI, I am new to RS and I am running into some problems create reports. What I would like to do is create a report that will count all distinct rows for a "Users" column for every single date. I am able to get the total users from the "Users" column but the problem is getting a running lis...more >>

I have public domain. on that machine i have installed reporting services. i can access the reports locally. while i am trying to view reports remotely. its forwarding the request to http://machinename/reportserver not to the fully qualified name of server. and give page not found error. ...more >>

Hello, I have a report that is attempting to go out and grab images for certain items off of a website. The URL is basically a guess and when it is incorrect (404 File Not Found) RS returns an image of a red X. Is there an expression I can use to hide the visibilty of the red X if one sho...more >>

I am using ="javascript:void(window.open('/Reportserver?%2fwebte%2fExpStmt&rs:Command=Render&stmtnumber="&Fields!Exp_Stmt_Number.Value &"','_blank'))" to open a new report from a link. This works fine from the report manager. However, I am using this inside the reportviewer control in an vb.net...more >>

How to obtain Report RDL file by webservices request of ReportingServices. thanks -- OSVALDO COLITTI ...more >>

Hi, I am having a problem exporting to excel for a particualr report. Based on the parameters chosen then a different type of report shows up. However, when I try to export a particular report it gives me all three reports (one with valid data and two with data in the form of XXXXXXXXs). D...more >>

Hi, I don't know way but after working fine for 4 months when I start Report Manager I receive a strange error: Error ? What can I do? Thanks...more >>

Hello, if I try to move a reporting Server instance from one to another server I ran into one problem. I read the Article KB842425 then I tried to extract the key with "rsactivate -e -fD:\ReportKey.txt -pVerySecret" The tool asked me "are you sure to extract" and after anwering Yes there...more >>

As mentioned in the title, can RS sent subscribed report using external SMTP Server , for example, Gmail, to a subscriber in another e-mail (for example, someone@yahoo.com) over the Internet? Thanks...more >>

Hi, in my report I have two tables, that look like this ------table1 x y z (=y-x) where x is a database field, y is a hard number en z is the result of y-x ------table2 x y z (=y-x) where x is a database field, y is a hard number en z is the result of y-x ...more >>

Hi, We want to install RS on a Windows 2003 / IIS 6 server. Does it hurt our 'classic' (pre .net) ASP aps if we run aspnet_regiis -i on this machine? tanx, Derk Jan ...more >>

I am trying to work out the difference in just weekdays between two date fields in my sql table but am at a loss as to how to do this. Any help would be greatly appreciated....more >>

Hi, In my report I put a textbox with text "To PDF", in properties of this textbox I go to "Advanced/Navigation/Jump to URL: ". Here I want to insert Javascript code like this: "javascript: <my happy code> " With <my happy code> I want to "go" to toolbar an selected "export to PDF" and t...more >>