Hello, I was hoping someone could help me with this. I have set up a Reporting Services installation to use forms authentication as described on the MSDN page http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp. By itself it is working fine. Now I would ...more >>

Does RS will support XML/A (XML for Analysis) in a near SP? or we must wait for Yukon? ...more >>

1. I have my first chart displaying nice, crisp bold fonts for Titles, Legends and axis labels in Designer Preview Mode. 2. However, when deployed and run in Report Manager on same machine, the fonts are thin, non-bold, and uneven, and have a washed out look. What would account for this? A...more >>

If I select "New Subscription" and I select a delivery method and time and select OK, the screen flashes, but no subscriptions are listed. I have the user as a Browser and Publisher, but I don't get an error. Is there something else I have to check or setup? Bart ...more >>

I can sorta on a table fine if I select column from the dataset in my sorting expression, in table properties. But, when I try to put '=Parameters!orderby.Value' in the expression for sorting, it doesn't work. Is there anyway to do this? Or do I just need to make different reports for eac...more >>

Hi all, Short Question: How do you filter a matrix report to exclude NULL value groups. Long Explanation: eg: 2 tables: ReportingPeriod Table: Period Date ------ ----- 1 31Dec 1 1Jan 1 2Jan ProductSales Product SellAmount SaleDate ------- ---------- ---...more >>

Just a repost of my former question. Is there something I am doing wrong or is there an issue with expressions in TextAlign? Thanks scott Yes, I have used many variations of Fields!<FieldName>.Value and actually tested using another textbox (column) in the same row/table and referencing ...more >>

Hi Is there a way to insert comments into the RDL, in such a way as that they are persistent (i.e. they don't get lost when making changes to the report and saving)? Thanks, Mark ...more >>

Hi I need to concatenate varchar field from multiple records and show the result in group footer. Eg. RecNo RoomNo (Varchar Field) 1. 101 2. 102 3. 103 In Group Footer, I need to show like this 101 - 102 - 103 I found the r...more >>

I have a parameter called @To that utilizes the date field in my datasource, What I need it to do is to give the data that ends at @To and that starts at the first day of the month specified in the parameter @To. So I have constructed this query WHERE (CONVERT(char(11), Date, 3) BETWEEN ...more >>

In a script - how would one pass assign values to to this? Dim param as ParameterValue() = ?? Thank you for any assistance....more >>

Hello, I have an rss script that I have been using to generate reports to the hard-drive. I would now like to pass in another variable that the reports will user. The rss script was based upon the samples provided. At the top of the document I have something like this: Dim accountnumber as ...more >>

Hello My first opinion about Report Services is very good, it is very simple, flexible, but for me is only problem licesing(price). You must have licensed SQL Server 2000. I develope low budget application with MSDE, so it will be in the future any Report Services for free like MSDE with some l...more >>

Hi! I have the problem that I can not render a PDF file containing a diagram via code. My function is essentially: Private Sub SaveAs() ... Some initalization here... Try results = rs.Render(selItem.Path, format, historyID, deviceInfo, param, credentials, showHide, encoding, mimetyp...more >>

When I typied : ="SELECT FirstName, LastName, Title FROM Employee" & IIf(Parameters!Department.Value = 0,""," WHERE (DepartmentID = " & Parameters!Department.Value & ")") & " ORDER BY LastName" I can not make this examle work either. It is a text area, not allow me to type ="" sign only...more >>

Hello Is it possible to prevent a report from rendering when he opens the report; Or is it possible to prevent users from rendering before the user filled in some parameters. Greetz Thomas Annerel ...more >>

The following whitepaper is now available on MSDN: "Integrating Analysis Services with Reporting Services" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp. Summary: Create a compelling solution for your customer that defines and manages grea...more >>

I can insert image in header from a database by using : - in body a textbox (name = textbox33) with value: =convert.toBase64String(first(fields!Image.value,"IMAGE")) - in header an image with value: =convert.fromBase64String(ReportItems!textbox33.value) Image appears on first page o...more >>

When adding a text box in my group section, the textbox width is limited to the width of the first column in the detail of the report, or any detail column. It cannot span multiple columns, even though it is the only textbox on the entire 8 inch line, it is limited to my .5 inch column 1 width. ...more >>

What is the syntax to display the report property fields within a textbox on the report header ?...more >>

Hi, I've a query on a "big" table. I've optimized this query, and SQL Server as created an indexed view. So my query takes 2 seconds instead-of 20 seconds. But, when I execute this query through a report, so in reporting services, then the query don't use the indexed view!!!! Any idea of...more >>

How would I acheive Year to Date figures in Reporting Services? Also as the financial year in Australia goes from July 1 to June 30 how would I set this? Thanks for your help! ...more >>

Hello Would anyone be able to tell me exactly how the licensing works in Reporting Services? We have a licenced live SQL Server - which is also our OLAP server. It is running Standard Edition SQL Server. So presumably we will be licensed for Standard Edition Reporting Server? Does Repo...more >>

Is there a simple way to make the backcolor of a table object alternate? If there was a row number global I could just use an expression....more >>

1. If there are no records returned in a report, how can I display a "No Records" message? 2. Is there anyway to prevent a subscription from emailing a pdf if there are no records in the report? Thanks, Jason ...more >>

Hi, I am trying to install Reporting Services on our web server and one of the requirements says I have to install the report server's virtual directory to the default website. The problem is, the default website's ip is unassigned most of the time, and is frequently either being confi...more >>

how do i filter any expression in the data region e.g. i want all users for just New York? how to apply that filter condition in the expression in data region?...more >>

Hi, How can I assign the starting point to the data shown with pie chart? It seems the first point always shown on 0 degree, is it possible to pre assign it? best regards, Fish....more >>