I only can create reports based on three predefined templates. It is very
restricted.Jun Yuan,
Don't choose the Wizard or you will be forced to use the templates.
Right click on your project. Choose Add new item... then choose Report.
You should be given a blank report and asked to specify a data source.
"Jun Yuan" wrote:
> I only can create reports based on three predefined templates. It is very
> restricted.sql
Showing posts with label builder. Show all posts
Showing posts with label builder. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Can views be used in query builder?
I tried it but got an invalid object error. I then copied and pasted the sql statement contained in the view but it doesn't run correctly inside query builder and only shows 1 valid row, and a 2nd row that's blank the the first column and has a number 1 in the second column. The view runs correctly in SQL Server Management Studio Express.
How about wrapping the view inside a stored procedure?
|||Stored procedures can't be used in query builder either. All I can do is put in a dummy SQL statement (like Select 1 as column1, 2 as whatever) and then change it to a stored procedure later when I have access to the "data" tab in [Design].
That doesn't seem right but is the only way I can figure out how to do it.
Tuesday, February 14, 2012
Can ODBC be used in Report Builder or Report Model?
Dear All,
Our company use DB2.
When I download Report Builder from Report site or when I create Report Model project in VS, I can only use SQL Server Data Source.
Can Report Builder or Report Model use ODBC?
Thank U.
I am pretty certain that report models can only be built from SQL server or Analysis Services data source. Support for other data sources has been rumored to be on the way, but who knows. This was a major disappointment for our company.|||You can use ODBC as a data source, but in a semi-roundabout way.
1. In SSAS, create a UDM (cube with multiple data sources) which points to your ODBC data source
2. Build an SSRS Model off the UDM/Cube (You must do so thru Report Manager, VS does not support building models from SSAS...only SQL)
3. Use the Model...
|||Not directly in this release. You can do it indirectly using SQL Server linked tables or by creating an Analysis Services cube first, then creating a report model on top of that.|||Where can I find the steps necessary on how to use linked server tables when creating a report model?
Thank you.
Patti Biggs
|||First, go to BOL and search on 'sp_addlinkedserver'. Then here are a couple of links to get you started.
http://www.sql-server-performance.com/linked_server.asp
http://www.databasejournal.com/features/mssql/article.php/3085211
R
Can ODBC be used in Report Builder or Report Model?
Dear All,
Our company use DB2.
When I download Report Builder from Report site or when I create Report Model project in VS, I can only use SQL Server Data Source.
Can Report Builder or Report Model use ODBC?
Thank U.
I am pretty certain that report models can only be built from SQL server or Analysis Services data source. Support for other data sources has been rumored to be on the way, but who knows. This was a major disappointment for our company.|||You can use ODBC as a data source, but in a semi-roundabout way.
1. In SSAS, create a UDM (cube with multiple data sources) which points to your ODBC data source
2. Build an SSRS Model off the UDM/Cube (You must do so thru Report Manager, VS does not support building models from SSAS...only SQL)
3. Use the Model...
|||Not directly in this release. You can do it indirectly using SQL Server linked tables or by creating an Analysis Services cube first, then creating a report model on top of that.|||Where can I find the steps necessary on how to use linked server tables when creating a report model?
Thank you.
Patti Biggs
|||First, go to BOL and search on 'sp_addlinkedserver'. Then here are a couple of links to get you started.
http://www.sql-server-performance.com/linked_server.asp
http://www.databasejournal.com/features/mssql/article.php/3085211
R
Sunday, February 12, 2012
Can not start Report Builder!
I just setup my dev server of SQL 2005 including reporting service on Windows 2003 SP1. Basically all settings are default.
When I activiate Report Builder from local, it works fine. Everything runs smoothly. However, we I try to run Report Builder from a remote client, which is XP SP2. It always shows me the following error: "Application download did not succeed. Check your network connection, or contact your system administrator or network service provider." I don't think it's about permission issues. I am using the administrator group user. Besides the report builder activiation part, I can browser every part on report server website without error.
Do appreciate your help!!!
Details provided by server are
"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://myserver/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 http://myserver/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [11/22/2005 10:13:33 AM] : Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [11/22/2005 10:13:33 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://myserver/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: (500) Internal Server Error.
- 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.
Weird part is I can launch Report Builder successfully from wireless laptop. But when I connected laptop back to wired network, same error came back. I suspect it's due to network settings.
Any one has the similar problem?|||
Having similar kind of issue. Error summary says this.
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ Unable to connect to the remote server
+ An established connection was aborted by the software in your host machine
It was working like Champ couple of days back. There has been some firewall policy changes happened between today and day it worked. I am suspecting something to do with firewall. But I am not sure. somebody please help.
Pleaseeee HELP!
Thanks,
Can not start Report Builder!
I just setup my dev server of SQL 2005 including reporting service on Windows 2003 SP1. Basically all settings are default.
When I activiate Report Builder from local, it works fine. Everything runs smoothly. However, we I try to run Report Builder from a remote client, which is XP SP2. It always shows me the following error: "Application download did not succeed. Check your network connection, or contact your system administrator or network service provider." I don't think it's about permission issues. I am using the administrator group user. Besides the report builder activiation part, I can browser every part on report server website without error.
Do appreciate your help!!!
Details provided by server are
"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://myserver/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 http://myserver/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://myserver/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [11/22/2005 10:13:33 AM] : Activation of http://myserver/ReportServer/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [11/22/2005 10:13:33 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://myserver/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: (500) Internal Server Error.
- 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.
Weird part is I can launch Report Builder successfully from wireless laptop. But when I connected laptop back to wired network, same error came back. I suspect it's due to network settings.
Any one has the similar problem?|||
Having similar kind of issue. Error summary says this.
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ Unable to connect to the remote server
+ An established connection was aborted by the software in your host machine
It was working like Champ couple of days back. There has been some firewall policy changes happened between today and day it worked. I am suspecting something to do with firewall. But I am not sure. somebody please help.
Pleaseeee HELP!
Thanks,
Subscribe to:
Posts (Atom)