Click here to Skip to main content
15,890,438 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi bro !!!

I am using SSRS. I have a mone parameter. I want to mask $money for it. Example: when i input money into textbox it will auto add $ for textbox or when i preview report , it has $ before textbox parameter.

I have read many topics. All of them say SSRS doesnt support it.

How can i do ??? I dont use reportviewer control asp . I only want use it in preview in report viewer.
Posted

1 solution

It is easy to create paramenter in SSRS.

Let try this:

Normal query:
SQL
Select * from Orders where OrderID > 10248
. That is static condition.

you change the query as
SQL
Select * from Orders where OrderID > @orderidFilter


The parameter @orderidFilter will be generated automatic.

You click prevew report in SSRS. The textbox will be displayed and map to condition of query statement. you can input 10248, 10249 ... and enter. you can see the result
 
Share this answer
 
v2
Comments
baotdinh 30-Jul-13 22:49pm    
You misunderstand this problem. I know about generate parameter in SSRS. But i want to mask $ front of textbox parameter

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900