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?

View 1 Replies


Similar Messages:

SQL Reporting :: Printing .rdl Reports Using The ReportViewer Control From Webpage To Users Client

Oct 19, 2010

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.

View 2 Replies

Security :: Lock Down Certain Sitemap Menu Items Based On The Users Role ?

Jan 21, 2010

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).

View 5 Replies

SQL Reporting ::to Create Reports Including Pre-formatted ,summary And Detail Reports?

Mar 10, 2011

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?

View 2 Replies

SQL Reporting :: Rendering Large Single Reports Into Multiple Reports?

Oct 7, 2010

I am using ssrs 2008. My Report can generate 5000 Record count , 10000 Records count or more than 10000 records count.

When i am rendering large reoport above 10, 000 record count i am getting timeout Exception error.

how can i avoid that exception..?

i read through some forum can genarate one report into mulitiple reports by dividing the record count.

how best i can work on Rendering Large reports.

View 1 Replies

SQL Reporting :: Error While Rendering Reports (Reporting Services 2005) In .Net 1.1 Web Application On IIS 6.0

Sep 30, 2010

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.

View 1 Replies

SQL Reporting :: Username And Password Of Http://localhost/Reports To Access SQL SERVER 2005 Reporting Service?

Feb 8, 2010

what would be the user name and password of http://localhost/Reports to access SERVER 2005 Reporting service

View 7 Replies

SQL Reporting :: Differences Between Ssrs Reports And Crystal Reports?

Oct 20, 2010

differences between ssrs reports and crystal reports?

View 2 Replies

SQL Server :: Row Is Lock For Update Not For Selection?

Jan 10, 2011

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

View 3 Replies

DataSource Controls :: How To Lock Single Row For Update

Jul 2, 2010

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.

View 1 Replies

SQL Reporting :: Microsoft BI Ad Hoc Reporting For End Users?

Mar 4, 2010

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.

View 1 Replies

Crystal Reports :: Passing Parameters In Crystal Reports Dynamically Selected By Users

Apr 6, 2010

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#.

View 3 Replies

How To Get The List Of Users And Also To Update/Delete Users

Aug 11, 2010

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.

View 1 Replies

SQL Reporting :: Generate Reports In Ie7?

Jul 19, 2010

I was very happy that i can generate reports in ie7

after updating to ie 8 things has gone wrong :(

I am generating 9 different reports

user can select one report and can generate the perticular one.

But in ie 8 i can generate only first report

even if i select the second record it generates only the first

It seem some problem.

i can gethe second report if and only if i refresh report page

what can i do?

(note in adavance:I dont have a doc type in my page )

View 4 Replies

SQL Reporting :: Display 2 Reports In 1 Pdf?

Nov 16, 2010

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);

[code]...

View 3 Replies

SQL Reporting :: RDLC Reports

Jul 26, 2010

If I have an XML file, can I use it as a datasource for a RDLC file?

View 4 Replies

How To Custom Reporting For End Users

Apr 8, 2010

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.

View 7 Replies

SQL Reporting :: Passing Parameters Through Sub Reports?

Aug 24, 2010

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.

View 2 Replies

Create Some Excel Reports That Users Can Download?

Mar 14, 2011

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.

View 2 Replies

SQL Reporting :: Make SSRS Reports Available Through ReportViewer

Dec 29, 2010

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?

View 2 Replies

SQL Reporting :: How To Show Reports Without Viewer Control

Mar 10, 2010

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.

View 1 Replies

SQL Reporting :: Public Access To SSRS Reports?

Sep 21, 2010

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.

View 3 Replies

SQL Reporting :: How To Create Header File For Reports

Jan 6, 2010

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.

View 1 Replies

SQL Reporting :: Move RDLC Reports To SSRS?

Mar 7, 2011

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.

View 3 Replies

SQL Reporting :: Displaying Dynamic Added Value In Reports?

Aug 16, 2010

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.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved