Hi all ,
When i Run the report in reporting services, it locks the tables.
so is there any option to Unlock the tables. I m using just select query to run the report but when i run the report it locks the tables.
I used with(nolock) option in select query but it didnt work...still showing me lock on the tables.
Pls help...its urgent
Thanking You,
Rupali Rane.
rupalirane07
Last Activity: Sep 11 '07, 06:57 AM
Joined: Aug 21 '07
Location:
-
Locks the tables while running Report..VeryUrgent
-
Locks the tables while running Report..VeryUrgent
Hi all experts,
When i Run the report in reporting services, it locks the tables.
so is there any option to Unlock the tables. I m using just select query to run the report but when i run the report it locks the tables.
I used with(nolock) option in query but it didnt work.
Pls help...its urgent
Thanking You,
Rupali Rane. -
if that is the problem then do this:
if u r using dropdownlist then u must be using Template Column.
then right clik on Datagrid -Edit Template -go to column[n] n means watever column comes in my case it is column[4] then clik on itemtemplate dropdownlist-properties-css field is there then give the name DataGridFixedHe ader and then end Template editing. and run and check.
Try this it wont comes over the heade... -
SELECT * FROM student
--SELECT count(Studentna me),studentname ,
--subjects FROM Student GROUP BY Subjects,studen tname
SELECT studentname,
CASE WHEN subjects='Phy' THEN marks END AS Physics,
CASE WHEN subjects='Chem' THEN marks END AS Chemistry,
CASE WHEN subjects='Maths ' THEN marks END AS Maths
FROM Student
SELECT DISTINCT studentname from...Leave a comment:
-
i dont want to insert i want to get that in select query result...Leave a comment:
-
<style type="text/css">.DataGridF ixedHeader { BACKGROUND: none transparent scroll repeat 0% 0%; POSITION: relative; ; TOP: expression(this .offsetParent.s crollTop) }
</style>
Add the Above Line in HTML page of ur form after the following line:
<meta content="http://schemas.microso ft.com/intellisense/ie5" name="vs_target Schema">
after this come to...Leave a comment:
-
select case when level is 1 then Name end as Root,
case when level is 2 then Name end as Trunk,
case when level is 3 then Name end as Branch,
case when level is 4 then Name end as Leaf,
case when level is 5 then Name end as Stem...Leave a comment:
-
Urgent Query
I have on table Student
StudentName Subjects Marks
Ram Phys 80
Ram Chem 70
Ram Maths 50
Ramesh Phys 60
Ramesh Chem 78
Ramesh Maths 75
i want to disply result like this:
StudentName Physics Chemistry Maths
Ram 80 70 50
Ramesh... -
Sorting Problem in Nested Datagrid
Both grids displays fine. But the problem is only parent datagrid sorting works fine but when i clik on child datagrid for sorting it gives me error:
NullReferenceEx ception error
Any help........pls urgent
=============== =============== =============== ============
<%@ Page Language="vb" AutoEventWireup ="false" Codebehind="Web Form3.aspx.vb" Inherits="TestD atagrids.WebFor m3"%>...
No activity results to display
Leave a comment: