Hi Friends,
I am working on .Net tech with SQL Server 2000.
I want to update my technical skills to DW.
I mean, i planning to learn SQL Server Reporting Services and i am new this topic.
Please help me........
thanks
babu
Hello,
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
Any help is appreciated
I started my Reporting Server and if I use the Internet Explorer as a Administrator everything works fine.But if I don't open it as an admin it calls "rsAccess Denied The user [...] does not have the permission...".Problem is that I want to run it in an SAP Program with an HTML Viewer. how I can get those Permissions ?By the way somehow I'm not able to create or change roles in the Microsoft SQL Server Management Studio.
View 5 Replies View RelatedHi
What is the diff between the above 2?
Thanks.
I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.
One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:
Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?
Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.
Thanks to anyone who can help.
-- Mark
I am trying to learn Reporting Services using the title "MS SQL Server 2005 Reporting Services Step by Step" by Stacia Misner and Hitachi Consulting, published in 2006. I am experiencing problems with some of the exercises. I got as far as Chapter 4 when I followed directions to create a SQL statement to define a query string for a dataset. Pg 80:
select * from vProductProfitability
where year = 2003 and
MonthNumberOfYear = 1
The view vProductProfitability does not exist in the tutorial database that came with the book, rs2005sbsDW. The result of this query is the basis for the entire chapter on developing basic reports and I'm being denied a learning opportunity because the view does not exist. In short, I'm stuck.
I have tried to find somewhere at Microsoft to place this question and get some answers so I can continue thru the tutorial. To no avail. Does anyone have any suggestions?
BTW, the solution that came in the CD is also wrong because the query noted above is also in the solution.
This humble grasshopper seeks wisdom.
Respectfully Submitted,
Dave Matthews
Atlanta, GA
aka FlooseMan Dave
I work in a big project and we will begin in using reporting services as the base technique for reports and I will be responsible for this part. but I have a problem I will discuss in the following:
Currently: We use currently devexpress reports and we have 2 languages(Arabic and English). the data in tables saved in two ways (Arabic and English). when the end user change the language of the web site the report data language changed when run it.
Example:
we have table with (ID, NAME_AR, NAME_EN, JobTitle_AR, JobTitle_EN). designed report will display(ID, NAME_EN, JobTitle_EN) . but the end user change the language of the system the report will
dispaly(ID, NAME_AR, JobTitle_AR)
Hint:this done pragmatically
how to do this in reporting services.
If anyone is using the SQL Server Reporting Services already, would you mind posting some comments about your experience with it?
Thanks,
~Brad
Can I export my report to excel 2000 using SQL Server Reporting Services?
Thanks
How do you create a dynamic column in reporting services?
On the report I created I've a field call "Address 2', this field doesn't display data all the time. I wan this field to only display when there is data present.
Thanks
Hey
I have to find out how to use the Reporting services in SQL Server 2000. Can any one expert in this field give some sort of direction. Any kind of resource on SQL server reporting will help.
Thanks
Hi All,
I'm new to SQL Server Reporting Services.
I managed to install Reporting services ok on a laptop running XP Pro. However I have run into all sorts of problems trying to install it on a Laptop running Vista Business with II7.0
When I tried browsing the reports folder (by using the url: localhost/reports), it could not resolve it.
I got a bt further by using the url: 127.0.0.1/reports. However having part displayed the page it gave me the following error: The underlying connection was closed. An unexpected error occurred on a send.
I googled this error and was told to check the Reporting Configuration tool.
When I did this I got the following error
There was an error while refreshing the reporting services configuration manager. The exception details are:
A connection to the computer cannot be established
Details:
Access denied
However I can connect to SQL Server via Management Studio
Regards
Jude
How to use multiple functions in Code Block of Sql Server Reporting Services?
Thanks,
hi,
I am new to sql server reporting services,in my case i am passing parameters from frontend(Asp.net). when i pass more than 30 parameters my report is showing parameters which is not a desired one even though i am making showparameterPrompts property to false.
can any one tell me how to pass more no of parameters to the Report.
I've come across what appears to be a bug in SSRS. If after reading this post you feel otherwise, please reply to this thread...
I am trying to use SSRS to print to a Dymo LabelWriter 400 printer. This is a specialized label printer that prints one label to a page. The label paper I am using 2-1/2 inches by 1-1/2 inches. The Dymo printer driver prints portait layout as being the 2-1/2 inches width and 1-1/2 inches height. I assume that is because the paper rolls through the printer that way and labels normally are printed with more width than height.
Other software programs I use to print to this printer handles it properly (Microsoft Word, Microsoft Office Document Imaging, Dymo Label software). However, SSRS seems to assume that portrait layout must mean paper height > width, as there is no explicity setting in SSRS to for page layout. The result is that no matter how I layout my SSRS report (e.g., switch width-height values, use tb-rl to rotate text), SSRS makes the final decision on whether it is portrait or lanscape. And in this case of the Dymo printer, it always sets it to the opposite of what it should be. Changing the printer settings (whether default or whether in print dialog) does not correct it.
Although assuming that portrait layout must mean paper height > width may seem to make logical sense, not every printer works that way; and other software programs (including Microsoft Office) do not make that assumption. It seems that SSRS and/or RDL spec should allow one to explicitly set portrait/landscape setting and not care about width-height ratio. It should be left to the printer and printer driver to decide.
Have other people come across this issue, either with Dymo printer or in other context? Were they able to find a workaround?
Dear All Techies and Cool People:
I have a relatively simple question about SQL Server Reporting Services.
I want to know if SQL Server "Reporting Services" are included as part of SQL Server in all flavors or editions?
Do you ever have to buy Reporting Services separate or is it ever not included with SQL Server?
Please copy Hal1490@yahoo.com on the response.
Thank you for your help and time.
SQL Server Reporting Services 2005 Service would not Start on windows server 2003. Working great till yesterday and no changes were made to config file.
Here is the error in Event log
Event Type: Error
Event Source: SQL Server Report Service
Event Category: None
Event ID: 0
Date: 12/13/2007
Time: 8:25:59 AM
User: N/A
Computer: XXXXXXXXXXX
Description:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Here is i found in log files
ReportingServicesService!resourceutilities!4!12/13/2007-08:25:59:: i INFO: Running on 0 physical processors, 1 logical processors
ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Exception caught loading and setting code permissions policy level: System.Security.XmlSyntaxException: Invalid syntax on line 158.
at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index)
at System.Security.Util.Parser.ParseContents()
at System.Security.Util.Parser..ctor(Tokenizer t)
at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type)
at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type)
at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy()
ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Error Starting Service: System.Security.XmlSyntaxException: Invalid syntax on line 158.
at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index)
at System.Security.Util.Parser.ParseContents()
at System.Security.Util.Parser..ctor(Tokenizer t)
at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type)
at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type)
at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy()
at Microsoft.ReportingServices.Library.ServiceController.StartService(Boolean firstStart)
Hi there,
I have installed SQL Server 2000 Reporting Services with the default names for the virtual directories , (ReportServer and Reports). Is there any way i can change the name of these directories by running a script or some thing.
Also is there a way to use the Cascaded Style Sheet used in my ASP.NET application for the reports.
Thanks
Hi,
I just came across SQL Server Reporting Services and wondered when it came into the market. Is it something like Crystal Reports and Actuate Reports?? Is Microsoft contending into the Reporting Software market too??
Thanks,
I've installed SQL Server Reporting Services and designed few useful reports on local workstation, now I want to deploy those on the production reporting server.
I have the following questions:
1) We have some demo databases with the similar structure so the the same report would fit all the demos.
Is there any way to change the connecting string for the report programmatically without recreating report each time ? May be there is a way to pass database name to the report (encrypted) ? Is there any way to
2) I'd like to be able to protect those reports from unauthorised users ? Is there any way of doing that ? Is there any way to set up security on the base of folder anf for the whole group of reports ?
Thanks
Mikhail
Why doesn't SQL Server 2005 need IIS for its http readiness while its Reporting Services do? Thanks.
View 2 Replies View RelatedAm I correct in finding that there's no checkbox in SQL Server Reporting Services? What other way do you have to display a bit field other than 0-1 ??
View 1 Replies View RelatedWe had someone leave work and he was responsible for the reports for our company. He used SQL 2000 w/ Reporting Services. The connection to the report server was tied to his userid and password. Since his account was disabled the website will not connect to the reporting database because it was tied to his account. Is there a way to reset the connection creditions? I looked on the server and I can't find the Reporting Services Admin Tool.
Thanks..
Hi all I have a report I set up with SQL servers reporting services, I created it in the Visual Basic. I tried to execute it on the Browers but it keeps giving me an error message. Can anyone tell me what I'm doing wrong please??
An error has occurred during report processing.
Cannot create a connection to data source 'SearchGC'.
Login failed for user 'destevenson'.
Hi Gurus
Currently we are using SQL Server Reporting Services on top of our client data warehouse. Almost all the reports deployed on the report production server are executing Stored Procedures (behind the scene).
Can anyone tell me how can I query Report Server database to get a list of reports and the stored procedures being executed by these reports?
Early Thanks,
Salman Shehbaz.
Database Administrator
Xavor Corp.
92-321-440-0797
We are in the process of doing a side by side installation of the SQLserver 2000 and SQL server 2005 on the same server. To install theReporting services feature of SQL server 2005 requires IIS. We have aseperate web server running IIS that connects to the database server.My question is : can we still install Reporting services on thedatabase server without the IIS?Thank you
View 1 Replies View RelatedThe SQL Server Express can be downloaded with Advanced Services and thereby Reporting Services are included. I wonder if this is the same Reporting Services as in SQL Server 2005 Standard?
I have heard something that it is a stripped version that is included in the Express download.Is it so? And if so, what are the differences?
Hi ALL
Currently we are using SQL Server Reporting Services on top of our client data warehouse. Almost all the reports deployed on the report production server are executing Stored Procedures (behind the scene).
Can anyone tell me how can I query Report Server database to get a list of reports and the stored procedures being executed by these reports?
Early Thanks,
Salman Shehbaz.
Database Administrator
Xavor Corp.
92-321-440-0797
Hi,
I have installed SQL Server Express with Reporting Services in a default instance and let the installer configure reporting services using the standard configuration. The issue is that I am unable to authenticate with the web based Report Manager application when browsing http://localhost/reports.
It prompts me for a user name and password which I supply my windows credentials but it will not accept them. I am running Windows XP SP2 fully patched but it is not on a domain. Is this an issue with Windows Authentication?
I attempted to enable anonymous access to the report manager. I get past the login except report manager gives an error saying the report server is not responding. I have checked the sql reporting services configuration tool and it is telling me that the server is in fact running.
Another forum article told me to check the web.config to ensure indentity impersonate is set to true. I checked the report manager web.config file and this setting is there.
What am I missing?
Hello there.
i would like to install Report Services on visual studio 1.1 version
using sql server 2000. i currently have sql server 2005 and visual
studio 2.0 and there is no problems and so i remember how that
works.
With sql server 2000 i saw a link to a trial version of reporting services that i can download and install but after 120 days it's no good. I think that provides the gui interface to install reporting
services like the 2005 version except less robust. But i'm wondering with the proper service packs of sql server 2000 installed if i can
bypass download.
Can somebody help me how to install reporting services with sql server 2000, pre-req and software i need. I currently have the
developer's edition of sql server 2000 already.
Please contact me at clalbert@flash.net
We are building some new reports using SSRS and one of the reports we are building is trying to use a stored procedure that is a wrapper for an assembly.
When creating the results we are using using SqlContext and SqlDataRecord, and we are creating the column meta data (e.g. List<SqlMetaData>).
We are able to deploy the assembly and stored proc, we see the recordset coming back in the management studio, but we can not see the field's in the SSRS report designer.
Does anyone know how to return the metadata in such a way that my reporting analyst can see the available fields in the IDE?
Thanks in advance.
AG
Hi,
Our team is developing an ASP.NET 1.1 Application that is written using VS2003 but using SQL Server 2005 as database. Can we use a Report Viewer Control that comes with SQL Server 2005 in our ASP.NET 1.1 application? If not, Can some one suggest some alternative way of showing SQL Server 2005 Reports in ASP.NET 1.1 application?
Thanks,
CodeKracker
Hi,
Newbee here.
Can somebody help me just get started is SSRS?
Where do I go to start it up? etc...
Steve