Does anybody have the list of SSRS 2008 bugs fixed in R2?
Also, SSRS 2008 does not allow text box number formats to be based on expressions. Is it fixed in R2?
View Complete Post
MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.
SubReport1: a textbox showing "Sub Report 1"
SubReport2: a textbox showing "Sub Report 2"
I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.
But I only see SubReport1 in Page 1 and Page 2 is a blank page.
These reports work in SSRS 2005, but not in SSRS 2008.
<?xml version="1.0" encoding="utf-8"?>
I'm, workin at the moment on a report for my company. I have a problem with searching in a parameter list which is based upon a parent child hierarchy. The users asked me for type in the first few characters to search the parameter faster (like in this
post ) , because it's a large hierarchy with about 1700 values. In a "normal" list ("linear" without a hierarchy) this feature is available.
So my question:
Isn't it possible to search in the parameter list in general if this is based upon a hierarchy?
Are there any possibilities or suggestions to get this feature?
Or is this the only way to do this:
Thanks in advance!
How can we sort the parameter list in report created using report model in ssrs 2008 r2? Do I need to change some property in Model or elsewhere?
I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend. Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint. The upgrade went fine, no errors that i could
find. The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.
I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application
however when i do click the new report builder report it kicks me over to
http://company.com/ReportServer_MossEnt which itemizes out each individual sharepoint site in the farm.
Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work? did i install the wrong version of the report builder add in? The above is the only problem i am having now.
all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu
I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS. Here is the run down:
Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)? Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?
I am required to plot the following graph in an SSRS report.
Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.
(Sorry for the diagram below, i tried to paste an image but it didn't work)
SSRS 2008 date validation Hello,
Perhaps somone can shed some light on this. I want to make sure the user doesn't set a Startdate > EndDate in a report.
I've done some thing like this:
Go to the Report Properties under the Report menu and place this code to the Code Tab.
Public Function CheckDate(SDate as Date, EDate as Date) as Integer
Dim msg as String
msg = ""
If (SDate > EDate) Then
msg="Start Date should not be later than End Date"
If msg <> "" Then
MsgBox(msg, 16, "Parameter Validation Error")
Err.Raise(6,Report) 'Raise an overflow
Then go to the Report Parameters and Add named it XXX with the datatype is string. Checked the Hidden and Allow blank value ckeckboxes. In Available Values choose Non-Queried and from Default Values choose Non-Queried in right side of textbox then press the
FX button then paste this code.
But I'm having problems with the =CODE.CheckDate( .Value) syntax.
SSRS errors out.