Hi,
Instead of runing a report through the schedule that I have created, I am invoking the SQL Agent Job that has been created for the schedule of the report, using the system stored procedure sp_startjob. Is this a recommended approach? Are there drawbacks for this approach?
Subash
Hi !
I have to invoke a batch file (.bat) when an ad-hoc report is executed. I've currently written a .Net code for invoking (using System.Diagnostics.Process) the batch file. The rdl file calls the method.
When I run the report from Report Designer the batch file is getting executed. But if I deploy it in the Reporting Server and run the report through Web Interface the batch file is not getting executed.
Looks like some security issue. Can someone provide a solution for this?
Thanks.
Hi Guys,
It sounds unbelievable that I can not schedule the DTS packages I created either on my local mechine or SQL server. I have the SA permission for all SQL servers and I can run the DTS packages manually in the EM or run it on DOS command line using dtsrun utility.
The error message I got says: "Microsoft SQL-DMO (ODBC SQL State: 42000)
[Microsoft][ODBC SQL Server][SQL Server] login failed for user '(null)'. Reason: not associated with a trusted Server connection.". I have the SP2 installed in all the SQL Server and my local mechine. All SQLAgents have Domain Admin permission. I just cound not figure out where that user 'null' come from.
I really appreciate that anyone can give me some hints to make the DTS scheduling work. Thanks!
Lunjun
How dow you schedule a file(.dtsx)(I think it is a package) that was created in the SQL Server BI Design Studio to run? I can locate the file I created in SQL Server Management Studio and see it in the right hand pane and even edit it. I can run it in the Design Studio, but cant see how to do that in Management Studio nor how to schedule it.
This is my first attempt at recreating a DTS package using SQL Server tools instead of the Legacy conversion wizard, and I think my brain has overheated. I just cant find it on the Management Screen or the Design. I am also not searching correctly anymore on books online because I cannot find it.
Thanks for pointing me to where I need to go or do.
Tracey
The current way I have my asp.net 2.0 web app running reports is, based on an
interface the user selects the criteria for a report. The .RDL file is created
dynamically based on the user's selections.
I then need to SOAP the dynamically created report to the report server and
then the report runs fine.
BUT it requires Adminstrative rights to do this. Can this be accomplished
without giving the local machine admin rights. I am sorry if this question
has been answered before but i have not been up here in a while.
I've installed Reporting Services 2008R2 STD edition on my local system. I was trying to configure the Report Server, I am able to connect to the Report Server but the ReportDB and ReportTempDB are getting created in Database Engine instead of Report Server, when I connect to Report Server from SSMA this is what I see (Attached) Screen 1.
The screen2 is of Reporting Service Config Manager, When I connect to the report server using the URL what I am seeing is blank last screen shot attached.
After I use the report builder to create a generic report, how do I actually get that report into the report designer so that I can modify it more effectivly?
The issue that I have now is that the file on the report server is not a .rdl file and if I simply save it as one and then bring it into VS to modify it the code file is a html structure rater than a XML file type.
Any suggestions would be appreciated. Thanks
Hi,I'm trying to write a trigger that on the insert/update of a column, Iwant a directory to be created. If insert then create or if updaterename existing dir. Has anyone done thins before? Any pointers wouldbe appreciated.Thanks.
View 1 Replies View RelatedHi,
I am trying to invoke a webservice method when a specific record gets updated in my sql db table. I am planning on writing a trigger on the table, that would invoke the webservice when the event occurs. But I am not sure how to accomplish this. Any ideas/suggestion would be very helpful.
ThanksDabi
Hi There!I have a big application which has two parts. A back-end developed in Deplhi 7 for desktop and a front-end developed in ASP.net C#. The problem I am facing is to integrate the login between both applications. I have a database that has the USER table with the PASSWORD encrypted and I've been already developed a Class Library with all the needs of Cryptography that has been used by the ASP.net application to authenticate users. The thing is, the desktop application has to authenticate the users too with the very same cryptography method, but Dephi cannot use dotNet assemblies (?). The client of the application ask to not use a web service and I'm trying to do this cryptography on the data base.The question is: Is there any way to invoke a dotNet Class Library through a SQL Server 2000 Stored Procedure?Consider that the Dephi developers had researched some ways to use dotNet assembly inside their application with no success. They had tried to develop their own cryptography method based on the algorithm that I had said them, but the encrypted string is different. Whenever the application try to match the strings, it doesn't work.Do you have some idea guys?Thanks in Advance! Ramon Silva
View 1 Replies View RelatedUsing the report builder, I created a simple report based on a report model. This report runs ok in the report builder.
I proceeded to save the report to the report server, but when I want to view this report in Report Manager, I get the following error:
An error has occurred during report processing.
Query execution failed for data set 'dataSet'.
Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xsi' has already been declared. Label names must be unique within a query batch or stored procedure.
I have created couple report through report builder which using AS cube as the data source. Every time when I try to access the New Subscription from the web UI. It complains about "Subscriptions cannot be created because the cedentals used to run the report are not stored, or if a linked report, the link is no longer valid.".
So I went into "Properties" -> "Data Source" and use the custom data source. I've selected "Microsoft SQL Server Analysis Services" and put in the following Data Source=SQLTEST;Initial Catalog="Data Warehouse AS". I've select "Crednetials stored securely in the report server", using my Windows login and password.. and I've got the following error.
"
An error has occurred during report processing.
Query execution failed for data set 'dataSet'.
The SemanticQuery element at line 7, column 351 (namespace http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling) cannot appear under Envelope/Body/Execute/Command. "
Please help!!!
Hi,
I have a couple of reports that I created within the SQL Report Designer, I
would like to give the ability to the end user of C# Winform application to
be able to make modification to this .rdl file using the Report Builder,
however when I try and launch the report that I created within the Report
Designer using the Report builder I get the following error..
Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report
'http://localhost/ReportServer/MyReport)' cannot be opened because no data
source is associated with it. Associate a model data source with this report
and try again.
How can I resolve this situation.
I'm not sure if my approach is the best or if I'm I should be looking at the solution from another approach
Thanks
I am new for MS SQL Reporting Service and I have some questions to consult experts.
We use MS SQL Server 2005 and create the reports in SQL Server Business Intelligence Development Studio, then upload to SQL Server Report Manager (Report web server like http://webhost/Reports). The reports run ok there. My question is how to setup schedule the reports with parameters.
For example, the DVD rental report is with Rental Date, Return Date, and Store Name. It will run weekly for 5 stores, and send the report by excel format and by email with dates range parameter to individual store (5 emails). And another additional request is do not send the report if it has no data.
Please teach me how to implement the schedule setting on Report Manager step by step in detail.
Thanks a lot for any help.
Jeanne
I need to schedule a report to run multiple times with a different value for its one input parameter each time. Can this be done?
View 1 Replies View RelatedGreetings,
I've run into an issue that's been driving me up a wall.
Running SQL Server 2005, two instances production and development, report server on each.
I have a multiple scheduled reports on each instance, and I've over wrote the report server subscription with a SQLAgent schedule.
For whatever reason the reports on the production instance keep having their schedule reset to the subscription when the report was first created.
The logs give me a warning that the schedule is changing or deleted but it's happening when no one is around.
Can anyone shed some light on this for me? or am I missing something really obvious here?
Thanks,
Erik
Is it possible to produce a report which is displayed as a calendar, similar to outlook?
im using rs2000 with no option of an upgrade to 2005
any help would be appreciated!
I have a report that I would like to run in the evening due to high database usage that required a user to fill in selected parameters. Is there anyway to allow a user to fill in the report parameters and have it scheduled to run at 3:00 AM.
Thanks,
Chris
How to schedule a Report to run automatically which has date parameter? Date parameter should take the current date as a value.
View 12 Replies View RelatedI have a couple of Power View reports that I cannot enable the data refresh schedule for. I cannot pinpoint what caused the schedule to stop working but the scheduled data refresh for these reports used to work and now they don't. Every time I try to enable a schedule the page submits and it seems like everything worked (no errors). However, when I go back to the schedule page for the report the Enable checkbox is unchecked. There are other Power View reports that are scheduled and running just fine. The only error I can track down in the SharePoint logs is this:
Failed to remove workbook tracking handle from collection for workbook
I've tried making a copy of the file and re-uploading with a different name but nothing changes. The user would really rather not recreate the report from scratch.
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.
hi,
I am new to SSRS. I am doing some report models for Ad-hoc reports. Im my database i have some users and their roles according to my requirement. User should only see the particular reports if he have privilege. how to customize...
User will access Report Builder to do adhoc report.
For example
I have 5 report Models
rptModel1
rptModel2
rptModel3
rptModel4
rptModel5
In my data base there are 3 users.
user1 have privilege to view rptModel1, rptModel3
user2 have privilege to view rptModel4, rptModel5
user3 have privilege to view rptModel2, rptModel5
When Particular user access the report builder, There i want to show only that particular Report models...
is there any posibilities to do this please Help me.
Thanks in Advance...
-Kannan
kannan1017@gmail.com
Hi,
Is it possible to invoke URL link in database trigger in MS SQL Server 2005
Actually i need to call this URL
http://192.164.0.150/spyapi/cifa.aspx?Brid=393&Partyid=53&Pamount=1000
The parameter values will be taken from database
After connected to Analysis Services and following the path below:
Analysis Service - Databases - Cubes
I create the parameters for a custom report after right click on a specific Cube and select Browse to arrive at a view where i can define dimensions and parameters as well as drag and drop measure to the report rows and columns. The left top File bottom only give me a Save Selection or Save ALL option. However, i'm not sure where it saves it to or if it saves the settings for this custom report at all.
I pull this report monthly and it's a pain to recreate all the parameters. How to save this template for future pulls or maybe even incorporate the pull into excel for monthly refresh instead?
we have an existing .c file and we have to include sql statements in it...
if we include sql statements it has to be stored as .ec file...
so we have to create a .ec file separately and include this into the .c program
but only .c and .h files can be included in .c programs so we converted .ec to .c file using esql command
now after incluing the .c file into the program we dont get any error but we are getting some junk output....
can someone help me in this
Hi,
I have written a SQL CLR procedure, which will be invoking the webservice..I developed the application locally and it works fine, I am able to invoke the webservice using the SQL CLR procedure present in my database. But when i hosted the webservice in App server and executed the SQL CLR procedure in DB Server.
From DB Server, I am not able to invoke the webservice present in the app server. But i am able to browse the webservice from my db server.
I am getting the foolowing error message
A .NET Framework error occurred during execution of user defined routine or aggregate 'usp_LoadView':
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
System.Net.Sockets.SocketException:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
System.Net.WebException:
at StoredProcedures.usp_LoadView(String ConnectionString, String WebserviceUrl, String ColumnMappingsXml, SqlXml AddressXml, SqlXml& ExceptionSqlXml, Int32& ErrorStatus)
I goggled and tried out various options, like increasing €œwebservice timeout€? and increasing €œexecutiontimeout€? for HttpRuntime, but none seems to be working. Please provide me your suggestions to how to fix this..
Hi,
I am using Reporting Services 2000. I would like to know if there is a way to invoke the rdl files from within the code(application) by passing parameter values and export them programmatically to PDF/Excel formats?
Thanks
Hi ,
I am working on Sql server Reporting Services(Sql Server 2005),
i have designed a Report and deployed that report on Report Server, on this report i need to show the user selected values
in page header by using Parameters which i have already created in the Report.
There are 35 to 40 fields in the Front End(Asp.net2.0)
on passing all these values from front end Report is prompting for parameters which is not desired for my case even though i have made ShowParameterPrompts to false.
Thanks in advance
Srinivas Govada
Hi, I have a windows service which is configured to login under the "local System Account". and the windows service is actually creating a SSIS package and running it. however, it was running good with out any problem. but we had to uninstall and again reinstall the windows service and after that it is generating an error "Exception from HRESULT: 0xC020801C" when ever it is invoking the
Instance.AcquireConnections(null);
The connection string that is given for the connection manager is as follows
Data Source=ORIONOFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;User Id=;Password=;Provider=SQLNCLI.1;Auto translate=false"
What is the wrong here-can any body kindly suggest? I have tried with the following too
Data Source=ORIONOFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto translate=false"
Does SSIS need to have a connection string with SSPI always? is there any way to use a sql authenlication for this purpose? like using sql user name and password in connection string? Please suggest me. I need it badly.
Hi,
How can we invoke SSIS Packages from an Windows or ASP.NET Application (using C# ).
Thanks
Jegan
trying to get a new database created then running a script to created the tables, relationships, indexes and insert default data. All this I'm making happen during the installation of my Windows application. I'm installing SQL 2012 Express as a prerequisite of my application and then opening a connection to that installed SQL Server using Windows Authentication.Â
E.g.: Data Source=ComputerNameSQLEXPRESS;Initial Catalog=master;Integrated Security=SSPI; Then I run a query from my code to create the database eg: "CREATE DATABASE [MyDatabaseName]".
From this point I run a script using a Batch file containing "SQLCMD....... Myscriptname.sql". In my script I have my tables being created using "Use [MyDatabaseName]   Go  CREATE TABLE [dbo].[MyTableName] .....". So question is, should I have [dbo]. as part of my Create Table T-SQL commands? Can I remove "[dbo]."? Who would be the owner of the database? If I can remove the [dbo]., should I also remove dbo. from any query string from within my code?
Dear all,i'm facing a problem with my storedprocedure which happened when i ran my web application and reach to the point where my class invoke this storedprocedure,my SP contains a cursor that built his sql according to certain condition, so i put the "SET @cur Cursor For....." inside the if block (definitely i've declared it under AS keyword directly) and this SP is working well inside sql server(I've tested it), BUT when my ASP.net code invoke this SP it gives me the following error : "The Variable @cur does not currently have a cursor allocated to it" repeated as much as there are IF clauses in my SP,Please Help.Regards,
View 1 Replies View RelatedHi,
I have a need to display on screen AND email a pdf report to email addresses specified at run time, executing the report with a parameter specified by the user. I have looked into data driven subscriptions, but it seems this is based on scheduling. Unfortunately for the majority of the project I will only have access to SQL 2005 Standard Edition (Production system is Enterprise), so I cannot investigate thoroughly.
So, is this possible using data driven subscriptions? Scenario is:
1. User enters parameter used for query, as well as email addresses.
2. Report is generated and displayed on screen.
3. Report is emailed to addresses specified by user.
Any tips on how to get this working?
Thanks
Mark Smith