Dynamic Report Title and keeping it centered

I have a text box in a header for my report title, its reads something like this:

=RTRIM( Parameters!state.Value) + " Summary of Total Trust Assets - Sorted by Industry"

Although I have the textbox centered in the page, since the state.value is dynamic the lenght of the state name could be different than throwing off how centered the title appears? I am pulling my hair out trying to figure out a solution and would greatly appreciate any help or knowledge people might pass on.

Thanks

Duane

Center the textbox horizontally on the page, and also center the text inside the textbox (center justified). It should work.

Dynamic Message Box In Report

Hello Sir,

I m working in Microsoft SQL Server Analysis Services Designer
Version 9.00.1399.00 for creating reports .

Now, I m facing a problem to view a run time dialog box at time of my report.
Means ,
In my report procedure , i have fired 2 delete queries after firing of these queries i wanna show a message box with Message "Some Records are Deleted". and one Ok Button !!

and after showing this dialog box i wanna view my report output !!

The procedure of my report is :
--
create procedure MyTemp
as

-- Query1
delete from myTempTable1 where Id = 5

-- Query2
delete from myTempTable2 where Id = 10

-- After exectuing above two queries Query1 and Query2.
-- here i want to view amessage dialog box with message "Some Records are Deleted"

select Id, name from myTempTable1,myTempTable2
--

So, how can i do this !!
I will change in my proceudre or report !!
Please suggest me about solution of this problem .

If u dont have any solution regaring this then please suggest me where i will get
the solution of this problem .

There is no messagebox in reporting services. Yout will have to give the results back as a dataset and render it in the report if your want to display it.

Jens K. Suessmeyer

http://www.sqlserver2005.de