Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ssrs report

Posted on 2013-01-31
7
Medium Priority
?
296 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 2000 total points
ID: 38842701
0
 
LVL 6

Expert Comment

by:liija
ID: 38842718
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

618 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