XML Output For A Reporting Tool
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
ADVERTISEMENT
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 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
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
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
View Related
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
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
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 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, 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
Dec 6, 2004
I manually build my url for my reports. In the url I build, I can specify the output format I would like it to automatically use when the report opens. However, it always first opens the dialog box to either Save, Open, or Cancel. Is there anyway to bypass this and just open it in the format I have coded in the url? Thanks.
View 2 Replies
View Related
Sep 4, 2007
I'm scheduling a T-SQL job with SQL Agent. The job uses PRINT to write out various progress and status messages as it runs. I created an Operator, and set a Notification when the job fails -- will that send me the entire output of the job, or just the error message?
View 1 Replies
View Related
Mar 22, 2008
Is it possible to use a stored procedure that outputs xml to render a report? If so, any tips on how to go about it will be very much appreciated.
Thanks,
Nick.
View 1 Replies
View Related
Aug 6, 2006
Does anyone know how i can go about merging preexisting pdf files and SQL server reporting services output. Can this be done in reporting services? For example, I have 5 pages from a pdf files which is created from another 3rd party software provider. I then i have output from sql reporting services. How can i merge these two outputs and deliver it over .Net/ ASP framework?
thanks
View 4 Replies
View Related
Nov 14, 2007
I just created my first report using sql server reporting services
Now I am having some data discrepancies, trying to figureout how I can troubleshoot this issue.
The report has been created against the stored proc, when I run the stored proc within the sqlserver, I get 3 rows, but when I run the report I get only 1 row. I am kind of confused, how can I troubleshoot this issue, Thanks.
View 1 Replies
View Related
Sep 21, 2015
I am working on SSRS 2008 R2 in BIDS. The report's data source is from Stored Procedure which is running good in SQL Server 2008 R2.
The stored procedure has an output parameter, which I don't know how to set in BIDS, so when I try to add the data source to the report, a mistake is shown up.
So my problem is:
1. How to set the output parameter correctly, so the data source(stored procedure) can be run as good as it were in SQL Server 2008 R2.
2. How to get the output parameter value in BIDS which will be used to set the title of table dynamically.
View 6 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
Apr 22, 2015
Is it possible to create a Data Driven Subscription report as a text file output to a shared folder?
View 6 Replies
View Related
Jul 23, 2005
Hi all.I'm looking for a tool which should act like some kind of middleware/logical layer bewtween the SQL server and the webbased user interface.- It should be possible to easily create simple web forms (only datainput and output) without programming effort by "clicking" the fieldsand their order on the web mask within an admnistrative interface.- It should also be bossible to add "new fields" to the database,including field type, permissions, value lists etc. (excluding anybusiness logic) without programming effort by administration.I know, that most workflow tools or "Trouble Ticket Tools", based ondatabases have this feature to easily configure new masks and add newfields to the database, but i need it as an tool-unspecific layer forthe MS SQL Server.Thank you very much for your feedback, any ideas are welcome!Best regards, Heiko.
View 1 Replies
View Related
Nov 23, 2015
We are about to implement SSRS reports (SQL Server 2012), and have found one issue we don't like. The report looks great when we open it in pdf format. However, when we open it in Excel format, we want it to be the raw data, not look like the pdf report. I tried the simpl headers, and that removed the page header/footer. However, the report format was still in play.In other words, we would like the report when opened in Excel, to look just like it does when we open it as a CSV.I have tried to modify the config file a couple of times. Here is my latest attempt:
Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">CSV (comma delimited)</Name>
</OverrideNames>
</Extension>
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">Excel (csv)</Name>
</OverrideNames>
</Extension>
Essentially I have set Visible = "false" for the Excel type, and tried to duplicate the CSV, changing the name to make it look to the user like it is "Excel". This fails. I checked the event viewer, and I see two entries.. The RSReportServer.config file has been modified. (Information)The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead.I literally took the file, opened it in Notepad, pasted in my changes, from another notepad window, and tried to run the report. I did not see EITHER of the two names I expected, using the OverrideNames tag. As I said earlier, I was able to affect the outcome, by setting SimpleHeaders to true (or however it is identified). That did work in that the page header and footer was removed.
View 6 Replies
View Related
Aug 19, 2015
I have created SSRS report which has many overlapping objects, the output in PDF format seems to good but in word format it is not giving the required output.
View 5 Replies
View Related
May 23, 2015
I have the SQL code for one of the select list columns as shown below in the SSRS Data set query level.
Example : Select IsNUll(max(ET.[# Utilizations by Utilization Method]),0) as [Employee Period Total]
SQL Result Set Output :
0
0
0
The above code when run in SQL displays correctly with zeroes if NULL values are available from the Source tables.Now at the SSRS Report level design I have grouped with more than one values.Even at the expression I have given =Fields!Employee_YTD_Total.Value but report output displays blank In order to evaluate 0 from the SQL result set I even tried equating the values to 0 like = Iif(Fields!Employee_YTD_Total.Value = 0 ,0,Fields!Employee_YTD_Total.Value) but still the report outputs is blank.
Issue/Query : Why it displays blank and I should have this as 0 in the report output to eliminate blank as this would be not appropriate to the end users to validate. What has to be changed either at the SSRS level or at the SQL level.
View 3 Replies
View Related
Dec 25, 2006
While using Aggregate Transformation to group one column,the rows of output sometimes larger than the rows returned by a T-SQL statement via SSMS.
For example,the output of the Aggregate Transformation may be 960216 ,but the
'Select Count(Orderid) From ... Group By ***' T-SQL Statement returns 96018*.
I'm sure the Group By of the Aggregate Transformation is right!
But ,when I set the "keyscale" property of the transformation,the results match!
In my opinion,the "keyscale" property will jsut affects the performance of the transformaiton,but not the result of the transformation.
Thanks for your advice.
View 2 Replies
View Related
Sep 21, 2015
Inside some TSQL programmable object (a SP/or a query in Management Studio)I have a parameter containing the name of a StoreProcedure+The required Argument for these SP. (for example it's between the brackets [])
EX1 : @SPToCall : [sp_ChooseTypeOfResult 'Water type']
EX2 : @SPToCall : [sp_ChooseTypeOfXMLResult 'TABLE type', 'NODE XML']
EX3 : @SPToCall : [sp_GetSomeResult]
I can't change thoses SP, (and i don't have a nice output param to cach, as i would need to change the SP Definition)All these SP 'return' a 'select' of 1 record the same datatype ie: NVARCHAR. Unfortunately there is no output param (it would have been so easy otherwise. So I am working on something like this but I 'can't find anything working
DECLARE @myFinalVarFilledWithCachedOutput
NVARCHAR(MAX);
DECLARE @SPToCall NVARCHAR(MAX) = N'sp_ChooseTypeOfXMLResult
''TABLE type'', ''NODE XML'';'
DECLARE @paramsDefintion = N'@CatchedOutput NVARCHAR(MAX) OUTPUT'
[code]...
View 3 Replies
View Related
Aug 30, 2006
Hi
I have Lookup task to determine if source data should be updated to or insert to the customer table. After Lookup task, the Error Output pipeline will redirect to insert new data to the table and the Output pipeline will update customer table. But these two tasks will be processing at the same time which causes stall on the process. Never end.....
The job is similiart to what Slow Changing Dimention does but it won't update the table at the same time.
What can I do to avoid such situation?
Thanks in advance,
JD
View 4 Replies
View Related
Dec 8, 2006
I am working on an OLAP modeled database.
I have a Lookup Transformation that matches the natural key of a dimension member and returns the dimension key for that member (surrogate key pipeline stuff).
I am using an OLE DB Command as the Error flow of the Lookup Transformation to insert an "Inferred Member" (new row) into a dimension table if the Lookup fails.
The OLE DB Command calls a stored procedure (dbo.InsertNewDimensionMember) that inserts the new member and returns the key of the new member (using scope_identity) as an output.
What is the syntax in the SQL Command line of the OLE DB Command Transformation to set the output of the stored procedure as an Output Column?
I know that I can 1) add a second Lookup with "Enable memory restriction" on (no caching) in the Success data flow after the OLE DB Command, 2) find the newly inserted member, and 3) Union both Lookup results together, but this is a large dimension table (several million rows) and searching for the newly inserted dimension member seems excessive, especially since I have the ID I want returned as output from the stored procedure that inserted it.
Thanks in advance for any assistance you can provide.
View 9 Replies
View Related
