I had been using MS access for couple of years ,recently migrated to Sql Server 2000. i've my Database in Sql server 2000 personal edition.
what i used to do in Access was i upload huge volume of data into the database, i had some queries combining many tables(5). And from MS Excel i used to access the queries. I used to do many analysis. but all the end reports would in MS Excel in the form of pivot table, raw data,graph.
But in Sql server i don't know which option would be ideal for my requirement-Analysis service, or normal query anlyser will do.
also i've been tried to do the same kind of work in Sql server also.like created a VIEW by combining 5 table(huge volume of data,3 table contains above 2 lakhs line items) but when i tried to get the data to Excel,it takes so much time and some time the system gone struck, the following is the way i use to get the data from Sql server in Excel
Ms Excel ->Data ->Import External Data ->New Database Query.
pls advise me. how to improve the performence of the VIEW. or i should use any other service for this like Analysis server,Reporting service.
Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..
Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?
We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
I have some problem about reporting service add-in.
After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.
I try to uninstall and re-install again, it remain not work.
We've got a requirement to build the real time report. user can browse report at any point of time and need to see the latest data(stock market) in the report.
I've few options down...
1. Directly point to OLTP database as source and write stored procedure to show result set.
2. Replicate the database and write the SP's to reports. To avoid pointing directly to OLTP db.
3. To build the datawarehouse with dim & facts to show it in reports. I prefer this as a standard method, but this would have some latency depending on trasaction load which will differ from the requirement.
We are required to gather certain information regarding reporting services.
Which reports were requested, by whom , how long did they run for, what parameters were passed etc etc.
I see that the system tables do provide some of this information, is there a 3rd party tool or something we can use to gather all this type of information for us?
My reporting manager and reporting server were working fine in IIS. But when I booted the system one day, one error message came "Unexpected error" for the IIS. So I removed the IIS and reinstalled he same.
But after that, I tried to give virtual directories to reporting manager and reporting server sites. But it ain't working. Could you please help me?
My IIS 5.1 Reporting service 2005 Express with SQL Server Express ASP.NET 2.0 Express.
Can we pass the Database name/Catalog name for the datasouce that will be used for report, as a report parameter . Is yes can any one help me on how to achieve that .
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.
Hello, I understand that SQL Express Advanced Edition does not support report subscriptions. However, I have two questions:
Is there a way to run a report in a batch mode where the web ui would not show and perhaps the result of the report could be automated to export to .pdf format?
Does anyone know if SQL Express 2008 with Advanced Services will support report subscriptions, or any sort of a batch reporting capability?
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?
i have a list report some values of this are blank or null i want to avoid that spacing if it is null like name:jjj lastname kkk firstname address uuuu
i want it should be name jjj lastname kkk address uuuu
We have SCCM 2012 primary site and Remote SQL 2012 server. Due to hardening and password reset we are facing reporting issue.
while we Open the SRS report in SQL server and try to edit the Report (Report Builder) we are getting following error due to which we are unable to configure Reporting Service point in the SCCM 2012 server. We created the New Reporting server database still we are getting the below error.
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.
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.
Hi all. I have a dts package called package1 that I run once a weekthat does some imports/queries against about the same amount of dataeach run. I am wondering (hoping!) if I can run a query that will showits performance over the past 6 months in terms of how long theexecution for each run took.I think SQL server saves this dts package run history somewhere and ifso how can I do this? Am I totally off base?
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
Hi there, i have been asked to build some reports to extend an app that i wrote. I have written the basics but i am stuck on a few things In SQL (or maybe C#) how can i break down my outstanding costs from orders into 1 - 3 days 3 - 7, 7 - 14, 14 - 21 - 21 - 30, 60, 90+ I have a basic idea, e.g. SELECT * FROM tbl_orders WHERE status = outstanding AND (date_ordered >= txtFromDate AND date_ordered <= txtToDate), i have used the between function, however because my DB is in american date, and my web.config formats it into UK date/time it throws an error
I have 50 rows in my sumary table.I wantted to show them in the front end with pagination,means i wanted to show those 50 rows in 5 different pages with 10 rows per page. How can i do that using sql stored procedure.
I'm finding it difficult to find any posts/articles on reporting in SQL Server 2005. I have a report that requires the name of the person using the machine. I have a table that contains their name with the user name, and I can pull the username out by setting a variable to Environ("username"), however, I either need to create a sub-report or find a way to query the database with the username via the code.
What would be the best way to do this, and if I have to do a sub-report, how do I pass parameters to the query?
Hi, I have all stored procedures for report for this month and previous month. Now my task is to generate report to find out the difference for all coulms those are same for both month reports. EX of final report
There are other colums in those rows too.. So could any one help me out. I want my out put in Excel sheet And its a recuant report ..so i have to use stored procedure.
Hi, I have all stored procedures for report for this month and previous month. Now my task is to generate report to find out the difference for all coulms those are same for both month reports. EX of final report
There are other colums in those rows too.. So could any one help me out. I want my out put in Excel sheet And its a recuant report ..so i have to use stored procedure.
Is SRS provides Ad hoc report creation by end users.
I want to integreat reporting tool in my desktop application in which the end user can change the report fields as well as report layout according to his need at run time as well as they also change the query .
There is one reporting tool named ' shazam Report ' this tool works on delphi and borland c++ only but i want to integrate with c#.net application
Since Codes are not fixed, so an SQL query is difficult. What is the alternative approach? I am thinking to create another table at run-time that reads column values (Code names) from the original table and create a field of that name in the next table.
I also want to know in which edition of SQL Server is reporting included. How SQL Server Reporting compares with Crystal Reports? Secondly, while generating reports from Windows OS on a Dot-Matrix Printer, printing is slow. How can I print at a speed same as in DOS?
I adopted a site that stores items in a database that have a date associated with when those items were developed. However, it wasn't stored as an actual date, but rather a jumble of characters from which you can infer atleast the quarter. Thing is, there is no standard length, but I know I always want the last 5 characters. The format looks something like this: ab_q1_03 The "ab" could be various lengths of whatever characters. "q1_03" means the first quarter of 2003, and this information will always be the last 5 characters of this column. I'd like to get a count of items for each quarter, but I'm not exactly sure how to group that. Any ideas?
I am trying to use sql reporting services and have the user select the criteria for the parameters on an asp.net page and then use a url to open the report. My question is how do I make the parameter options not viewable so they can't change the parameters while viewing the report.
Hi, I'm trying to get hold of a full version of SQL Reporting services, we have a full version of SQL Server 2000 so we're entitled to it, but Microsoft is only giving it away to US and Canadan customers (see: http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.asp). For the inconvenience, I would be happy to pay a small fee to anybody who could sends it to me or offer advice on other ways of getting hold of it. Thanks Lee@LeePaulSmith.Com
