I have a specialized report that produces detailed schedules (simple table) for manufacturing systems based on criteria parameters. There are numerous systems being reported on, but schedules for all must be consolidated into a single report output. The catch is that each system's schedule is ...more >>

Hi all I am using Reporting Services's web services to migrate reports across environments. I have a report path from the source which i need to migrate . ex say reportPath1 = "/abc/xyz/report1" Before calling the create report i have to create the folders. I know there is a ...more >>

I have seen lots of posts about the installation problem and haven't been able to figure the problem out. Any help would be great. I tried installing reporting services and first got the error: "The install has encountered an unexpected error installing this package. This may indicate a p...more >>

I have a freshly installed reporting server/sql server and I have an older visual studio reporting project. Now I wanted to change the deployment url to the new server, but whenever I try to deploy I get the message: "The permissions granted to user 'user' are insufficient for performing this op...more >>

Hi, I use group and page break at end. Also, I have use page number function. But now I want the page number can recount when view to next group, how can I do? Any idea about this? Thanks for any advice! Angi ...more >>

I am new to RS so this might be a stupid question. Since the page header can't have table, I have placed the table in the body as table group header. The table contains column heading for my report. The report produces over a hundred pages of PDF files. As I scroll through the PDF pages I noti...more >>

Hi, I'm trying to build a report which has a table with alternating colors on each row. Here is the expression I'm using in the row's BackgroundColor: =iif(RowNumber(Nothing) Mod 2, "LightGrey", "White") I've done this many times before. However, when I try to preview the report, I get ...more >>

Is there a way to store the history of every subscription to a report? Currently, it only stores the last run time....more >>

I'm experiencing a problem with HTML code being slightly messed up when sending a subscription via email in web archive format. The report displays fine in the Report Manager. However, went emailed some whitespace is seemingly randomly added to the HTML page. Depending on where that white...more >>

i'm new to reporting service and would appreciate some helps with the problem i ran into. background: sql2k on w2k3 with sp3a. sql analysis service, vs .net 2003. and reporting service. I set up the distributed installation, sql server, reporting server, analysis service on the same box, ...more >>

I am trying to install Enterprise RS on a server running Server 2000. The server also has Microsoft's CRM on it as well. Visual Studio is not installed so I get a warning that says it will not Report Designer which is fine. I use the built-in account NT AUTHORITY\SYSTEM for the ReportServer s...more >>

I have a main report that passes a parameter(pTime = Value: "2004" Label: "Fiscal 2004") to a sub-report. When I print out Parameters!pTime.Label on the main report it diplays fine. When I print it out on the subreport it shows a null value. It seems this parameter label property is not passe...more >>

If so, how can I modify this to send to printer please: http://localhost/ReportServer?%2fReport+PackingList1/Report1&rs:Command=Render&InvoiceNumber=931270 Thanks, Trint ...more >>

My stored procedure generates two results: 1) declares a variable executes a view to obtain date driven data which has a begin and end 2) selects the data associated with date driven info When RS executes the stored procedure I only get the first set results (the date information). Can...more >>

I am in the process of evaluating Reporting Services for our company, and I've come to a roadblock of sorts on a couple of issues. If any of you have a minute and could provide some assistance, it would be greatly appreciated. The first issue has to do with selecting multiple values for a re...more >>

Is there a way to schedule report to be printed to network printer?...more >>

Hi all, I have an ASP.net application which manage data from two different companies. Each company has its own database, and the user can select what company (what database) to work with. I'm using Reporting Services, and I'm trying to make my reports work with the database that the us...more >>

What if any are the new features being implemented in Reporting Services 2005? I tried looking around on the SQL server 2005 site for info but there didn't seem to be any....more >>

I want to read the XML from an RDL, I am not sure what the path would be to get to the document? My code would be something like: Dim localURL As String = ThePath.rdl Dim myXmlURLReader As XmlTextReader myXmlURLReader = New XmlTextReader(localURL) can some one plea...more >>

Good morning, I'd like to find out what is capable of changing the security (ie, the list of users and their permissions for the report) of a report. I had a situation where a report had its security mysteriously changed to allow the entire list of people authorized to view its parent fold...more >>

Hi All. Just wondering if anyone knows if entering multiple values into parameters will be included as part of SP2 for reporting services 2000?? as it is going to be in RS 2005 Beta 3. Or if I'm going to have to code some stored procs to get round it? -- Nick Colebourn (MCDBA) DBA Unit...more >>

Hi, I am using an MDX query which generates null values,Instead of null values I need to display 0 's. I have tried the below options but none is working fine for me, please give me any help/suggestion/URL.Its really urgent !! =Iif( Fields!colname.Value = NULL,0,Fields!colname.Value) =iif(I...more >>

I have a stand alone win2k3 report server(i.e. SQL is not on the box). RS SP1 is installed I have a SQLRS report developed in visual studio (also loaded on RS box) that runs MDX against an analysis services cube. I am using the OLE DB provider for OLAP services 8.0. (Note that we had to run p...more >>

Does anyone know why parameter dropdowns that are filled with a Non-queried list do not get populated on the subscription screen. I can create a Dataset and use text as the source and write Selects and Union Alls to duplicate the functionality of the non-Queried list. When this is done, th...more >>

Does anyone know why parameter dropdowns that are filled with a Non-queried list do not get populated on the subscription screen. I can create a Dataset and use text as the source and write Selects and Union Alls to duplicate the functionality of the non-Queried list. When this is done, th...more >>

Could anybody offer any advice on the internal mechanics of report server? Our server setup is as follows. SQL Server 2000 clusters in active/passive. Load balanced web servers x 3. One of which is a publisher with files replicated to the other two. We'd like to set up reporting services...more >>

Hi, can i receive login name user who run my report as parameter which i can use in report? if yes, how. We are use integrated security. Thank you....more >>

Hi, my question about security configuration on Report server. We are have 100 users in Call center department and 2 reports for this users. I wont to give 90 users right to view one report, other 10 will not have access to this report, for second report i wont to give access for all 100 users...more >>