No hate mail please.:hehe:

I thought...

Thanks, that was easy.:cool:

I was not aware of that function.

I goggled and I could not find anything.

I'm sorry, I misunderstood.

I found how to format the text box but I want to include the date in a text box that has other text items before and after...

WILLIAM MITCHELL (11/23/2011)

---

The letter d will format the date without the time.

Similarly, to...

Thanks for the formula.:-)

The following does not right justify the percentage:

CAST(CONVERT(Decimal(9,2),ROUND(100.00 * Sum(Sale)/NULLIF(Sum(Quote), 0) ,2)) AS VARCHAR(6)) + '%'

NoSales

1.90%

11.11%

22.80%

5.71%

10.34%

Awesome.

I'm trying to get the result rounded and Converted as follows:

No. of QuotesNo. Sold% Sold

140 3...

Craig,

I'm looking for the SUM(Sale)/SUM(Quote) WHERE Sale could be zero.

Thanks!

I wish that we did not have SQL Server 2005 for Reporting Services.

I would have preferred to be able to format the date in a text box that is concatenated...

I'm going to converting large data from an AS400 DB2 iSeries to SQL Server.

I will be moving part of the data based on when the contract is renewed.

I want to...

I create the initial report using the Wizard and the only option is to specify text as a Data Source..

Then I add a footer and page header, format the report,...

It just changed,...

Cadavre (11/18/2011)

---

Welsh Corgi (11/18/2011)

---

Hi SQL Experts.

I need to Calculate First Day of Previous Week.

Today the 1st Day of last Week is Sunday 2011-11-13.

I do not want the time part of...

Lowell (11/18/2011)

---

for you, when does a week start? on Sunday, right?

this gives you the Monday of "this" week, regardless of the DATEFIRST parameter setting:

select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) As MondayOfThisWeek,

...

I spoke too soon.:crying:

You can format the date in SSRS 2008 as I stated but that is not the case in 2005.

I'm posting a question to the Reporting Services Forum.

I...