on 07-25-2008 1:54 AM
Hi Support,
Do anyone knows how to remove comma for number drop down list parameter? I have created a parameter for the field in number data type. When the parameter prompt, the number has comma (for eg. 7,400). May i know any formula to remove the comma?
You should be able to create it
Then drag it to the report and format it NOW right click and choose your options. Place or combine it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey calyn,
Why don't you just change the parameter to a String type, and then
change it back to Number type when you process the parameter value ?
The Panda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can modify your regional settings in Windows, however changing it for this will change it for all numbers that are used on your system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Calyn,
There one way to do it. You will need to convert the data source of your parameter to text. To do thatyou will need
to use a SQL Command. Try something like this:
SELECT
CAST(OrderID AS VARCHAR(10)) AS OrderID
FROM Orders;
Setup your dynamic parameter based on the new command
In the Select Expert convert it back to a number in the selection criteria:
{Table.OrderID = ToNumber({?ParameterName})
Hope this helps,
Jason
Calyn,
Here are the steps to add a SQL Command:
1) Open the Database Expert (the same place where you would go to add database tables to your report)
2) Look in the left pane on the window where all of your data sources are listed and find your desired data source.
3) Expand out the data data source, by clicking the + next to it.
4) You'll see the "Add Command" option listed above the database name.
5) Double click it.
Please note: The SQL you enter into a Command has to be in the native SQL language of your database. Crystal does not modify it
before passing it back to the database. There is no "Crystal Syntax" here.
Cheers,
Jason
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.