Solved

ssrs report

Posted on 2013-01-31
7
289 Views
Last Modified: 2013-02-07
Is it possible to insert,update and delete statement through SSRS report?
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 56
SSRS Expression syntax with Iif Else 1 58
Change this SQL to get all nodes 3 54
SQL query 45 31
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

738 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