this is the desired result in need to populate as a report. where xx is no of people. i have a table which has fields like : ---------- table1 ---------- id state year(as Quarter) gender so i need to determine the count from id and populate as a report. the year is like 20081,20082..20084(in quarter). i have created a dataset usin...
In the Expression builder window in SQL Server Reporting Services 2008 R2 under Common Functions -> Text -> Item, there is an expression called Filter. This appears to correspond with the Strings.Filter method in the .NET framework. The description of Filter is as follows: Returns a zero-based array containing a subset of a String arr...
Hi All, I'm creating an SSRS client side report (RDLC) and am using custom objects to populate the report. The report is an invoice report which has line items. The report datasource is a List<Invoice>. Each Invoice object has a List<LineItem> property that should map to the invoice line items on the report. This seems like it shoul...
When attempting to deploy a SSRS 2008 R2 Report to my localhost/ReportServer, or trying to login to localhost/reportserver (via web browser), I am not able to get any further than a security error message. When trying to access the report server via a web browser, I'm prompted to enter my login credentials. Even though I am the admin o...
I have report which calls parameterised SP. when i preview/debug/run the report i see three two box and one date control where i enter the values and view the report ,I can see the report correctlly. My client asked me to put dropdown instead of text box. Now I created two data set ,and changed parameter property to get values from quer...
Does anyone know of a way to add or remove items from the "Actions" menu within a report on SharePoint 2010 Integrated with SSRS 2008 R2? I would like to remove "Open with Report Builder" and add "Subscribe" to the Actions menu. I'm working with my SharePoint Server Admin who is at a loss also. I have found how to remove Report Builder ...
this is the desired result i needed. i had populated State(RowGroup), Male(ColGroup), Year(ColGroup) and the data inside the matrix. to calculate the data count total(100), i used the feature AddTotal by right clicking it. But in this report i have used expression to calculated individual Percentage. Expr1: to calculate the percentag...
Is there a way to configure Reporting Services 2008 to authenticate with a remote SMTP server? Our Reporting Services Instance is located outside of our network, but we want to forward mail generated by report subscriptions through our local mail server which requires authentication for any smtp requests. Thanks. ...
Hi, I've just set up SSRS for my office. Some users need to be able to run Report Builder. I've created an AD global group and used Report Manager to assign Report Builder privileges to that group. I've verified that the Report Builder configuration on SSRS is correct. Even after these users are assigned to the Report Builder role, ...
I'm very new to MDX and don't know what this error "Parser: The end of the input was reached" means. I ran my code in mdx and it is pulling correct data. However, when I take my code and put it into my SSRS report, I get the above error. What am I be doing wrong? Here's my MDX: SELECT NON EMPTY { [Measures].[Cash Expend] } ON COL...
I have a SSRS R2 report built and it works fine on the preview tab but when I try to deploy the report to the report server I get the following error: Error 1 The Value expression for the text box ‘Textbox23’ refers to the field ‘Bats’. Report item expressions can only refer to fields within the current dataset scope or, if i...
Hi,I have a date parameter (@rptMonth) that is selected by the user from a datepicker calendar. The date must be the first day of the month. No matter what the user selects I'd like to turn that into mm/01/yyyy. For example- I need the first day of the month. So if the user selects 06/22/2010, I need to turn that into 06/01/2010. So in m...
The title says most of what I'd like to accomplish. I'd like to render a report in SSRS 2008 using the built-in webservice methods. The report should render and the service should do some kind of call back or notification so I know the report is finished. Currently I'm rendering the reports with synchronous calls. Is there some built-i...
Is it possible to deploy a custom assembly to a location other than the Reporting Service's bin directory? I know that deploying to the GAC would likely work, but I'm more curious about using an arbitrary directory on the server dedicated to deploying custom assemblies. I'm not opposed to altering any rs config files, if a possible so...
Once again the SSRS security wall has hit me. I did a fresh SSRS 2008R2 install. I created a separate account (ssrs) on my box to access SSRS-related services. Upon navigating to localhost/reportserver, I was confronted with a windows authentication popup. I entered the ssrs username and pw and after some time was presented with the...
Does anyone have a clue what this SSRS error means? the only thingi found on google say to upgrade to sp1, but i'm already on sp1. I have a report that generates this error when i run the report. i tried redeploying the report to no avail. However, all the other reports that i tested on the server work fine. ...
Hello, "Yet another string function" question for TSQL. The ExecutionLogStorage table in the ReportServer$InstanceName database for SSRS 2008 puts all parameters called to the report in a single column - FullName=LastName, FirstName&CalledBy=Lastname, FirstName&DateSelected=MM/DD/YY&CheeseorFries=Fries Some are null values, so the u...
Hi, this kind of a two part question. Is there any way to handle an error that is displayed inside a report, such as an error returned from a stored procedure? I have a page with the ReportViewer control on it, but I don't really have any control over the rdl's or the sprocs, so it's possible that something will go wrong. Currently I'...
Question: I have written a console program that uses the SQL server 2005 web service to upload reports to SQL Server 2005 reporting service (so that I don't have to upload 100 reports by hand everytime). It works fine locally, and remotely. But now, the problem is one server uses SSL so rs.Url = "https://hostname/ReportServer/reportserv...
I have a dataset based on a stored procedure that is returning ID, Amount, Category, SubCategory, PayType. I am using this same dataset for about 5 other gauges on the same page by using filters on the gauge to categorize and sum up amounts for me based on Category and SubCategory. I have one gauge that I want to use this same dataset ...