MOSS and Reporting Services
Can I provision reporting services reports to MOSS 2007 or do I need to use Performance Point? Would love to hear how people have done this. ...
reporting-services
How to deploy RSWebParts.cab manually?
I'm using the SSRS 2005 Web parts to display my reports in a MOSS 2007 SP1 Portal. I have successfully installed the Web parts in my development, testing, and UAT servers using the following command: stsadm -o addwppack -filename path/to/RSWebParts.cab. But when I tried running the same command in the production server, it will give me t...
Reporting Services RDLC Table Page Breaks within a Cell with a SubReport
I am having a paging issue with my RLDC report that has a SubReport. The report has a table that prints the header data, then has a SubReport that I placed in a detail cell row within the table to print several detail lines that relate to the header data. This works as I want. However, the SubReport can span more than one page and this ...
How to Solve Intermittent error with Reporting Services: "This report requires a default or user-defined value for the report parameter '*'. To run or subscribe to this report, you must provide a parameter value."
I'm getting the error: "This report requires a default or user-defined value for the report parameter '*'. To run or subscribe to this report, you must provide a parameter value." very occasionally from my reporting server even when the value '*' is being populated. Any ideas or leads that might allow me to track it down. Some points. ...
Why does my SSRS page height expand when running subreports in a local processing mode ASP.NET report viewer?
I have a report with subreports and when running subreports it's as if the subreport height is not being taken into account. So for example ... if I had a report where 10 lines that would fit on each page and then mofified that report by adding a subreport that had child data (say 2 or 3 lines for each of the 10 lines of parent data), t...
ASP.NET MVC & SQL Server Reporting Services
I am getting started with ASP.NET MVC. Is it easy or even possible to use the ReportViewer in MVC as you can with webforms? If not, what can be done? ...
SSRS 2005 Multiple formats in a single textbox
Is it possible to have multiple formatting of a text string within a single textbox in SSRS 2005? example: The quick brown fox jumped over the lazy brown dog. possible setting font colors as well ...
How to pass parameter values in drill through reports?
Hi All, I am trying to give a link between two reports (back and forth), where both the RDLs are in same project. Each reports are having 2 multivalued parameter where the second parameter is dependent to the first one(cascaded). How do i pass the multivalued parameter . i tried giving parameter1= join(Parameters!PI_REGION_LIST.Value,"...
Is it possible to pass parameter for URL logo so the logo can be displayed on the report (reporting services)?
Hi there Is it possible to pass parameter for URL logo so the logo can be displayed on the report (reporting services / .rdlc file)? Thanks ...
How to compare in RDLC
I want a report .....report format it below Thana Good Removed NotFound A 2 3 4 B 1 0 4 C 1 4 5 Total 4 7 13 I have Three type GOOD,Removed,NotFound on my db data formate is below A GOOD A GOOD B NotFound C Removed B GOOD how can i compare string .....after compare how can ...
Is there a way to do SSRS Expressions in C#
I am working on a SQl Server Report Services project and the report I am creating requires some custom code. It seems that all expressions must be in VB.NET and I figured if there was an 'easy' way to switch that over to be C#, it would be helpful. EDIT: Well, I decided to move my code to another C# assembly that follows the patterns ...
Are rectangles fixed height in RDLC reports?
I have an RDLC report with a sub-report that I want to be A4 paper in height. The number of rows in the sub-report may vary, so I placed the sub-report in a rectangle so that if the sub-report is short the rest of my report doesn't shrink. - According to the documentation rectangles are fixed size. This works fine when I show the report...
Reporting Services, Custom Percent Format
I have some fields I currently populate with a P0. The results is like this: 2,434% I want however something like this: 2434% How do I do this? ...
SSRS 2008 Displaying Date Datetype correctly
I'm using SQL 2008 and SSRS 2008: CREATE TABLE [dbo].[DimDates]( [pkDateID] [int] NOT NULL, [FullDate] [date] NULL, [DayNumberOfWeek] [tinyint] NULL, [DayNameOfWeek] [varchar](9) NULL, [IsLastDayOfMonth] [char](1) NULL, [MonthName] [varchar](9) NULL, [CalendarDay] [smallint] NULL, [CalendarWeek] [tinyint]...
Interactive sort over multiple groups in ssrs
I have a report that is grouped by Region and then Office location. The users would like the ability to sort on a date value. I can get it to work for the innermost group (Office location). However they want it to sort the whole table. Any ideas? ...
ReportViewer - access subreport/drillthough in serverside asp.net
Hi, When using the ReportViewer control in an aspx page. If you fire an event (such as clicking a row) which then displays a sub/drillthough report...How can you access that Report object on the server side? There is a DrillThough event for the parent report object that gets fired...but it doesn't seem to have any access to the new rep...
Displaying Time Zone information in Reporting Service Reports (SQL 2005)
Hi, I have a Microsoft SQL 2005, reporting project. I want to display the Current date, time and timezone information on the page header. That is, I want to get a display as below 6/17/2009 12:25:11 PM +05:30 I added a text box to the page header. When set its expression to =Now, used the FormatDateTime function but they all either di...
Euro sign in PDF output from MS SQL Reporting Services
When I use FormatCurrency() in a report for Microsoft SQL Reporting Services I see a euro sign when I view the report through the report server's web interface in the default output format (or in Excel output) but when I export to PDF the euro sign becomes a small square. How can I get euro signs in my reporting services PDFs? ...
How to supress empty subreports in SSRS 2008
Hey all! I'm creating a 'master' report in SSRS 2008 that collaborates other reports about a person. Sometimes not all of the other reports are relevant and as such return nothing. I'd like to be able to exclude this from the master report so it does not leave a blank page. I'm aware of the 'no-rows-message' feature, but a whole page ...
Can't print report from SQL Reporting Services
I'm having an issue where I can view my reports in an ASP.NET environment, and can even export them, but as soon as I got print them, I get the following javascript error: "Object doesn't support this property or method" When I run the debugger, I see the following code: <HTML> <BODY onload="Print()"> <OBJECT ID="RSCl...