Liste Of Report Made With ReportBuilder

Aug 7, 2006

Hi !

I'm trying to figure out how can i get a list of the reports made with reportbuilder. I have create a folder in ReportManger and all my report are in this folder.
When i create report with ReportDesigner i get a .RDL file, but when i create a report using reportBuilder i can't file the file created. What i want to do is to create in our web application a Web page with a list of report that our client has create using ReportBuilder. I was thinking about doing a loop on the folder for each report File but i can't find those files.

Any idea ?

Thanks!

View 7 Replies


ADVERTISEMENT

Dynamic Report Using ReportBuilder

Jan 4, 2008




I am using a Visual Studio 2005 for web application development, for Reporting service

I am using Sql Server Reporting Service and Report Builder 9.0.1399.0.

Is it possible to use the Report builder tools (Explorer, Fields and Design Report) in

an ASPX pages?.

Is it Possible to create the Reports dynamically in a Web Application using Report

Builder?


Thanks in Advance
Thanigaivel

View 1 Replies View Related

ReportBuilder / Report Model Explanation Needed

May 1, 2008

(I wish I was able to attach pictures....anyhow I'll try my best without them)

The customer's goal is to via ReportBuilder to select fields from multiple
many-to-many relationships. They are able to see the fields that exists
within the various many-to-many relationships but IS ONLY able to select
fields from ONE many-to-many relationship. Example using AdventureWorks:

DataSourceView (relationships automatically generated by wizard)
Contact ---< VendorContact >--- Vendor
Contact ---< StoreContact >--- Store
Contact ---< ContactCreditCard >--- CreditCard

So the goal in the ReportBuilder is to be able select fields from
Contact/Vendor/Store/ and CreditCard.
PROBLEM is that the ReportBuilder ONLY allows user to select fields from
Contact/Vendor OR Contact/Store OR Contact/CreditCard (exclusively)

The only workaround I've found is to reverse the relationships in the
DataSourceView to the following

Contact >--- VendorContact ---< Vendor
Contact >--- StoreContact ---< Store
Contact >--- ContactCreditCard ---< CreditCard

This works however we need an explanation as to why it only works this way?

Thanks in advance

View 1 Replies View Related

Deploying A Report Services Application To The Local Host; Error:A Connection Could Not Be Made To The Report Server

Feb 23, 2007

I installed SQL reporting services 2005 and successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/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)

------------------------------

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

Can anybody provide a solution for this issue....

Thanks in advance

Nirupa

View 4 Replies View Related

A Connection Could Not Be Made To The Report Server

Apr 1, 2007

While attempting to deploy from within VS2005 running on 2003 server we get the following error:



TITLE: Microsoft Semantic Model Designer
------------------------------

A connection could not be made to the report server http://xxxxx:90/ReportServer.



Running sql2005 sp2 integrated w Sharepoint 2007



Thanks..


View 12 Replies View Related

A Connection Could Not Be Made To The Report Server

Feb 23, 2008



hi,

I got this error when I was trying to deploy the reporting into IIS..


TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/reportserver.

------------------------------
ADDITIONAL INFORMATION:

The server committed a protocol violation. Section=ResponseStatusLine (System.Web.Services)

------------------------------
BUTTONS:

OK
------------------------------

I am not able to solve it please help.

Thanks.

View 1 Replies View Related

A Connection Could Not Be Made To The Report Server Http://localhost/ReportServer.

Jan 19, 2007

Hello Guys,

Please take me out from this hell. I created report using VS2005 Business Intelligence Project. It builds fine. I can also see data in the design time. But when I am trying to deploy it gives me this error.

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> c:inetpubwwwrootweb.config<b> Line: </b> 0
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

</font>

</body>
</html>
<!--
[HttpException]: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied.
at System.Web.FileChangesMonitor.FindDirectoryMonitor(String dir, Boolean addIfNotFound, Boolean throwOnError)
at System.Web.FileChangesMonitor.StartMonitoringFile(String alias, FileChangeEventHandler callback)
at System.Web.Configuration.WebConfigurationHost.StartMonitoringStreamForChanges(String streamName, StreamChangeCallback callback)
at System.Configuration.BaseConfigurationRecord.MonitorStream(String configKey, String configSource, String streamname)
at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()
[ConfigurationErrorsException]: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied. (c:inetpubwwwrootweb.config)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)
at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)
at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring()
at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()
at System.Web.Management.HealthMonitoringManager..ctor()
at System.Web.Management.HealthMonitoringManager.Manager()
at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source)
at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)
at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)
-->
--. (Microsoft.ReportingServices.Designer)

