Formatting A Number in a Text Field 1

[ghesse]

Hi,

This goes back to an issue I've already posted on so I'll just do a copy and paste to catch everyone up on it.

<paste>
Crystal Reports .NET integrated in aspx pages.

I am using a group expert in several of my reports. The group name and group count act as hyperlinks when a report is generated. When you click on them it pulls up a report with just the information of the group. Anything that is a formula field in the Group Footer section is treated like a hyperlink with the same behavior. I need to figure out how to disable this behavior. I do not want the user to able to click on the group name or the count.
</paste>

The solution was to drag the group name and the group count into text objects to get rid of &quot;drill down&quot; functionality that is inherent in this section of the report.

The group count text object is giving me the number with two decimal places. The formula looks something like this:
Count({storedproc.Field_Being_Counted}, {storedproc.Field_Being_Grouped})

So how do I get rid of the decimal places in this formula?

Thanks,
ghesse

 

[synapsevampire]

Try:

totext(Count({storedproc.Field_Being_Counted}, {storedproc.Field_Being_Grouped}),0,&quot;&quot

-k

 

[synapsevampire]

I should have made sure you understand to create a formula containing this, not directly in the text object.

-k

 

[synapsevampire]

...and, drop the forumla into a text object...

 

[ghesse]

Thank you for your prompt response!

It's all good and you get a pink star!

--ghesse