Reporting :: Lock Users Out Of Reports During SQL Update?
Jun 10, 2010
I have a series of reports that run off a one table. The problem is, I have to read in data from a flat file from a large data source in order to update my SQL table. Right now, I read the tables in then the last thing I do is truncate the table I report from, fill the table with the necessary data and run a few small stored procedures to update some of the fields. Then the users are ready to run their reports.
Is there a better way to do this or a way I can lock them out while the table is filling and updating?
I have developed a set of ssrs .rdl reports and am trying to display them from the reportviewer control embeded in my asp web page. The problem is that when I select the print icon on the reportviewer control I am prompted to install ms sql server. What is the best way to print .rdl reports from the web page's embeded reportviewer control to the client's local network printer.
My web app has 3roles, I need to lock down certain sitemap menu items based on the users role and what I'm using isn't working.
my roles are Supervisor, manager, and User.
[Code]....
I only want those roles to see those menu options, I do not want someone with a user role to see those options at all. Currently if I log into my site with a user role, I'm seeing everything on the menu (via the sitemap).
Iam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.
How to row lock in SQL Server 2005. I execute a sql for row locking and that is
SELECT * FROM authors WITH (HOLDLOCK, ROWLOCK) WHERE au_id = '274-80-9391'
it work fine but in this case row is lock for update not for selection. I just want to know how to lock a row as a result another user can not see that row when issue a SQL in SQL Server. please guide me. thanks
i develop a c# windows application. My database is sql server 2008 exp. i want lock single row for user select it for update. for example;
userA - Connection a (connection id 52);
user select a single row (select * from t1 with(rowlock?, updlock?,or what) where id=1) and bind data to form fields (texbox, checkbox,combobox etc.). (there is no problem)
userB - Connection b (connection id 54);
userB can select all other rows from t1 (where id=2 or 3 or anything) but not id=1. when userB select * from t1 where id=1 system generate an exception with (you cannot select this row because it is updated. Updated users connection id is 52.)
when userA (connectionid52) close form or commit changes then userB can select id=1.
i am read few documents (transacions, rowlock,updlock, concurrency violation optimistic,pessimistic) but i couldn't understand.
Is there any component of the Microsoft Business Intelligence Stack that could be used by an end-user (i.e., not a coder, a business analyst) where they can drag and drop tables/columns onto a canvas and create reports themselves? I've been looking and can't seem to see anything I would want to give to an end-user.
I am trying to find something that is like the Cognos Report Studio/Query Studio products. They are pretty intuitive and users are able to create their own reports without the of IT. They can drill through folders, pick columns, drag them onto a canvas, sort the data, filter the data, group the data, add titles, all without having to know SQL (joins are made automatically).
I've looked at PowerPivot but that seems mostly targetted at OLAP users. What I am looking for is the ability to create list style reports with charts etc.
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
I have used Login Control + Change Password + Create User Wizard in my project. Everything is working fine. I want to know that how to get the List of Users and also to Update/Delete users.
I can display reports as pdf's through the code no problem but my aim is to be able to display multiple reportviewer reports in 1 pdf but even when I fill the memorystream with 2 lot's of reports, it still only displays one as a pdf.
A snippet of my code is below:
byte[] bytes = rptViewer.LocalReport.Render( "PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);
Is there a third party tool or something similar that will allow users to create reports on their own without any programming? One code base but custom reports for each user in the system that they create.
I am trying to use a parameter field where there is a subreport in my main report but i keep getting the error "subreport cannot be shown" when running the report.
p.s - I have just set the parameters the same in the subreport as the main report.
My goal is to create some Excel reports that users can download from my asp.net site. The data for the reports will come from an SQL database. I am using Visual Studio 2010 and the reports will be for Excel 2007.
I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required? 2) Configure SSRS to for external connections? 3) Firewall?
I have SSRS reports deployed on report server. Now I want to use these reports in a web application. Is there is any way to show these reports without using the reports viewer control of asp.net.
I'm designing some reports to summarize recently compiled research findings. These reports are going to be posted on an ASP.NET page (via the report control) on the web site. I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup. I need alternative solutions to the problem of making a report viewable by everyone who visits a site. I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.
I want to create header for reports(.rdls).Now i am designing reports ,all reports have same header ...so i want to create fixed header file for all of my reports.
I am using VWD 2008 with VB.Net code-behind. I have multiple parameterized RDLC reports that use tableadapters in a .xsd dataset that I use a reportviewer to view / export the PDF reports.
Lately, we have noticed that the reportviewer is causing many errors on our webserver and sometimes causing the webserver to crash. It has been recommended to me to move the RDLC reports to SSRS, which we also have up and running on another server.
My question is how do I do this? Do I have to convert them to RDL files? What about the fields on the .aspx pages that supply the parameters? Also, what do I do with the tableadapters?
We want to not use the reportviewer but still have the capability to retrieve the RDLC reports in PDF format.
I my application i have generated dynamic rows that contains some textbox values, i need to take those values and display in reports. I am storing that dynamically added values in another table.