Hi, I have two groupings in my table. one based of employee_id and the other = based on employee region. I am showing some values in the detail row of = that table. Now, I need to show the total of one field in employee_id group1 footer = and employee_region group2 footer as well. the value...more >>

From the MSDN webcasts I've seen where the feature was demonstrated, I should have SSIS listed as a possible DataSource when I add a new DataSet to a report. I don't have this option. All I have is: Microsoft SQL Server OLE DB Microsoft Sql Server Analysis Services Oracle ODBC XML ...more >>

I have architecture related question - I have 2 databases on 2 domains and security doesn't permit me to co-mingle the data. I'll be generating 2 different reports for same request. Question is - Do I need SQL server with reporting services installed on each domain? Current proposed so...more >>

We have current reports containing 3 bar graphs, each reporting 3-6 values. We are wanting to launch new version of app where we converted all reports from Crystal to RS and they are looking great. When trying to export to PDF more than 700 pages of these reports (1 user), we are encountering...more >>

Hey all, I need to calculate % bases on 2 columns (Col1 and Col2), and my result that I want is in Col3(%). Please see the layout below. Is that possible? Col1 Col2 Col3(%) ------------------------------------- A 5 50% B 2 ...more >>

Can any third party charting tools be embedded within SQL Reports? If so, is the Enterprise version of SQL Reporting required? We are interested in developing a ASP.NET web site which has SQL Reports in it. Those reports need charts embedded in them and the charts go beyond the default c...more >>

I have created an user-defined function (UDF). Is there a way to call the UDF in the dataset in the Data tab? If so, is there an example. Thanks...more >>

I'm rendering reports in PDF format in aspx pages by calling the ssrs webservice. Is there a way to adjust the side margins in the PDF? Currently the margins are a default of 1 inch on each side and I want to reduce it to 1/2 inch on each side. Thanks. -- moondaddy@nospam.nospam ...more >>

Hi I've got a question regarding the TIFFs that are generated by Reporting Services. The problem I am having right now, is that documents that are exported into TIFFs are in bad quality - i.e. the text does not seem to be 'ClearTyped'. I installed the powertoy: ClearTypeTuner for the serv...more >>

Hi all - If you have a VS project with several reports in it - is there a way to 'cancel' if you accidentally build or deploy the whole project? I know esc. doesn't work to well - but I currently have two projects open (one for the ..net UI) and the other one solution with multiple projec...more >>

Greetings, I am trying to store/retrieve given RS report's ParameterValue object to a SQL table (ntext?)…I’ve tried MemoryStream w/ BinaryFormatter and am getting “Not marked as serializable” errors. Any suggestions on a viable way to do this would be appreciated. Thank you for yo...more >>

My team is moving its development to London. A Reporting Services server has been configured in London, but aside from simply importing existing RDLs, what is the best way to migrate existing subscriptions, snapshots, etc. to the new server from the old? Is this simply a copy of certain tables i...more >>

Hello, I have a long / complicated IIF expression for opening subreports from report 1 (navigation feature). If field = 1, open subreport 1, if field = 2, open subreport 2, etc etc...and this goes on. What's an easier way to do this besides the IIF statement in Reporting Services? I have abou...more >>

Hi all, I have a matrix which has a runningvalue in it's detail cell, so it looks like this: item, date1, date2, date3...datex A, 1, 1, 1...1 B, 1, 2, 3....x C, 1, 2, -1....y D, 1, -2, -3....z This works fine and all is well. However, I now wish to filter out all rows that have no neg...more >>

We have an inverted delta symbol (an upside down triangle) It represents itself as this --> Ñ when it's in a normal font such as arial, or time new roman but should be represented as an upside triangle in symbol font. In symbol in reporting services all we are getting is a square box. Is ...more >>

I'd like to add a constant string variable to my report project. Something like stCOMPANY_NAME. I'd like the reports to be portable to some of our other plants so it would be nice so be able to change the company name on the header of all the reports by just changing one constant somewhere...more >>