Query/Reporting Tool For SQL Server Tables
Oct 6, 2005
Just a general question about any recommendations for a third party tool that would allow setting up a data-dictionary against SQL Server tables and a user could go in and build their own queries, reports. Perhaps they could save their query/report definitions for reuse. Other nice to haves - ability to output to PDF and export to XLS. Would prefer web interface, but can consider desktop as well. Any immediate recommendations?
Thanks.
View 6 Replies
ADVERTISEMENT
Nov 20, 2005
We've just rolled out Reporting services at our organisation, and the users love it. However, it's giving me a headache because, as the only developer in the company and as I have VS.NET, I'm the only one who can author the reports.
Does anyone know of a third party provider that has written a report writing tool with a straight forward UI ( a bit like the access report writer for example) that I can deploy to some users and let them run riot? It's the kind of thing that I expect someone will have done as a pet project, if anyone knows of a freeware version that would be even better.
I'd be very grateful for any pointers.
Thanks
View 1 Replies
View Related
Mar 13, 2007
Hi, I have a field in database that keep the image location. How to display the image in the report ?
Any idea.
Thanks.
View 2 Replies
View Related
Aug 16, 2006
Hello,
I have SQL Server Express working however I don't see any tools to create a database and tables.
I am trying to create a database to store stock quotes that I will input from a c# program.
What tool should I use to design the database?
Thank you!
Toben
View 4 Replies
View Related
Nov 6, 2007
I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)
I don't want to loose any data. Please help me resolving this error.
FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.
Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.
View 4 Replies
View Related
Jan 15, 2007
HI There
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?
This is for reporting services 2000 and 2005.
Thanx
View 1 Replies
View Related
Oct 31, 2005
Hi !!We are developing an application where we need a Query tool which allows customer to do Ad-Hoc or random query.. something similar to lets say http://salebyowner.com/advancedSearch.phpWe have few more options than this on which customer can do search. I don't think dynamic query in C# code or something like that is going to help me. Am I right? Do we have to use any type of query tool or something for doing this?
View 6 Replies
View Related
Feb 18, 2008
Hi,I was wondering if someone could help advise me.Basically i have a client who wants to upgrade from a desktop msaccess solution to a web based system using MS SQL Server 2005.Basically their main concern is in losing the ability to write ad-hocqueries using the MS Access query manager. I can obviously writestatic reports etc but whats the best way to give them someflexibility ??Can anyone advise me if there is any product that can do this for SQLServer 2005 (which im sure there is) but will work in a webenvironment.Or does anyone have any helpful ideas ???all help / advice greatly appreciatedCG
View 1 Replies
View Related
Dec 3, 2007
Hi guys,
I am using DLinq with SQL Server Express 2005 and I need to install some kind of user interface which shows me a trace of the SQL statements sent. I would like to see them in real time (I won't like to inspect a log after :-).
I remember that there was something similar in SQL Server 2000 full edition, but I requiere the same functionality in the Express version now.
Could you tell me if there is some tool to do that?
Thanks in advance,
Erich.
View 1 Replies
View Related
Aug 12, 2015
I would like to be able to view the complete SQL command that is sent from a Microsoft Access query which has linked SQL Server tables through ODBC, and the query also has some VBA functions manipulating and filtering data.I tried using the SQL Profiler to view the sql command send to SQL Server but all I see is the simple query format and some of the fields. I don't see the fields that have a VBA function such as trim(fieldname) etc in the column. And If I use a VBA fucntion in the Criteria then nothing shows up in SQL Profiled under the TextData column.How can I see the complete SQL command sent to SQL Server?
View 2 Replies
View Related
Oct 7, 2002
Does anyone know of a T-SQL Reporting Tool that can be attached to either SQL 7 and/or 2000 databases.
I am looking for something similar to the Oracle 'Discoverer' tool.
The requirements are that users be able to create there own reports using a GUI with the minimum of prior knowledge of T-SQL.
Thanks in advance for any replies.
David Goodman.
View 3 Replies
View Related
Feb 17, 2004
I put a similar post on experts-exchange....
What I am looking to do is create a reporting framework that uses SQL Server and outputs as XML (only because that could be consumed by various clients).
I also want to create title, subtotals, etc., and even page breaks of I can.
I want to do this all in T-SQL so new reports can be added by DBA's rather than have the developer re-code, re-compile, re-distribute, etc.
I think on the DB side it would be as easy as creating a table that is a 'catalog' of available reports with their names, etc., and a set of stored procs that would run the reports.
Has anyone ever done anything like this, or in some better way?
Thanks.
View 2 Replies
View Related
Apr 3, 2001
I'm looking for a tool that can read the SQL Agent tables and generate a chart or graph of when jobs are scheduled. This could be used to determine when a job can be scheduled without interfering with other jobs, or to determine
where a maintenance window might exists.
The chart could be for a particular day, or week or month. It could be for a single database or all databases on a server. The tool could also read job history and display a graph of execution time (with success and failure displayed in different colors).
I don't know of anything like this in existence. I've looked at the stored procs supplied with SQL Server that help generate the data for the Enterprise Manager's GUI. I see thinks like the job schedule frequency information hardcoded in the stored procedure, instead of table driven. That's scary!
SQL Probe software is cool, but it doesn't do the reporting I'm looking for.
View 1 Replies
View Related
Jul 20, 2005
Was wondering if anyone knew of a tool that you can point to a view inthe database and it graphically (or even in text) determines thedependencies. At the moment I am manually going through a swag ofviews and putting them in visio org chart but there must be a betterway !
View 1 Replies
View Related
Aug 29, 2007
I installed 2005 advance... install said all OK. I go to Reporting Configuration tool, try to set Report Server Virtual Directory,
set new to default... says number of errors 0 but the crashes with the "... and has to close" No details as to what the error is
and when I retry I cannot click on Report Manager Virtual Directory. Any Ideas?
View 1 Replies
View Related
Apr 20, 2006
Hi,
I need software that will write a report on the following items that I can have prepared to show our auditors. Any suggestions ??? OUr databases are SQL*Server 2000, SP 3a / SP4
1) database consistency checking
2) re-indexing
3) shrinking
4) allocation of growth boundaries
5) backup routines
6) disk space
7) table space
8) processing speed
Thanks so much,
Nancy
View 3 Replies
View Related
Nov 6, 2006
dun need sophisticated interactive reports, but just simple basic rigid reporting will do :D
looking for a simple tool for my end users. Crystal Reports a bit overkill.....
View 10 Replies
View Related
Jul 11, 2007
Hello all
I am trying to configure reporting services using the Configuration Tool. I get all checks green except for Encryption Keys (Blue), Initialization (Grey), and Email Settings and Execution Account (both Yellow). I am not too worried about the yellow and blue ones because I have read that other people have the same, but I was wondering how to make Initialization available to configure. I am running SQL Server 2005 - Standard Edition.
Thanks for the help,
S.R.
View 39 Replies
View Related
Jul 12, 2007
we just got the new server windows 2003 server, sql server 2005
- i use remote desktop connect to the server.
- i made the report services for testing,
the problem is I can't not published report.
i check the report services configuration tool.
(the page is gray. also warning come "no report server were found on
the specified machine" detail invalid namespace)
what shoul i do?
View 2 Replies
View Related
Oct 19, 2007
Is there something called SQL Service Reporting tool - "the Designer" is this product different then the Reporting Services that comes with SQL Microsoft Server standard edition?
View 1 Replies
View Related
Aug 3, 2007
I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:
SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.
My only options are to Debug or Close.
I'm not sure why I am getting this error. Can anyone help?
Thanks,
Amanda
View 9 Replies
View Related
Aug 10, 2015
I have a project with SQL sever reports in it. During a test upon returning to the VS 2013 Professional interface, the tool box area still had the previous information displayed and never returned to what should be there for the report design tools.I restarted VS, and the toolbox no longer looked like it did before. Specifically, the datatable tool among others was missing. I was unable to "refresh" the datatable after making changes to it.
I opened other Reports in design mode, and the tools did not show up for those either.The Report Items in the toolbox does contain things like Pointer, Text Box, Line and so forth.
View 4 Replies
View Related
Nov 6, 2015
SQL Server 2008 R2. SQL Server Management Studio 2016 CTP2. I am looking for a tool where I could create and save a nice graphical layout of some tables in a database and their relation to each other (how they join or connect). I get something like this in the Query Editor, where it shows the fields and joins of tables as I select them. However, I cannot save this representation to show say in a PowerPoint or Word document (Visio, etc.).
Is there a tool that would enable me to create a nice document showing my tables and their relationships, which would also allow me to annotate each table with notes about the fields, etc.?
I searched and found a reference to "Visual Database Tools" which is supposed to be part of Management Studio 2016. However, I cannot find such a set of tools listed anywhere in my menus.
[URL]
View 3 Replies
View Related
May 27, 2004
I'm looking for suggestions on what Query tool to use on SQL DB's for a group
of people who are used to creating ACCESS QUERIES. I'm having trouble running SQL as the backend and ACCESS as the query tool to run ANALYSIS.
TIMEOUT issues and such. So, I thought we might as well use the SQL tools.
Any suggestions...
View 5 Replies
View Related
Jul 21, 2007
I had SQL200 query analyzer loadded on a machine but it crashed.
Culd find CD. We decided to load SQl Server Manager sudio express from a sql 2005 CD. THe problem is that wen running queries with it, it puts some strange characters in the output. They arenon-printable characters so you don't see them
when you edit them in notepad. I have an editor that allows you to edit different
modes. I looked at the file in hex mode and found the characters there at the beginning of the first record. I just want the results in the result pane of the query to save as a regular ASCII text file comma delimited. THis same script was used successfully
in SQL2000 query Analyzer. Can anyone help?
View 2 Replies
View Related
Aug 17, 2005
AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery*4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively.
The key features of PowerQuery 4.1 are:
One unified user interface works with*all your databases. No need to switch from one database to another.
Easy to build and execute query.
Use native database connectivity to improve database query performance.
Graphical*table edit and commit change without writing any INSERT, UPDATE or DELETE statement.
Automatically monitor Oracle Server side activities, such as executed SQL statements, server memory usage, disk usage and many other performance measurements
To obtain free PowerQuery 4.1, go to http://ww.agileinfollc.com. After download and install the software, send the registration code (32 bytes hash string generated based on your installation time) to support@agileinfollc.com, we will send back free license code to activate the software permanently.
View 1 Replies
View Related
Feb 2, 2005
Does anyone know of a vendor who provides a packaged application that allows a user to pass T-SQL commands from a browser, to our IIS web server, to our SQL Server database?
Thanks!!!
View 1 Replies
View Related
Dec 24, 2002
Hello,
I just wanted how we can find the system performance without using tool like performance monitor or profiler.
I just need the query like equalent to peformance monitor for see the systmem status of CPU ,IO ,Memory and etc..
Thanks,
Ravi
View 2 Replies
View Related
Nov 29, 2005
Another marketing campaign :eek:
View 1 Replies
View Related
Dec 30, 2004
Does that make sense? I have 2 tables, one is an older version, one newer. The newer version has some additional fields, indexes, etc. I'd love to have a tool to run against them that would generate an ALTER TABLE script to modify the old table so that it matches the new table.
Is there anything like that out there?
View 4 Replies
View Related
Mar 2, 2006
is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??
View 1 Replies
View Related
Oct 31, 2000
Can anybody tell me how to use the query analyzer to
connect to 2 different servers in one query?
If I access a database on another server like that
[servername].[dbname].[dbo].[tablename] I recieve
an error that says: Server servername is not configured
for DATA ACCESS.
Thanks in advance
Gert
View 2 Replies
View Related
Jan 3, 2008
Hello,
This is chirag patel.
we are going to SSRS with our asp.net application to generate reports and charts.
i having query about license of SSRC.
Is it completely free with SQL Server ?
i mean if my web application will have SQL server 2005 as Database on production server , then do we need to purchase anything else to use SSRC ??
can anyone please let me know brief detail about license of SSRC if we want to use SSRC with web based application ??
Thanks.
View 1 Replies
View Related
