Solved

ssrs report

Posted on 2013-01-31
7
285 Views
Last Modified: 2013-02-07
Is it possible to insert,update and delete statement through SSRS report?
0
Comment
  • 4
  • 2
7 Comments
 
LVL 6

Expert Comment

by:liija
ID: 38840577
Yes it is. It of course requires enough rights for the report user credentials.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 38841012
Is there any sample rdl for this kind of report?

 enough rights for the report user credentials. << I didn't get this
0
 
LVL 6

Expert Comment

by:liija
ID: 38841059
Normally report user only has rights to read data.
Now, if the report has to write to db, more rights are required. Its not ok in every environment.

Report has SQL as data source, so in principle, whatever you are able to do with SQL, is possible to do with report.

Some things that I have done:
- write to own log table, more detailed log that SSRS can give e.g. used parameters
- save the user parameter defaults to db to be reused next time (SSRS doesn't have this capability)
- control the report printing - some data is allowed to be printed only once
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 38841267
Thanks,Is there any sample report like this?
0
 
LVL 6

Expert Comment

by:liija
ID: 38842616
Well, follow these instructions, create your first SSRS report:
http://www.soheib.com/technical-knowledge/create-your-first-ssrs-2008-report/

And replace the SQL in step 16 with this one:

SELECT
   Title,
   FirstName,
   LastName,
   EmailAddress,
   Phone
FROM Contacts
WHERE Title IS NOT NULL
UPDATE Contacts SET FirstName = LastName
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 38842701
0
 
LVL 6

Expert Comment

by:liija
ID: 38842718
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question