Hi Kenpet,

Its not optimized solution but can solve your problem:

DECLARE @T TABLE (ID int, NAME varchar, Amount1 int, Amount2 int,Amount3 int)

INSERT INTO @T

SELECT 1, 'A', 100, 20, NULL UNION

SELECT 2,...

Hi,

use this expression:-

=ReportItems!TextBoxName.Value

Hi Chandru,

Try this

SELECT D.DepID,D.DepName,P.FirstName,P.LastName

FROM #Department D

LEFT OUTER JOIN #Department_Person DP ON D.DepID=DP.DepID

LEFT OUTER JOIN #Person P ON P.PersonID=DP.PersonID

Hi Dity,

When you click on expression of any TextBox you can see the Edit Expression dialogue box which is shown in attached image.

Here, you can select Globals from left side,...

Shaun McGuile (7/15/2008)

---

I don't get it whats the point?

How does the functionality help me the DBA/Developer?

It gives me info on a table or proc which I could get elsewhere and...

Have you changed the Data Type of Date Field some where?

If yes then cast it into DateTime and then apply the ORDER BY

Good Article

I just wanted to change the CHAR into VARCHAR.

I tried to use dynamic SQL to print the query. Thats it.

Yeah Peso,

It'll work without Dynamic SQL

Hi Amit,

go throug this link:

http://www.sqlservercentral.com/articles/Development/2945/

You can use Globals!ReportName

Even you can use the query suggested by Ryan

select a, min(b) as b from [Table 1] group by a

select a, max(b) as b from [Table 1] group by a

--Try This

ALTER PROCEDURE Get_CustomerDetailsByName

@CustomerName varchar(30)

...

I dont know the reason but it is working on my system without removing dbo 😎

Hi Sanchita,

BOL is best to learn about that.

Just type the keyword in INDEX of BOL and see the explaination.