Solved

ssrs report

Posted on 2013-01-31
7
282 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
tempdb log contention 16 40
SSRS troubles 4 52
performance query 4 24
Problem when I run a simple storeproc - help 4 17
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

831 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