Reports

Percent Calc in a Tablix
I am somewhat new to SSRS, and trying to do something that seems like it should be easy. I have two rows of data that are displayed in a tablix and I need to calculate the % variance. This is the tablix: tablix.jpg This is what the report currently looks like: report.jpg I want to calculate for each month (... 30 Nov 2009 14:45

SSRS Advance Services and passing parameters via <form>
I'm new to SSRS. I'm using SQL Server Express with Advanced Services, and I have a report working. The report has a Parameter defined as "ReportDate". In the report design, I have a subheading expression that goes like this: ="For " & Parameters!ReportDate.Value I'm trying to invoke the report from an ASP.n... 30 Nov 2009 15:52

Bizarre BOL tutorial instructions
Cross-posted: microsoft.public.sqlserver.reportingsvcs & microsoft.public.sqlserver.server In SQL Server 2008 BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10rs_1devconc/html/7bd2b4d6-3d9f-44fc-b22f-2ada2d7d381c.htm Scroll down to: "To define a Transact-SQL query for report data" It does not seem possible... 28 Nov 2009 17:54

Embedding Font
Hi All, We want to embed Frutiger font using SSRS in PDF. We have installed SSRS 2005 with SP 3 and checked with font vendor for support for embedding. When we use SSRS, font is not embedded in PDF and appears of type ASCII. I cheked following things Article from BLOG http://blogs.msdn.com/robertbruck... 26 Nov 2009 10:52

Can't access Report Server
I've installed SQL Server 2008 (dev) on my XP box and am trying to get Reporting Services working. According to the Reporting Services Configuration Manager, the URL is: http://jay:8080/ReportServer_MSSQL2008 However, I have not been able to get the app to come up as there is either a permission issue, or conn... 28 Nov 2009 13:28

Suppressing
I have a report that has a table with basically one grouping. I have sever rows of the same group and another table inside each of the rows. So basically I have 25 rows od the same group with a different table inside eavh row. So table inside of a table. My problem is that whenever one of the group tables h... 28 Nov 2009 13:28

Marie-Alix
More than anything, it’s a generic interface to your data. Any data. If it can be shown in a tabular format, we can work with it. (six months of usage is free. limited time offer) http://www.nobhillsoft.com/MarieAlix.aspx Thanks ... 17 Nov 2009 10:37

How do add SQL Reporting Services web part to Project Server WSS environment?
My goal is to be able to render a SQL Reporting Services report in a WSS web part. However, when I edit one of my project workspace pages, the SQL Reporting Services web part is not available to pick from. It seems that the SQL Reporting Services Add-In for SharePoint must be run in order to add the SQL Reporting ... 16 Nov 2009 19:11

SQL Reporting Services 2005 Report Parameters
Hello: I have created a SQL 2005 report that contains report parameters for such things as a beginning and ending date range and a string field. Is it possible to configure a report that allows you to do an "either/or" search, where you can put in a date range and not put in a value for that parameter strin... 12 Nov 2009 15:09

Calling SSRS web services via .NET is failing
Hi, Server specs: Windows Server 2003 SP2, R2; SSRS 2005 SP 3 I have a ssrs report that has one parameter, Company, presented as a drop down box. User selects a company, and runs the report, it works great! Now, there are 235 companies in the drop down box..... So instead of the users running it manually ... 11 Nov 2009 18:01