------------------------------
BUTTONS:

OK
------------------------------




View 8 Replies View Related

A Connection Could Not Be Made To The Report Server Http://localhost/reportServer..

Sep 18, 2006

hi,

I got this error when I was trying to deploy the reporting into IIS..

A connection could not be made to the report server http://localhost/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)

------------------------------

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)


I am not able to solve it please help.

Thanks.

View 12 Replies View Related

Error Connection Could Not Be Made To The Report Server When Attempting Deployment

Apr 5, 2006

I'm working through the SQL2005 Reporting Services Tutorial. When I try to deploy, I get the error "Connection could not be made to the report server." It appears that I do not have permissions to get to localhost/reportserver (I get a permissions error when just trying to get there directly from "run"). In another forum I saw several people having the same issue. One contributor said that the problem was solved for him by uninstalling SQL2005 and reinstalling using the local system account rather than a windows domain account. I tried that, but am getting the same error. Anyone know how to fix this?

View 18 Replies View Related

A Connection Could Not Be Made To The Report Server Http://[IP Address]/ReportServer

Dec 6, 2006

Hi

I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is

The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)

Please let me know what all I need to do to resolve the problem.

Regards

Rajesh





View 1 Replies View Related

An Attempt Has Been Made To Use A Data Extension 'ORACLE' That Is Not Registered For This Report Server.

Oct 29, 2007



I am attempting to deploy a sample report (SQL 2005 Workgroup w/SP2) and I am receiving the subject error message when I attempt to view the report on the web server. We are using SQL Server 2005 Workgroup Edition connecting to an Oracle database.

Is this a limitiation of this version? In report designer, I am able to select Oracle as a connection type. If I try to create a data source at the server, "Microsoft SQL Server" is the only option available. If I look at the ReportServer config file, I see many other data connection types available. Did I miss a step, or is this a Workgroup Edition limitation (it's not documented as a limitation that I am able to find)?

Thanks in advance...

View 1 Replies View Related

Can't Launch ReportBuilder

Feb 20, 2008

I was the happy admin of some reportservers (build 3175) until someone asked me to get the ReportBuilder to work. I've read through the documentation and configured the SSRS site security so that the icon is visible. However when I click on it nothing happens. If I try to launch it by right clicking and then save as -- open I receive the following error:

- Downloading file:///C:/UserTemp/_temp/ReportBuilder.exe.manifest did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.WrappedGetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: mscorlib
- Stack trace:
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, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Here are the things I have checked/tried:



Ensured the .NET Framework Reliant components are enabled in the browser

Running the browser with a user account that is local admin on the workstation

MIME settings on IIS server look ok

I am not seeing any access denieds on my workstation (checked with file and regmon)

I am not seeing any failures in the security event log

For the test that I am doing, both the user account, workstation and server are in the same domain

Don't see any errors in the SSRS logs
Can anyone think of anything else that would lead me to resolving this problem?

Thanks

View 3 Replies View Related

How To Integrate Reportbuilder With A .Net Web Application?

Oct 12, 2006

How to integrate reportbuilder with a .Net web application?

View 1 Replies View Related

ReportBuilder And Forms Authentication

Aug 6, 2007

We created a custom security extension for RS using Forms Authentication. The issue I am having is in ReportBuilder when the forms authentication ticket expires. Forms auth will attempt to redirect (send a HTTP 302) and the report builder will show the error message "Object moved to here" instead of prompt for credentials. I have been watching the IIS logs and I see the first time report builder start it attempt to connect using default windows credentials and after the FormsAuthenticationRequired exception it will prompt for credentials and invoke LogonUser method, but this only happens the first time or if change the server in the url. I was expecting ReportBuilder to consider the Forms Authentication expiration at any time.


Do you have any idea how to work around this?

Any help is really appreciated.


Thanks

View 6 Replies View Related

Question About If Condition In ReportBuilder

May 11, 2007

I have a question about table layout report. I want to do that:



I have a table report and on that report i have a Total field of money. And i want to do that if condition on that field, so if the prize is less then 150, the color of the text it should be red otherwise it should be other color. So how can i achieve that. I know that this is possible in Reporting services in Report Designer is like =IIF(field.???.Value<150;"red";"gree")

But if i make that same in report builder, the what it does, it displays not the value in color, but it displays the text "red" od "green".



I will be very happy and gratefull if somebody can help me.



thank you in advance.

View 2 Replies View Related

ReportBuilder Filter Width

Nov 9, 2007

Hi,
Is there a way to change the size of the fields (in this case a drop down list) on the filter page of ReportBuilder? I have an attribute I want to filter by, but the contents are too wide so the full thing can't be read if I set up an 'equals to' filter in ReportBuilder.

Thanks.....

View 1 Replies View Related

Possible To Open Reportbuilder From Within A Web App And Pass Credentials?

Nov 4, 2007


I am trying to open the reportbuilder from within a web application so that I can pass the credentials. I would like to be able to have the reportbuilder open within the app. Is this possible.

I'm trying to avoid keeping the report builder credentials and the app's credentials both up to date.

Thanks.

View 2 Replies View Related

Reportbuilder.application Authentication Error

May 10, 2006

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-------------------------------

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

View 1 Replies View Related

Visual Studio VS ReportBuilder Problem

Jul 31, 2006

Hi !

We have made a lot of reports using Visual Studio. Now some of our client would like to customize those reports. We have install ReportBuilder on their server to allow them to create their own reports. Everything is working fine when they are trying to create new reports. The problem is when they are trying to customize reports that we have made using Visual Studio.

When they are trying to open those reports in ReportBuilder they get this Error:

One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSetMicrosoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.GetModelItemIDAndItemSecurity(ModelCatalogItem model) at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.LoadModel(ModelCatalogItem model, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadUserModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, String perspectiveID) at Microsoft.ReportingServices.Library.GetUserModelAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)

