Using SSRS (2008) what is the best way you have found to handle null or empty values and replace them with something else to display. The quite obvious solutions is =IIF(IsNothing(Fields!MyField.Value),"NA",Fields!MyFields.Value) That works though it is tedious, my hope was to find something like an EmptyText property on the textbox b...
I have a stored proc that basically is used for logging reports that were executed with their parameters. I'd like to run this stored proc on every execution of the report? Do I do this through the report code window? ...
Anyone have a clue what this error message means? An unexpected error occurred while compiling expressions. native compiler return value ‘128’ ...
Hello, I'm writing my first SSIS pkg and I'm stuck. Any insight would be greatly appreciated. I'm running a sql agent job that kicks off a SSRS report. (The job was generated via a scheduled subscription.) This report relies on 2 stored procs which require the parameter 'When' (date type) and it dumps a PDF of the report to a file sh...
In my SSRS report there are 2 parameters called DataSourceIDList and ReporterIDlist. DataSourceIDList : is a drop down list and this will populate based on SQL query. ReporterIDlist : is a drop down list and this will populate reporters based on selected Datasourceid from DataSourceIDList and this is also a SQL query. both parameters ...
My SSRS report contains 7 input parameters and while running my report the size of the parameter(i.e. length) is increasing. One of my input parameter(drop down list) may contain 100 characters so the size is not constant but i want to place all parameters in 2 lines or 3 lines(in a row). Now it is coming 2 parameters per a row Please...
SSRS has a find button on the toolbar. Hosting an SSRS report control in ASP.NET and when you use the find and it finds something at the bottom of the report, it doesn't scroll down automatically. Wondering if anyone has seen or done anything to make the scroll happen on find in the SSRS report? ...
I am hosting a SSRS report through the SSRS Report Viewer Control inside a ASP.NET web form. For the action property on a text box I am setting the following expression. =Parameters!URL.Value & "?customerid=" & Fields!CustomerID.Value The desired result is something like this. URL = “http://www.google.com/somesamplepage.aspx?custome...
I have a field in SSRS and it returns from SQL saying "Incomplete" In SSRS I want to say anytime this field says "Incomplete" to change the string to "Pending" This has to be done in SSRS. Thanks! ...
I am writing a report in SSRS 2008 that has the following advanced layout: Static Static Static Static Group1 Details Static Static The settings for the top 4 static rows (which are my headers) are set to RepeatOnNewPage = true, FixedData = true, and KeepWithGroup = After. When viewing the report through SSRS or through V...
We would like to have a SSRS report open up in an Excel spreadsheet within the SSRS environment rather than exporting it from the SSRS environment to Excel. Is this possible? ...
I am doing the basic drilldown that you learn in an intro to SSRS. No big deal, takes 30 seconds to set up and you should be on your way. My drilldown works fine when I preview in Visual Studio as well as on my report server website. But in my ASP.net application the report renders, I have the groups to start as collapsed. I click to exp...
I have a very basic question with the Microsoft CRM 4.0 Report wizard. I am very experienced in SQL syntax and database queries, but I have no knowledge of MS CRM and SSRS. I was helping someone create a SSRS report via the CRM wizard tool, and I'm trying to understand what the "Primary record type", and the "Related record type" is. ...
Hi all, I am working on a couple of matrix reports for an asp.net web app using ssrs report viewer. I would like some advice on best practises for loading the data for the report. ie. is there a preferred structure or order to return the data in which would help performance ? can I take advantage of tsql pivot to help improve efficie...
I'm trying to help my power users have more access to our data so I don't have to interrupt my work (playing Pac-Man) 25 times a day writing Ad Hoc Queries and such. I'm trying to use Data Source Views, Data Models, and Report Builder 2 and 3 to allow them to have access to cleansed data in which they can safely do their own basic anal...
Hi, I am trying to access SSRS generated reports in Classic asp. I do not have any idea on that, how to do? Could anybody there to help me? Thanks, ...
My boss wants me to create a few reports in the near future and I think he wants to use SQL Server Reporting Services to deploy the reports. I'm not so sure this would be such a great idea considering that we are a pretty small organization and I cannot see us making good use of or needing the features that this solution offers such as s...
Ok, i need to write a report in Arabic (ar-AS), the information for this report is in a database in English, with varchar columns (not nvarchar) with collation SQL_Latin1_General_CP1_CI_AS The Language Settings for Reports and Report Designer only changes dates, currency, and numbers to the given language. I also need static text (colum...
Is it possible to have multiple series of stacked bars in SQL Server Reporting Services. So in effect, a group within a group? ...
In SSRS I have a parameter that is populated from a multi-value list which allows a blank value. When I select just the blank value it returns unit 123 When I select just "New" it returns unit 987 When I select both owner "New" and the blank value it only returns 987. Any ideas? Does SSRS not allow you to pass the blank value and a n...