Hi, I created a matrix with drill-downs and it doesn't have a subtotal in it. When I export this to excel, it automatically created subtotals both for my columns and rows. It's giving me what I am not seeing in the report preview. Is there a way to suppress this output in excel? ...
I don't know anything about it and would like to learn how. I don't know what I need to install or configure, or how to use it. Is there any advice to get started? ...
Hi, I'm trying to put RS in maintance mode. I've tried to put an app_offline.htm (usual for IIS maintenance mode), but get en RS error message instead of the message set into app_offline.htm. Any idea ? Regards. Stéphane ...
Hi There, Please find below my current SQL Query. What I'm trying to accomplish is add a column to the resultset that for each row provides the sub-total of the group that it belongs to. Can anyone provide me with an elegant solution to do this? SELECT costs.cost_des, SUM(costs_periods.actual) AS actual, SUM(costs.commitment) AS co...
I have a report in SQL Server Reporting Services 2005. It makes use of a page header and footer and has no subreports. The body portion contains a few smaller elements and then a simple single column table. The table has a single header row and a single detail row. The header is just a label, basically. The detail row is a single te...
I have a report with a table containing hierarchical data of organizations and employees. Under an organization there can be employees and/or other organizations. When I try to do a recursive sum on expenses incurred by an employee the report fails to return a total ONLY when the groups do not have their visibility set to hidden. If I...
I am having an issue with a published SSRS report in Sharepoint loaded as a Web Parts page. The report displays correctly, but the Document Map link is giving an error, "Access is Denied", on the page. I am running IE7. The document map DOES work in native sharepoint mode. I have seen some documentation similar to this error suggesti...
Hi, I want to access the session variables in SSRS 2005 reports just like we access in c#. session["username"] I want to access like this in SSRS report. I want to print the login name of the user who logged into the application. But I dont to pass it as parameter to report. In the application, I am storing the login user name in se...
I have a webforms application built on top of the standard microsoft stack - asp.net, sqlserver2008, ssis, ssrs. In certain cases I would like to run this entire stack in a multi-tenant type mode such that users of one 'slice' would not have any visibility to others. We've solved this on the webapp and ssis side, but not yet with Sql S...
Hi everyone, I’m using SSRS 2005 and had a question about table grouping and page breaks. There’s a table in my report that’s not inserting page breaks and I’m hard pressed to see why. I’ve assigned a DataSet to this table, and am displaying a group header in it-- the grouping is based on a record ID value. I don’t have any footers, ...
Hi, I am wondering if someone can let me know which of the following steps I am doing wrong. Have a blank new report ('Blank') Have an existing report ('Sub1') which has its own data sources and one parameter (int, named 'Likelihood', with a default value). These are in the same project and same folder. Drag the subreport control onto...
i want a report which have a list as a hyperlink....................on the link in the report ..i coded this thing in its URL.................................................................................................................................. ="Javascript:void(window.open('help.aspx?ID="&Fields!ID.Value +"','mywindow','tool...
In my ASP.NET MVC application I sometimes get these errors when I try to open or generate LocalReport from Microsoft Reporting Services assembly: Microsoft.Reporting.WebForms.LocalProcessingException: An error occurred during local report processing. ---> Microsoft.Reporting.DefinitionInvalidException: The definition of the r...
When designing an rdlc report using the VS 2010 report designer, report items such as charts demand a dataset. After designing the report, I add a ReportViewer to a webform, and it demands all of its own datasources. How do I hook up the DataSet I have coupled to the report without duplicating the DAL functionality in the viewer page? ...
Can We create such kind of reports using Crystal Reports XI Cross-Tab? Product Sales Comparison +---------------------------------------------------------------------------------+ | | Jan | Feb | Mar | April | May | TOTAL | | |---------------------------------------------------...
I want to write a report using SQL Server Reporting Services. I want a plan_handle (which is varbinary(64) ) from the dynamic management view sys.dm_exec_query_stats to be a parameter in another report. But SQL Server Reporting Services doesn't support this type (varbinary(64)) very well. Looking for solutions, workarounds etc... ...
I have a report that I am capable of viewing correctly in Internet Explorer (IE) with the help of Reports from SQL Server 2005 Report Server (SSRS). The problem is that the report is compressed to about 100px by 100px in Firefox and probably other browsers such as Safari and Chrome. Also, I am using IIS6. How can a report be rendered pr...
I have taken a sample SSRS report from http://gotreportviewer.com/. The report displays some customer data and the "City" parameter. The report also uses the "City" parameter to filter the data. This report runs just fine unless I enable a custom RoleProvider through web.config. I have set break points in all of the methods of my custom ...
Can I Display % Symbol On Y-axis in SSRS 2008? Please click the below link for sample image of the report? http://i48.tinypic.com/20ib1v8.png ...
So for some reason our SSRS reports didn't run properly this morning and we need to resend them all out but it seems it would be a bit tedious to go in and reschedule all of them. I was wondering if there was a way that we could just put in the report names and have them all resend but maintain their proper schedules. Thanks in advance....