Display Currency Values Without Currency Symbol

rbuser

I'm trying to display currency values without the currency symbol.

For example I have a balance of 2100.00 that I'd like to print as 2,100.00

I'm using a JITPipeline and I have added a field called Balance.

If I set that JITPipeline Balance field to dtCurrency it diplays properly $2,100.00
However, I do not wish to see the "$" currency symbol.

I've tried:

Datatype dtDouble
DisplayFormat #,###,##0.00

But it prints as 2100

How dow I get the JITPipeline Balance field to print as 2,100.00

Thank you.

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

rbuser

Hi Michael,


I just tried that - and you are right: the display format of the field
in the pipeline seems to be ignored.

I set all display formats in the DisplayFormat property of the databound
components - that works!

Uli Becker

nicocizik

Hi Michael,

Sorry for the late reply.

Instead of setting the DisplayFormat of the field, try setting the
DisplayFormat property of the DBText you are using to access the field.
This should give you the format you are after.

rbuser

Nico Cizik (Digital Metaphors) wrote:


Nico,

Unfortunately I'm not using a DBText I'm using the value of the Input box. I'm basically trying to create something similar to the Cover Page report i\from Learn Report Builder.

I basically have an amortization table that comes from a DBGrid this displays perfectly. I'm trying to display the Balance, APR and Payment data from edit input boxes using the JITPipeline to set the values.

I even tried setting the JITPipeline fields to a dtString and passing it a formatted value and it didn't work.

How can I make this work?

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

rbuser

Uli Becker wrote:


Hi Uli,

Wow great minds think alike... ElevateDB and ReportBuilder :-)

Unfortunately, I'm not using data-bound components :-(

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

rbuser

Uli Becker wrote:


Uli,

Please email me your contact info to rileymj [at] zilchworks.com

Thanks
Michael

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

nicocizik

Hi Michael,

I'm sorry but I'm a bit unclear about what exactly your app is doing.

If you are not using data aware report components (TppDBText), then how
are you displaying the data returned by the JITPipeline inside your report?

rbuser

Nico Cizik (Digital Metaphors) wrote:


Nico,

I'm sorry. I am such a NEWB! I totally misunderstood what you said. I *was* setting the displayformat on the PipeLine field and not the dbText component.

It works perfectly when I set the display format on the dbText component inside the report. Geeez!

Thanks again.

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com