Hi,
I have a web project and created a setup project for it. And I have to create reports using sql server reporting services. For this I have created an reportserver project and created two reports.
I have to create a setup file to install these reports in a remote machine.
How to do this?
where this .rdl and .rds files will be stored in the reportserver.
Regards,
Murali
I have created a report project file on my local machine.Now I'm trying to deploy those reports to a development server. I have installed sql server and tools in my local machine but never configured reporting services. When I try to deploy those reports, it asks username and password for reporting services login.
But usually as far as I know, i should be able to deploy my reports without entering password etc. Even if I enter username and password, still they dont work.
Is that becase I install SQL server in my local machine?
Does anyone know why?
Thanks
Hi, i have installed SQL Server Advanced With Reporting Service following the instructions on the SQL video. Everything works fine.
Afther i have make a report with Business Intelligence Studio Express
( using the wizzard ) i try to deploy (local , ISS 5.1 on Win XP SP 2) this report by clicking right mouse on the projectname and then deploy.
In the messagebox : no errors, build and deploying. When i serve to http://localhost/reports..... nothing is changed on the main page and i can't browse to my reports. Can someboy help me.....please
Thanks
Hi,
I am a beginner with SQL Reporting Services and having a problem. I can deploy reports with no parameters and the datasources fine. But when I deploy a report with a parameter I get the following error "An unexpected error occurred in Report Processing." I looked at the log file and this is what I found. Any suggestions on how to fix this?
aspnet_wp!processing!7!10/03/2007-14:59:11:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.IO.FileNotFoundException: Could not find file 'C:Documents and SettingsD2P6PM51ASPNETLocal SettingsTempexpression_host_a23b56b0ae874a989c3e9c76fe9a07ff.dll'.
File name: 'C:Documents and SettingsD2P6PM51ASPNETLocal SettingsTempexpression_host_a23b56b0ae874a989c3e9c76fe9a07ff.dll'
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at Microsoft.ReportingServices.ReportProcessing.ReportCompileTime.InternalCompile(Report report, AppDomain compilationTempAppDomain, Boolean refusePermissions)
at Microsoft.ReportingServices.ReportProcessing.ReportCompileTime.Compile(Report report, AppDomain compilationTempAppDomain, Boolean refusePermissions)
at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.Phase3(ParameterInfoCollection& parameters, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)
at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] definition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileReport(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)
--- End of inner exception stack trace ---
Thanks
Allan
Hi, I am a new user for RS so this might be a very dump question for some of the advanced users here.
I am using SQL 2005 RS and was wondering how I can deploy reports to specific folders that I created on the Reports page. I do know that I can go to Properties to move the reports to different folders. But the problem I have is when I deploy the reports from VS 2005 ( I created the reports using VS 2005) they were deployed back to the old/root folder. How can I change the 'deploy-to' destination folder for the reports in VS 2005?
Many Thanks,
Casey
Hi,
I am creating a application to show reports for daily based information.
I have created the reports and i am changing the data source at run time.In order to view the updated reports, i have to deploy.
So i need to deploy the reports automatically.
can any one gave a idea to do this.
thanks
I am using Visual Studio 2005 and trying to deploy reports to SQL Server 2000.
I get the following message:
A connection could not be made to the report server http://aklink1/reportserver.
------------------------------
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
Please help!
This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services.
I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out"
When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio.
Thoughts?
Thanks
Hi,
I'm just wondering if there is any easy way to deploy reports to multiple servers. My current issue is that I need to deploy tens of reports onto tens of production server. Does anyone know how to do that?
Thanks a lot.
Cheers,
Cannot deploy reports to default website get error msg..
'A connection could not be made to the report server http://localhost/ReportServer'
additional information:
The request failed with http status 400: Bad Request. (Microsoft reporting Services Designer)
We have a custom assembly that worked fine with SSRS 2000. Now that we have upgraded to SQL 2005 we get an "Access is denied" error when attempting to deploy reports that reference this assembly. I could swear that when we first attempted it it worked. We decided to make a minor change to the assembly code and that's when the problem started, even though I've since reverted back to the original code to make certain that the minor change wasn't the issue. The assembly is in the proper folder - C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerin - and the reports are referencing the current version. I've searched high and low on the web for an answer but have found nothing even remotely helpful. All this code does is return a string...it's not doing anything that should require any additional security; and even then I doubt if there would be a problem when deploying.
The full text of the error is:
Error while loading code module: €˜Reporting, Version=1.0.2778.12272, Culture=neutral, PublicKeyToken=null€™. Details: Could not load file or assembly 'Reporting, Version=1.0.2778.12272, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.
Any ideas? Anyone? I'm at my wit's end on this!
Thanks,
Mike
Hi,
I'm working with the Dec CTP of SQL 2005 SP2 and the associated Sharepoint addin.
I've been able to get a report created in VS2005 and manually uploaded to the Document Library holding reports, and the report works when I open it (using an internal datasource, not shared).
My first problem is I can't get VS2005 to deploy datasources or reports to my doc library.
I have configured
TargetDataSourceFolder http://server/site/doclib
TargetReportFolder http://server/site/doclib
TargetServerURL http://server/
When I try to deploy my Shared Data Source, it asks me to login, and will not accept my credentials (I am farm administrator, and site collection administrator, and local administrator, and a site owner)
Secondly, for the report I manually uploaded, I can't edit it in Report Builder (from Sharepoint) because I get stuck on entering something that works into the Select Site or Server dialog box. I've tried http://server/ and http://server/site/ and http://server/site/doclib
Can I have some tips please?
Thanks
Martin
Hi
Having finally managed to get over the hump of getting Sharepoint integrated mode working in a farm install, I am having a problem deploying reports from Visual Studio to Sharepoint.
I have set the deploy properties as follows:
TargetDataSourceFolder: http://ppdwn-bl10:8888/ReportTest/Data Sources
TargetReportFolder: http://ppdwn-bl10:8888/ReportTest/Harvest Reports
TargetServerURL: http://ppdwn-bl10:8888/
Visual Studio is updated to Service Pack 2, as is of course the report server.
The reports APPEAR to deploy - they actually appear in the document library after deployment! But the result is:
------ Build started: Project: Harvest Reports, Configuration: Debug ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Harvest Reports, Configuration: Debug ------
Deploying to http://ppdwn-bl10:8888/
Deploying data source 'http://ppdwn-bl10:8888/ReportTest/Data Sources/ReportWarehouse.rsds'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdownSaleable.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/FaceBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/LustreBreakdown.rdl'.
Report Server has encountered a SharePoint error.
Deploying resource 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/paspaley.gif'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPercentage.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ShapeBreakdownByPM.rdl'.
Report Server has encountered a SharePoint error.
Deploying report 'http://ppdwn-bl10:8888/ReportTest/Harvest Reports/Summary.rdl'.
Report Server has encountered a SharePoint error.
Deploy complete -- 9 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
Unfortunately I cannot view the reports in Sharepoint - I can see them in the document library but when I click them I get the same error, except in the web browser. "Report Server has encountered a SharePoint error".
The Report Server log shows the following:
w3wp!library!1!03/06/2007-09:38:24:: Call to GetPermissionsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl).
w3wp!library!1!03/06/2007-09:38:24:: Call to ListParentsAction(http://ppdwn-bl10:8888/ReportTest/Harvest Reports/ColourBreakdown.rdl).
w3wp!security!a!03/06/2007-09:38:24:: i INFO: Exception while running with elevated privileges
w3wp!security!a!03/06/2007-09:38:24:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
w3wp!library!a!03/06/2007-09:38:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error.
w3wp!security!a!03/06/2007-09:38:25:: i INFO: Exception while running with elevated privileges
w3wp!security!a!03/06/2007-09:38:25:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
w3wp!library!a!03/06/2007-09:38:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error.
Any help would be appreciated.
Thanks
Adam
Is there a known problem with BIS Deploy not clearing cache. I repeatly (but not always) have an issue where I will do a BIS Deploy of an RDL but when I run it, the old report runs. I can't clear this out until I explicitly log into the Report Manager and explicitly delete the RDL and re-deploy from the BIS.
Is there a workaround, fix, process change, configuration change I can do to keep this from happening?
Hello, I have a configuration where my SharePoint services are running on a web machine and the SQL server reporting services are running on a different machine.
I installed SQL SP2 and the SQL Server Reporting Services Add-in for SharePoint by following all the instructions listed in €œConfiguring Reporting Services for SharePoint 3.0 Integration€? (http://msdn2.microsoft.com/en-us/library/bb326356.aspx).
My issue is that when I Deploy a report from a VS Report Server project by running Visual Studio on the machine where reporting servicers is running, everything works fine.
But if I try the same thing on any other machine on the network, I get a €œThe file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.€? message.
I€™m sure I€™m missing something on the configuration but I can€™t tell what.
Thanks a lot
Gabo
I can't deploy reports on Visual Studio2005 anymore. I say "anymore", because a few months ago, this went well.
After building correctly, VS Studio asks for a Login for Reporting Services via a popup window. I don't know what to enter...
In IIS ( version 5.1) , I configured Reports and ReportServer for integrated Windows Authentication.
In Reporting Services Configuration, I have the Windows Security set on Windows Account, with a username and password that I also use (withoud success) to deploy the reports from Visual Studio. Since the user is a domain user, I tried as login also the complete domain name : domainusername. Nothing helps, the popup "Login for Reporting Servies" appears again and again.
If I change the settings in IIS to allow for anonymous access ( machinenameIUSR_machinename), I get the error message that the permissions granted to that user are insufficient.
I also changed the Windows Service Identity into "Local System" and "Local Service"; with the same result.
In the Log file of Reporting Services, I also find following phrase :
"ReportingServicesService!resourceutilities...INFO: Evaluation copy:0 days left"
I don't know of there is a link between this and my problems
Can anyone help me in this ?
So I get the basics, have a script that can deploy a single report to a single server. I have other simple scripts that work as well. Now I want a script that can deploy a single report to multiple Sharepoint servers. I have about 30. I know we are probably doing this wrong, as in, we shouldn't be deploying the same report to 30 sites, as they are all all technically all on the same server however they are all independent site collections so as far as I know there is no way to deploy them to a central location and then link to them from each site.
So I tried to copy elements of my single report deploy script and duplicate the Sub Main() to Sub Main1() and Sub Main2() with multiple "ParentPath1" dims, yes I know I'm stupid. That obviously didn't work. So looking at some other scripts including my own subscription updater and I'm sure I need to do some kind of "For Each item in X" but where to start. The other lists I've seen all come from rs.Something. My list is just 30 variables in the script, how can I say for each site in this list, Publish this report?
Here's the simple script that works fine. I just don't know how to modify it to make it deploy this to multiple sites. After I figure that out, I was going to accept the challenge of deploying multiple reports to multiple sites in a single script...
Dim warnings As Warning() = Nothing
Dim parentFolder As String = "Reports"
Dim filePath As String = "filepath"
Dim reportName As String = "Report file name"
Dim parentPath As String = "Sharepoint site URL"
Public Sub Main()
[Code] ....
I would like to deploy several reports to production server, Do i need to install reporting services entire software in order to run the reports or is it possible to just have runtime files installed on it to run the reports.
please help, i have almost 100 reports to be deployed on this server which is located in other country.
Thanks for the helpful information.
(i am using SQL server 2005 / reporting services 2005.)
Am getting errors trying to deploy a dtsx created by ms (the reporting services execution log one) to which I have made zero changes, but it is not working (2 errors shown below)
error from deployment wizard:
===================================
Could not save the package "H:SSISRSlogRSExecutionLog_UpdateinDeploymentRSExecutionLog_Update.dtsx" to SQL Server "xxxxxxxxxxx". (Package Installation Wizard)
===================================
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)
===================================
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
error from sql management studio
===================================
Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
Hi does anyone know how to do the above with out going through reportserver url?
Preferably by using a cmd tool ? such rs.exe
or through the backend in the reportserver DB?
Thanks
Dave
Hi Friends,
Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...
Could anyone explain me. How it works.
Thanks
sqlferns
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Thanks,
Patrick Conway
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
Is there a way to do this?
Thanks for your help.
Hi all,
I have two problems.
1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.
2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.
Thanks,
Mahesh Manthena
Dears,I have devoloped an application ASP.NET 2.0.Before I have builded the aspnetdb throught the command then I built some tables and stored procedures on this db. (My db is sql express 2005 and my hoster db is sql 2005 workgroup)My hoster doesn't allow connection Management studio express, doesn't allow attach or restore functionalities.Than I have built my script db (contains Tables, Views and Stored Procedures), I have substituted the dbo with my user account in the script because my hoster doesn't allow the dbo access.I have also transfered my site files (.aspx, img, etc.) on the server.When I try to access the db I receive this error (for example when I push on the button create user):The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file. Please could you help me? Thank you.
View 1 Replies View RelatedHi All,
Can anyone tell me,is it possible to create an exe or msi for sql stored procedures,tables and triggers?I want to deploy the database objects(stored proc,tables,views and functions) as an exe file..just like publishing and deploying the asp.net application.Is it possible for sql server database objects.Pls,let me know.
Thank U
I'm deploying an ASP .Net application on which 20 users will be working at the same time. The database will start at less than 100mb. Is SQL EXPRESS 2005 powerfull enough to use for such an application. Thanks in advance for your answers
View 1 Replies View RelatedI have a report that I am trying to deploy. I right-clicked my report in the solutions explorer, then select "deploy" but then I get the following error:
Microsoft Report Designer
The project cannot be deployed because no target server is specified. Provide a value for the TargetServerURL property in the property page for this project.
So then I go to the properties page but there isn't a TargetServerURL field! There is only a file name and full path field. Does anyone know what is wrong? Could it be that I need IIS installed on my machine?
More info:
Software installed from http://www.microsoft.com/express/sql/download/default.aspx:
-Microsoft SQL Server 2005 Express Edition
-SQL Server Management Studio Express
-Install Microsoft SQL Server 2005 Express Edition with Advanced Services
-Microsoft SQL Server 2005 Express Edition Toolkit
Windows XP Home Edition
Hi, all,
I am looking for a way to deploy SSIS pkg from dev to test/prod.
Both BOL and MSDN/TecNet samples are complicated. Do I miss the old good days of DTS!
Thanks!
Hi all,I'm new to SQLServer (Express edition) so I was wondering: if the webhost supports SQLServer 2005 do I just need to move the .MDF file to mydirectory on the web host to be able to use it?Thanks,Lorenzo
View 3 Replies View Related