Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.
View Complete Post
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 am able to deploy reports and run them as the farm admin that I did the Grant entry for in CA > App Mgt > Reporting Services > Grant DB access.
However, my AD personal user that has Local admin on every server has integrated SA security to the SSRS and Sharepoint Database is aÃÂ Farm admin get's this error trying to run the reoprts.
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Now if I log in as the farm admin ( the user I did the grant on) I can run and add the reports to the SSRS webpart... Am I going to have to add every user through that Grant feature? With integrated Sharepoint security there is no /reports virtual to decide what users can runÃÂ what reports so I'm not sure..
SomeÃÂ other details.. I'm using Kerberos security, and CA > App mgt > Reporting Services > Manage integration mode is set to Trusted (not Windows).. otherwise .. I can't pull up Default settings under that Reporting Services section of CA.
I also d
Hello,I am using the Page Viewer Web Part to display a Reporting Services report in SharePoint. It was working fine until I tried caching the report in Report Manager. Now, whenÃÂ runningÃÂ the report in SharePoint, the Dundas Charts and Map that are in the report aren't displaying. It's just the typical red x instead of the pic. If I right click and do Show Picture it works, but that won't work for end users obviously. I do have a regular SSRS table at the top of the report, and that displays fine every time.Does anyone know what is causing this? I'm thinking it must have something to do with caching the report and/or Dundas, because again, everything was fine until I set it to cache.Thanks for your help.
I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that was put on to the system in the last minute. The auto refresh property
on each report is set to 60 sec. to trigger the refreshing of the reports.
The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.
I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance.
The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.
I CANNOT FIGURE OUT HOW TO GET THIS TO HAPPEN, PLEASE ANY HELP WOULD BE APPRECIATED!!
I figure it is a caching issue but how to get around? HELP!
Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other
machine? I should add that now i have to develop on laptop only before i was on the server.
If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.
i hope jin chen would read this.
i followed his instruction from the link above(in the title)
i still got an error message :
System.Web.Services.Protocols.SoapException: An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC42105] Function 'RemoveDups' doesn't return a value on all code paths. A null reference exception could occur at
run time when the result is used.’.
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetReportDefinition(String Report, Byte Definition, Warning& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.SetItemDefinition(String ItemPath, Byte Definition, Property Properties, Warning& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2010.SetItemDefinition(String ItemPath, Byte Definition, Property Properties, Warning& Warnings)
could anybody tell me what's wrong?
and by the way,
i'm using ssrs 2008 r2
i use report builder(content type) to create reports from sharepoint lists.
thx in advance.
dynamic layout or zone for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.
We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.
The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.
Both in the BIDS environment as well as the report site the report is very slow.
We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.
Can anyone please help me here?
At present, I am having some SSRS reports hosted on share point portal and For one report, I am subscribing thorugh manage subscription by mentioning the dropdown values (The Selections
which are required for the report) as parameters. So that, I am going get a mail for the report for the selection which I made from the report.
Now The Issue is, for every combination I should need to select the parameters and need to subscribe for that. Is it possible to mention all the selection crieteria at once and run it in one shot?
Can we write any backgroud job to complete all the selection criterias at once?
Please help me on this.
my environment as below:1- SERVER A (SQL server DB 2008 sp1)2- Server A (SSRS 2008 sp)3- SERVER B MOSS 2007 sp1I configured the SSRS to be sharepoint intergated mode but when iÃÂ hit the Web Service URL i got the error below:
I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.
My Data Source Properties are as per below
Use this user and Password
user name: domain\myadminuser
Selected: use as win auth
How Can I get rid of prompt?