We get this error for each report that we have create under Visual Studio (All those report use parameters). Is there a way to allow our client to customize those reports ?

Thanks !!

View 8 Replies View Related

ReportBuilder.Application Will Not Work On Client On Network

Apr 10, 2006

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [4/10/2006 11:34:29 AM] : Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [4/10/2006 11:34:29 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Does anyone know how that I can get the reportbuilder.application to run on a client on the network. It seems that if I have to remote into the actual server to get the report builder to work would be pointless for users on the network. I get the 401 Unauthorized all the time. Any comments would help.

Jordanb412

View 3 Replies View Related

Problem With Starting Reportbuilder Application When Using ISA Server

Nov 19, 2007

We have installed SQL Server 2005 reporting services and reportbuilder.
On the local machine and local network we can start and use reportbuilder perfectly.

We are using ISA server for security. When we get around ISA it works fine, but when we have to get access via ISA, we get the error 'unauthorised', when starting the reportbuilder application.

The virtual folder 'reportbuilder' is configured in IIS for Anonymous access, the report en reportserver virtual folder, we need basis authentication.

Can someone help?

View 3 Replies View Related

I Have Made It This Far...

Sep 6, 2007

Ok I have my login controls working perfectly, my roles function perfect now come time to upload to production server I find I need to convert this to either .sql or .csv file to allow for importation.
 
Is there a S/W Package available for doing this?

View 1 Replies View Related

How To Get Last Payment Made

Jun 20, 2007

I need to get the clientid, last payment date, and last payment amount. I have tried using MAX but this does not work. Can anyone see what I'm doing wrong? I get all payments and all dates. I'm summing the payment amount incase they made two payments on the same day, not likely but...
SELECT     dbo.tblLoan.Client_ID, MAX(dbo.tblPayments.PaymentDate) AS [Last Pay Date], SUM(dbo.tblPayments.AmountPaid) AS [Last Pay Amt]FROM         dbo.tblLoan INNER JOIN                      dbo.tblPayments ON dbo.tblLoan.Loan_ID = dbo.tblPayments.Loan_IDGROUP BY dbo.tblLoan.Client_IDHAVING      (dbo.tblLoan.Client_ID = @Client_ID) 

View 3 Replies View Related

I Think I Have Made Something Way To Complicated...

Dec 27, 2007

All I am trying to do is use a SqlDataSource, Read that Data from the Session Variable, Do a RowFilter off the Data and then return the Data (Currently a DataSet but doesnt matter).  But Since I dont use SqlDataSource that much not sure all the code I have is neccasry:
 protected DataSet GetSearchAppData(string strWhere)
{
DataSet dsSearchAppTable = new DataSet("SearchAppTable");
SqlDataSource ss = new SqlDataSource();
DataView dv = new DataView();
DataSourceSelectArguments dsArgg = new DataSourceSelectArguments();

dsArgg = DataSourceSelectArguments.Empty;
ss = ((SqlDataSource)Session["SearchAppTable"]);
dv = (DataView)ss.Select(dsArgg);
dv.RowFilter = strWhere;
dsSearchAppTable.Tables.Add(dv.Table.Clone());

return dsSearchAppTable;
}
 And to mention it, dsSearchAppTable returns a Table with 0 rows.  Not sure what the heck I'm doing wrong.
 
J

View 1 Replies View Related

Can This Be Made Into A Query

Feb 19, 2008

I am trying to make a query that would list all the rows in a table called tickets. It should order the results based on the amount of rows another table has, called rating, but only the rows where the ticketid (primary key) matches and where the date is a required date or higher. It should also order them based on the osid which is located in a systems table (there is a relationship between tickets and systems). So: Order by rows in ratings table relating to ticketid that happened in last week (or another min date)Only display it where osid in systems matchs (easy enough) 

View 2 Replies View Related

Where Should Be The Calculations Be Made?

Mar 28, 2007

where should be the calculations be made based on performance, in SQL or in front end?

thanks.
-Ron-

View 7 Replies View Related

Who Nos When The Polygon Made Up In

Mar 3, 2008

i need help on this one

View 8 Replies View Related

How Can I Made SQL Modifications That I Can Do At EM ?

Aug 14, 2006

Hi all, this probably is a stupid question, but here I go.
I have read in some places that you can't set up an already existent column as IDENTITY, but in Enterprise Manager, you can do it. My question is, how EM can do this? Because I need to do this in a lot of databases, and I have to do this by SQL.

Kind Reggards
Dirceu

View 4 Replies View Related

Keep Track Changes Made In Data

Aug 23, 2006

I want to create a page(using GridView) where it will detect changes made in the database and display it for Administrator observation. I've created a table name history for this purpose.
History
guid (uniqueidentifier)
dateCreated(datetime)
lastDateUpdated(datetime)
changesMade(varchar(50))  ---- eg; dropdownlist
oldValue(varchar(50))  ----- compaq
newValue(varchar(50)) -----dell
updateBy(varchar(10)) <------ username of registered user
comNo(int) = foreign key for Computer table
History data will insert data whenever a changes made. Could anyone advise and direct me how to do this function. I was thinking of using stored procedure to insert the data. Thanks in advance.

View 17 Replies View Related

Firing Already Made DTS Package -- From Vb.net

Apr 13, 2005

Someone please help me with this. 
I'm trying to fire off an already created DTS package.  This package is stored within SQL Server's -- underneith the Data Transformation Services / Local Packages section. 
HOW CAN I FIRE THIS OFF FROM A VB .NET APPLICATION
I'm familiar with strored procedures and using them in vb.net so if somone could lead me down that road I would be very much appriciated. 
Thanks in advance everyone,
RB

View 4 Replies View Related

Tracking Changes Made In The Database

Sep 12, 2000

Here is the situation. I have an employee who is making changes but I can't prove it. He thinks he knows more than he does and he's mess'n everything up. I would like to know if SQL or some third party product has the capability to see the change and log what was changed with the persons username attached?

View 1 Replies View Related

Is There A Way To Log Connections As They Are Made To The Server?

Mar 7, 1999

Is it possible to capture in a log, all users who connect to the database?

View 2 Replies View Related

Selecting The Last 3 Orders Made

Apr 25, 2007

Hi guys

Am new in SQL server. i use SQL server 2003 ans am trying to retieve the last three orders made. Can you please help me with my Select statement so that it will only select the last three coz @ the moment it selects everything

CODE:
SELECT dbo.Invoice.InvoiceNo, dbo.Sales.UnitsSold, dbo.Sales.QuantitySold, dbo.Sales.CostAmount, dbo.Item.ItemCode, dbo.Item.ItemDescription,
dbo.Item.Item, dbo.PurchaseOrder.OrderNumber, dbo.PurchaseOrder.OrderDate, dbo.PurchaseOrder.OrderStatus, dbo.PurchaseOrder.QuantityOrdered,
dbo.PurchaseOrder.QuantityReceived, dbo.Customer.CustomerCode
FROM dbo.Invoice INNER JOIN
dbo.Sales ON dbo.Invoice.InvoiceKey = dbo.Sales.InvoiceKey INNER JOIN
dbo.Item ON dbo.Sales.ItemKey = dbo.Item.ItemKey INNER JOIN
dbo.PurchaseOrder ON dbo.Sales.VendorKey = dbo.PurchaseOrder.VendorKey INNER JOIN
dbo.Customer ON dbo.Sales.CustomerKey = dbo.Customer.CustomerKey

Thanks
Noks

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved