Hi, I would like to create a way for our management to access our financial reports through a web browser, what is the best way or presenting data to our management from SQL reporting or analysis services.... I have been going into so many different directions and I would appreciate any hel...more >>

Hello everybody, I have a master data set returning rows about projects. For each project, there are two kinds of detail data: The time periods used for work for the project, and the travels to the customer. Both have, of course, different numbers of rows for each project, and totally diffe...more >>

Hello, How can I make my sub-reports invisible in the report manager, I do not want users click them and try to run. Thanks, ...more >>

When i export a report to PDF using the preview, my images are seriously pixelated. I've updated to the SP2 and the issues still occur. Any advice would be greatly appreciated. ...more >>

Hello, This is my code in C# DateTime sYear = new DateTime(Now(),1,1); DateTime q1Start = sYear; DateTime q2Start = sYear.AddMonths(3); DateTime q3Start = sYear.AddMonths(6); DateTime q4Start = sYear.AddMonths(9); DateTime q1End = q2Start.AddDays(-1); DateTime q2End = q3Start.AddDays(-1)...more >>

Hi, Thanks to an earlier post, I can distribute report to our client base =), but I have hit a new snag. The connection string used to create the report is not the string needed on the client sites. Is there a way to automagically update the connection string in a report with the correct i...more >>

I am just getting started with Reporting Services 2000 and I need some help PLEASE! My source is MSAS 2000 cube. This whole flattened rowset is confusing me. Insight will be HUGELY appreciated. I have a MSAS hierarchy that looks like this: WORLD -North America ---USA ---Canada ---Mexico...more >>

I wanted to try a test drive of the product on my new web server, but I get a warning that it won't install. Warning is worthless because it says that something isn't present, but fails to mention what that is. No # to cross reference. So what do you need to have on a fresh install of W20...more >>

Hi. I love the time-saving features of Reporting Services. I desing my report in VS2005. Then deploy them to my QA server and, when that passes testing, put it into my PROD environment. That all works very nicely. I have defined 2 data sources, one for QA and one for PROD. What gets to me ...more >>

Hi while deploying the reports to the server I get the following error. Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportingservices/ListSecureMethods. Could anyone help me to overcome this? Please mention if any c...more >>

I have a single database which will be shared by many customers. So the idea was to design a "Report Model" and use Security Filters to make sure that customers only see data belonging to them. Each tabel has a field called ClientID. How can one design a single report model which asures that...more >>

All resources of reporting service programming(web site)...more >>

Dear all, Can i use local mode of reporting service in asp.net web application?...more >>

Hi All Experts, I caught in a big problem, previosly our application was using Crystal Report, but on my suggestion Project Manager changed the reporting tool for next client and we are decided to use RS and removed CR from our application. There are 50 Reports, we designed it well and we don...more >>

When I try to generate a matrix report using mdx against an AS2000 cube I am unable to retrieve the "all" level from my "Providers" dimension. Does anyone know how I can get the all level included in my report? Basically the 'Providers' dimension has two member plus the all level. Member 1 - B...more >>

Is there a way to read the rdl file that is already deployed on the Report Server to modify it? I have some reports on RS but don't have the original rdl file. Thanks Ayad ...more >>

Hi, Here's my setup: 1. ReportServer website is setup to use Integrated Authentication 2. I added a new user group (in computer management) called ReportAdmins 3. I used Management Studio to connect to my Reposting Services, at the top level, I added the user group I just created, and gave i...more >>

Is there some way to force a list (or table) to print in the same place on repeat pages as it does on the first page? Say for instance on the first page the list starts 2 inches from the top, can I make it so on continuation pages the list always starts 2 inches from the top? Instead of startin...more >>

Hello, I have two questions: 1. When I debug my application it seems it deploys reports to report manager, how can I prevent that from happening, I would like to deploy when I chose deploy command only? 2. I have a report which has many sub-report, when I deploy sub-reports are deployed...more >>

Installed SQL 2005 and Report Services on Win XP SP2 with IIS 5.1 installed for testing. Already had SQL 2000 installed so I gave the new install an instance name of SQL2005. My problem is that I can't access the Report Server web pages. I have checked and IIS 5.1 is running, report services i...more >>

Hello: We are running SQL Server 2000 RS. We are just starting to deploy reports and we are running into a strange problem. We have given users access to their reports via various Windows security groups. When an Sysadmin runs a report, it's runs fine and displays everything in a timel...more >>

Hi, I am trying to figure out how to package and deploy reports to multiple report servers. We have 200+ clients, and are trying to switch over to report server, but I can't find any documentation about deploying reports outside of an organization. To clarify a little, new releases come ou...more >>

I am using SQL Server 2005 RTM. In which i am getting 'Select a value' in all the drop down list. I don't want 'Select a value' in the drop down list Please advise how to remove it from the drop down list...more >>

When attempting to run a report, the following error appeared. What does the following error message mean? Logon failed. Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) ...more >>

Is there a way to pass a record set into a function of custom code? If so? What datatype should I use? I have been told its impossible to loop thru the dataset... Can you get the INDEX of the First row and the INDEX of the last row as a parameter into a custom function? regards, Stas K....more >>

I have a table grouped by id. The detail for a particular group can span serveral pages. I have 3 header lines for each group . I want to print all 3 header rows on the first page of the group and only one of the header rows on the next pages of the group. Does any one know how to do t...more >>

Hi, I have a report generated from a dataset which has the state and county codes. I have some other general purpose datasets which have the correspoding county/state codes and descriptions. How do I link these to the report so that I can see the descriptions instead of the code? I tried ...more >>

Lets say Im running many small/big reports. I want my report to be generated fast. What's faster? SQL Store Procedures with Where statements or RS filtering? Reason for my questions: SQL cache only caches specific requests - meaning where startdate is x and end date is y. So if I run the s...more >>

I have 2 reports, my requirement is to render these 2 reports into a single PDF file (kindof like appending the reports). Is this possible with reporting services?? How? TIA ...more >>

I am trying the following code in my ASP.net page to pass network credentials to the ReportServer. This code renders the report without any problem but for some reason after rendering the report it also prompt windows login prompt Is this a known bug with RS ??? --// Code //-- Private S...more >>

I have a report that requires 3 matrices side by side, each with different datasets. The rows are the same in each. I have set all the properties of the cells to be the same, but the 3 don't line up, I lose some space each row so that the bottom cells don't line up across the page. Any idea...more >>

We have a report that calls several other subreports. These subreports in and of themselves are reports and in the footer of these reports are page number. When we run the reports independently they have page numbers. Unfortunately, from the main report the page numbers of each sub report do n...more >>

Search phrases: encyrption key symmetric keys Scale-out deployment... not supported Sql Server 2005 Standard Edition Reporting Services 2005 The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Reporting Services Configuration Manager =============...more >>

i am creating a new dataset using sql rpt services in vs 2005. i have a datasource connecting to a sql 2005 db on same box. datasource connection tests just fine. in the new dataset dialog - i have cmd type options for "text" and "storedprocedure", but not "tabledirect". i am going through a t...more >>

Hi Group, This is a repost - original message posted on Dec.20th. We are using Win 2000, SQL RS 2000sp2 and SQLServer 2000(sp3) and we are rendering to PDF. In most of our reports, in the body we have a title and a description, followed by a table with a grouping structure like this: T...more >>

How can I jump to URL with new window? Is anyway can do this? I'm try to use &rc:targetlink=new but it dosen't work. how can I do this? Thanks for any advice! Angi ...more >>

How to Pass dataset from ado.net to reporting services any articles or any links?...more >>

I have a report that is using 3 rectangles to separate the blocks of information and I want each rectangle grouping to show up on a separate page in the .pdf. I currently have the properties of the 2nd and 3rd rectangles set so that a page break occurs before the start of the rectangle. This ...more >>

I have a simple report, listing patient names, and then columns depending on certain condition. If they have the condition the column is True, and if they don't the column is false. The problem I have is trying to count how many have each condition. I inserted the following expression in ...more >>

I am trying to make a report that will select the sales people who have made 10 sales or more during the current month and show what those sales are with the price..., and then show what those same sales persons totals were for the previous month. my problem is to get the totals from the previo...more >>

Dear all, Does reporting service 2005 to be installed on sql server 2000, if so, what is the license requirement?...more >>

With asp.net 2005 - after I create a report (rdlc) file, I try to create a Data Source (Report menu, then click "Data Sources", I get error: The root element of a WC3 XML Schema should be <schema> and its namespace should be 'http://www.w3.org/2001/XMLSchema'. Can I fix this? Thanks -- Jay...more >>

I've a server with Visual Studio.net 2003 and reportig services. I want to migrate to Visual Studio.net 2005 Are there some contraindications? ...more >>

Dear all, query in sql server 2005 is case sensitive? Select firstname from Person.Contact - does not run however Select FirstName from Person.Contact - run why? ...more >>

Hi, I have couple of reports which retrieves records with leading spaces. the leading spaces vary and forms the proper indentation for the fields to produce a visually pleasing presentation. unfortuanetly, after installing the SP1(even tried the SP2) the leading spaces are implicitly trun...more >>

Most of the stuff I have read on this is from 2004. I am wondering if there is a easier fix to this problem. ...more >>

I have a number field that looks like this: 8 characters long yyyymmdd ie: 20051201 I can not change its type to a date field. In Access and Crystal I was able to manipulate the number to make it look like a date ie: 12/01/2005 Can anyone help me figure out how to format the field like thi...more >>

Hi, Can we write functions in RDL ? If yes how, where etc... Thanks ...more >>

I'm using Reporting Servicves for SQL Server 2000 and I've embedded a ReportViewer control in an ASP.NET page. The reports I link to all require a sensitive parameter value and I have been passing that through using the query string. Unfortunately, the entire URL of the report--including the ...more >>

Hi In our IT dept all IT users are members of the domain admin group (not my idea). Is there a way to prevent them from seeing reports/folders? We only want admins to see reports if they are given explicit permissions. thanks...more >>