How to i apply expresion for Number format in RDL file in SQL reporting

Hi,
How do I apply Expression for number to display a more readable format in
report( like 4516785 into 4,516,785)in RDL file in SQL reporting services
i applyed " #,# " in custom format for number, it is supporting to numbers
except 0.
if the value of the number 0 then it is displaying blank value.
but i have to display 0 also.
if any body know the solution please point me .
thnaks in advance
mur.#,##0
The 0 means always show. So for instance you could also do this:
#,##0.0 which would have 1234.000 would show as 1,234.0 whereas #,##0.#
would show as 1,234
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mur" <u21134@.uwe> wrote in message news:5f28dac982c4b@.uwe...
> Hi,
> How do I apply Expression for number to display a more readable format
> in
> report( like 4516785 into 4,516,785)in RDL file in SQL reporting services
> i applyed " #,# " in custom format for number, it is supporting to
> numbers
> except 0.
> if the value of the number 0 then it is displaying blank value.
> but i have to display 0 also.
> if any body know the solution please point me .
> thnaks in advance
> mur.|||hai, Bruce Loehle-Conger
its working fine now and it help me a lot .
thank you very much for u r reply .
Bruce L-C [MVP] wrote:
>#,##0
>The 0 means always show. So for instance you could also do this:
>#,##0.0 which would have 1234.000 would show as 1,234.0 whereas #,##0.#
>would show as 1,234
>> Hi,
>> How do I apply Expression for number to display a more readable format
>[quoted text clipped - 12 lines]
>> thnaks in advance
>> mur.
--
mur
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200604/1

How to hide/show parameter dynamic?

There is a date range parameter in my rdl, the list value is "This Week","This Month", "This Year" and "Custom", when user choose "Custom", then display two parameter "Date From" and "Date To" to select custom date range.

My question, how to show "Date From" and "Date To" when user choose "Custom", and will hide these two parameter when user choose other item.

Thanks

You don't say what kind of element Date To and Date From are, but if they are text boxes with lables, you can change their Visible property from "False" to "True" or vice versa, depending on what the user has selected. I suggest that the default poroperty should be False., then make them Visisble if the user chooses "Custom"|||

Thanks for you reply

But the parameter's visible property cannot support formula, and I cannot get the change event of parameter "Date Range", such as selectedIndexChange

I use SRS2005, the "Date Range" is a dropdownlist, "Date From" and "Date To" may be the text box

How to hide/show parameter dynamic?

There is a date range parameter in my rdl, the list value is "This
Week","This Month", "This Year" and "Custom", when user choose "Custom", then
display two parameter "Date From" and "Date To" to select custom date range.
My question, how to show "Date From" and "Date To" when user choose
"Custom", and will hide these two parameters when user choose other item.
I use SRS2005
If cannot design the above function, I want to know, how to set the layout
of 3 parameters as:
Date Range ______
Date From ______ Date To ______
The SRS will display as:
Date Range ______ Date From ______
Date To ______
ThanksIf the parameters values are coming from query byway of datasets then it can
be cascaded so whn you select "custom" then it displayes the from and to
otherwise I suppose it is not possible. when you create 3 parameters then it
displays all 3.
Amarnath
"icyer" wrote:
> There is a date range parameter in my rdl, the list value is "This
> Week","This Month", "This Year" and "Custom", when user choose "Custom", then
> display two parameter "Date From" and "Date To" to select custom date range.
> My question, how to show "Date From" and "Date To" when user choose
> "Custom", and will hide these two parameters when user choose other item.
> I use SRS2005
> If cannot design the above function, I want to know, how to set the layout
> of 3 parameters as:
> Date Range ______
> Date From ______ Date To ______
> The SRS will display as:
> Date Range ______ Date From ______
> Date To ______
> Thanks
>|||Hi
I'd be curious as to your coding behind this. I need to do similar in
giving a list that has predefined dates to be passed except when the user
chooses their own dates.
Thanks
chelle
"icyer" wrote:
> There is a date range parameter in my rdl, the list value is "This
> Week","This Month", "This Year" and "Custom", when user choose "Custom", then
> display two parameter "Date From" and "Date To" to select custom date range.
> My question, how to show "Date From" and "Date To" when user choose
> "Custom", and will hide these two parameters when user choose other item.
> I use SRS2005
> If cannot design the above function, I want to know, how to set the layout
> of 3 parameters as:
> Date Range ______
> Date From ______ Date To ______
> The SRS will display as:
> Date Range ______ Date From ______
> Date To ______
> Thanks
>