In a report how to display line numbers for each row?...more >>

I have as aspx page and i want user to be able to export the data selected from the page to PDF files. Can i use reporting services? ...more >>

I have a report that I have created using a stored procedure and have found that I will get result set A at 7:01am and run it again at 7:03am get something slightly different. This report runs against SQL Server db. What do I need to look at? Thanks ...more >>

1. Is it possible to directly open the report in PDF viewer bypassing the Open/save/Cancel dialog box? If so , what paramenters do I need to add to the URL so that the report open in PDF viewer directly without requiring to respond to the open/save/cancel dialog box. 2. Is it possible to prin...more >>

I have a param'd stored procedure that returns a recordset. If I run the SP from Query Analyser the values in the recordset are as I expect them to be - Correct. If I run the SP from the Data Tab in RS , then randomly I will get a field value that has been .. 1: Round...more >>

When I deploy reports to a server, what is the minimum security rights I need to have on that server to be able to publish? Is it simply a case of having write access on the file system folder, or is there something else I need to be? I get the error message "The permissions granted to us...more >>

I have a chart where the date shows as 3/12/05 12:00:00am I changed the format code to be mm/dd/yy however when I run the report is shows up as 00/12/05 How do I get the chart to show the month? Thanks for the help. ...more >>

....without re-installing the server? -- Adrian M. MCP ...more >>

Default export procedure sets incorrect MIME type exporting to CSV. Due this Excel can't open csv file on-the-fly (after pressing "Open" button). How can I change mime to "application/vnd.ms-excel"?...more >>

Hi All, I have an issue with drill down reports. I am having the following data in my table ColA ColB ColC A B Y A1 B1 N A2 ...more >>

A message delivered back to me from an error states that I may use rs.exe to import data/reports from one dB (the eval version) into my new version (standard). Documentation on this subject is slim. Any help out there on actually executing this? -- ~Jack~...more >>

"Setup could not initialize the report server. You must manually initialize the report server before using it for the first time. For more information, see the Reporting Services setup documentation." All apps in app pool are started as is the defualt website + service. Thanks for any help. ...more >>

I have several DPEs that populates parameter dropdown lists. How do I handle an "All" in the list. I know that I can create a function eliminate the "where" clause, but I want to specify in my "where" clause the list of items from my dropdown list. Report services does not seem to have the ...more >>

A Payment can contain multiple contributors My dataset looks like this: PaymentID, PaymentAmount, PaymentDate,Payer,PayerContribution 1, 100, 1/1/2001, Fred, 100 2, 200, 2/2/2001, Paul , 100 2, 200, 2/2/2001, Peter , 100 Now I am grouping on PaymentID to get a report that I want to look like...more >>

When I execute the query in the datasource tab I get a different result than when I run the report in preview. I dont have any report parameters that might be causing this. Has anyone else had this happen? ...more >>

I have a matrix in which there are cells with no data (i.e. there is no corresponding record for the column/row match). This is fine, and is what I expect to happen for this dataset. The problem is that I also have cells in the matrix that contain data based on calculations run against thes...more >>

Greetings, I am using SQL RS (Reporting services) to generate MOM2005 reports in PDF format. Currently SQL RS sends the generated PDF file via email to my GroupWise (Please don't laugh) mailbox, relaying off another Linux based server. The issue is that when I receive the attachment in my ...more >>

Hi, I have been developing reports using Reporting Services for a few months now, but just then someone came to me and asked if there was a way to convert Crystal Reports to RS reports, and I had to tell him I was not sure and that I would check it out. So is there a way to do this, or d...more >>

Has anyone gotten a multi column report to work? I have a subreport 6.5in wide by 1.5in tall with three columns. When it renders (only in pdf, multi-column doesn't work in HTML). I only get one column tall enough to display all of my data. Shouldn't the subreport respect the report height I ...more >>

I had installed the eval RS Edition on the following systems o Win2000 Pro o SQL Server 2000 Standard I have recieved the RS Standard on CD and while trying to install, I recieve a message "Can not upgrade, web farms are not supported with this version". Now, I never had a web farm and hav...more >>

I have a report based on a stored proc and am passing a number of parameters. The values supplied to the parameters are based on queries. In each query I have a UNION statement to add the wild card '%' as an option for each paremeter like: UNION select '%' as FUND, '% - All Funds' as [FU...more >>

I would like to save the RSExecutionLog package locally on the SQL Server so I can schedule it and have it run un-attended. Has anyone done this? I am poking around in the package and it appears to want to be run by hand. Any suggestions? I certainly can't be the only one who wants to do t...more >>

Hi all - just a quick question about tooltips - I'm using the tooltip property on a textbox in a matrix to show the definition attached to the value within the cell. These definitions are often quite long, but the tooltip dissappears approx 4 seconds after appearing. Is there any way to extend...more >>

Hi, Is it possible to create an organisational chart is Reporting Services? I have an employees table with each employee marked with a manager in one of those fairly standard recursive relationships. However I cant think off hand an easy way to display an org chart in RS? Any ideas? Tha...more >>

I have followed the instructions exactly on the Sample Printer Delivery Extension and it doesn't show up in my subscription page at all. Any ideas? Thanks, Trint ...more >>

I have a report with many parameters and so I want to hide the parameters after the report has been generated. Where and how can this be done?...more >>

I need to export a report in Reporting Services to a tab delimited text file. Does anyone know or have an add-in to make this possible? Thanks, James...more >>

Any updates on when it will be released? I'd like to demo the client side print features for a project, but the beta was taken down weeks ago and the release hasn't been announced. ...more >>

Does anyone have a security extension that work's with a server web app separate from reporting services server ?. I have this situation , i have checked cookies it's send correctly , the server it's in the same domain Any idea ? Franco ps in the same server the security extensio...more >>

Hi, Can I make deployement package for SQL server reporting service's project with MS dotnet development environment? I am trying to make deployment package as we do for other but its not let me do. I know I can provide Server URL in the project and that will deploye directly over that ser...more >>