Hi Meghna,

Just go the properties of textbox/reportitems and then follow these steps:

Font--> FontWeight-->Select combobox

now Write expression like:

=IIF(Fields!FieldName.Value= AnyValue, "Bold", Normal")

Hope this is what u are trying. 🙂

Hi Ngarg,

Then it would be better if you have identity column in your Table so that we can use that column directly to calculated SUM.

There may be other ways if...

Yeah, It should work...

Try this

Select * From (

Select order_ID,Basequantity,Expect_date,statusflag,

(Select SUM(Basequantity) From purchase_orders

...

Hi Sharma,

If you are deleteing all the records then TRUNCATE is the Best option.

But If you want to change the IDENTITY value without deleting records then it can be done...

Now you can apply WHERE condition on CalculatedQty Column like:

Select * From (

Select order_ID,Basequantity,Expect_date,

(Select SUM(Basequantity) From purchase_orders

Where Expect_date>=A.Expect_date) CalculatedQty

From purchase_orders A

Group By order_ID,Basequantity,Expect_date

) AS Temp

WHERE CalculatedQty<=40

Order By Expect_date...

Hi,

If your Expect_date is distinct in every row that this query can be useful:

Select order_ID,Basequantity,Expect_date,

(Select SUM(Basequantity) From purchase_orders

Where Expect_date>=A.Expect_date) CalculatedQty

From purchase_orders A

Group By order_ID,Basequantity,Expect_date

Order By Expect_date Desc

Hi,

You can use Matrix control instead of Table.

Just drag and drop required field in Column Grouping

Dear ghindson,

Read the Last para of the problem mentioned earlier.

There is clearly mentioned that Single statement is updating multiple rows and lock is also there.

It may be the case...

Alternatively you can use subqueries like:

SELECT

(Select AgentName From @Agent Where AgentID=A.AgentID) AgentName,

Convert(varchar(20),A.Date,106),

(Select ProjectName From @Project Where ProjectID=A.PrimaryProjectID) PrimaryProject,

(Select ProjectName From @Project Where ProjectID=A.SecondaryProjectID) SecondaryProject

FROM @AgentSession A

DECLARE @Agent TABLE (AgentID int,AgentName varchar(100))

INSERT INTO @Agent

SELECT 1,'James' UNION SELECT 2,'Mary' UNION SELECT 3,'Ronny'

DECLARE @Project TABLE(ProjectID int,ProjectName varchar(100))

INSERT INTO @Project

SELECT 1,'Genuine' UNION SELECT 2,'Real' UNION SELECT...

Hi Mike,

How can you compiled a Stored Procedure if it has had an error?

As per my knowledge you cannot create a Stored Procedure if it has an error (Except Dynamic...

I mean first commit the transaction(1) before starting the other transaction(2).

Hi,

These transaction will create DeadLock.

To avoid Deadlock, You can do serialization.

Alternatively u can do:

DECLARE @t VARCHAR(15)

SET @t = '10.0.123.77'

SELECT Left(@t,Len(@t)-CHARINDEX('.',Reverse(@t)))

DECLARE @t VARCHAR(15)

SET @t = '10.0.123.77'

SELECT PARSENAME(@t,4)+'.'+PARSENAME(@t,3)+'.'+PARSENAME(@t,2)