It’s because of lack of privilege for the user you are running the report builder, just give that user or a group a privilege to run report builder. Please visit this article Or for shortcut: Start Internet Explorer using “Run as Administrator” Open http://localhost/reports Go to properties tab (SSRS 2008) Security->New Role Assignment Add DOMAIN/USERNAME … Read more
Create functions in the code under the report properties: Page Number: Function PageNumber() As String Return Me.Report.Globals!PageNumber End Function Total Pages: Function TotalPages() As String Return Me.Report.Globals!TotalPages End Function Access it in the body via an expression: =code.PageNumber & ” of ” & code.TotalPages Check out Sample Usage of the Concat Function
I do this for my work currently with VS 2012 .NET 4.5 for reporting automation for PDF reports. A. For ease of use compiling your own proxy class is easier than referencing the web service each time as you may forget the service name. From Visual Studio Command Prompt: wsdl /language:CS /n:”Microsoft.SqlServer.ReportingServices2010″ http://<Server Name>/reportserver/reportservice2010.asmx?wsdl reference: … Read more
In SSRS 2008, there isn’t much difference between rows and columns.* A Table is an instance of a “Tablix” which has the detail group on the rows. You can have your table either repeat rows or columns based on the groupings and where the details group is set. You can create a horizontally expanding table … Read more
I’ll answer my own question. From within any expression, it’s possible to perform lookups in all datasets. Through this way we’ll get the data: LookupSet(SourceFieldToCompare, TargetFieldToCompare, ResultField, DataSet) Now, let’s raise the bar for the question and say the data is grouped in yet another dimension, months – like this: Category | January | February … Read more
I really haven’t messed with SSRS – but my ASP.NET hat tells me you may want to wrap that stuff in an if (!IsPostBack) block to keep it from running on the page refresh. My guess is that ReportViewer1.ServerReport.Refresh() pulls the default values again. protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { ReportViewer1.Width … Read more
To dynamically change the color of a text box goto properties, goto font/Color and set the following expression =SWITCH(Fields!CurrentRiskLevel.Value = “Low”, “Green”, Fields!CurrentRiskLevel.Value = “Moderate”, “Blue”, Fields!CurrentRiskLevel.Value = “Medium”, “Yellow”, Fields!CurrentRiskLevel.Value = “High”, “Orange”, Fields!CurrentRiskLevel.Value = “Very High”, “Red” ) Same way for tolerance =SWITCH(Fields!Tolerance.Value = “Low”, “Red”, Fields!Tolerance.Value = “Moderate”, “Orange”, Fields!Tolerance.Value = “Medium”, … Read more
No, not in a MVC view. But you can have a web forms pages which have server controls in them mixed in with your MVC site. Hmm, just googled “mix asp.net mvc and web forms” to find some examples, and google questioned whether I’m human or not 🙂 Anyway, here’s a link – http://www.packtpub.com/article/mixing-asp.net-webforms-and-asp.net-mvc – … Read more
This sort of approach does actually work very well. You haven’t given any idea of what your data/metadata is like, but the concepts can be explained with a simple example. Consider the following data: We will make a simple report based on this, grouped by the grp column: Sort the groups by total val, from … Read more
Have a look at this article on Passing Multivalued parameters. Basically the above link contains a workaround to meet your requirement for an optional multivalued parameter. The steps to achieve this are as follows: Replace “ALL” with ” ” (BLANK) in the parameter’s dataset query. Assign -1 as default parameter value for your multivalued parameter.