Help on formatting Dynamic Cascading Parameter 1

[suburbanites]

I use CRXI SP1. I have a dynamic cascading parameter. Its numeric so when it comes up it's in the format x,xxx,xxx. Is there any way to change this so it would get rid of the commas?
I also have a year parameter that has commas that I would like to get rid of.

Additionally, when I do Refresh Report Data, these fields still all contain the commas.

Any help would be appreciated...

 

[synapsevampire]

The decimals will follow your File->Options->Fields->Number->Number formatting.

It would appear that the thousands do not, at least in the CR XI SP2 I have, though I thought it used to.

-k

 

[suburbanites]

Hi SV,

It's still appearing x,xxx. It's a company field in the file and it looks like 1,000 2,000 etc. I am using this as a dynamic cascading so it's pulling directly from the file. I changed the File->Options->Fields->Number->Number formatting but when I prompt for new parameters, it still shows as x,xxx.

 

[synapsevampire]

Yeah, that was what my post stated, I could only eliminate the decimals, not the thousands seperator...

SInce it's merely a year parameter, you might use a Command Obnject as the source and CAST it to a char:

CAST(table.field as CHAR(4))

Of course this is dependent upon the database type, which you didn't share.

You'll see Add Command listed under your database type.

Please include that with post in the future.

-k

 

[suburbanites]

Not sure how to create a Command Object or how to create it. Quite new on Crystal.

I just changed the year parameter from number to string and placed an edit mask of 0000. It took away the comma but I see a comment on top of the parameter "This prompt has an edit mask: 0000". How do you get rid of this comment?

 

[synapsevampire]

Command Object, per my post:

"You'll see Add Command listed under your database type."

Use Database->Database Expert, select Add Command, paste in the SQL.

select cast(table.field as char(10)) from table

I also asked you to please post your database type.

Hopefully someone you respect more will come along and finish this thread.

-k

 

[suburbanites]

Sorry if I'm a bit dense. I do thank you for taking your time to answer my post. I will close this thread and see if I can figure out what you have just posted.