[CR 6.5] Formatting formula field - AndreaVB Visual Basic and VB.NET source code discussion board

Previous Topic (Paper size problem in Crystal report)

Next Topic (crystal report connection error pls help)

AndreaVB Forum : Reporting tools : [CR 6.5] Formatting formula field

Poster

Message

alzir+
Level: Guest

[CR 6.5] Formatting formula field

Hi everyone,
maybe someone can helps me.
My vb6 App call a report passing a formula...
I can't change default format of Formula Field. Data type passed from Vb is a string but with all numerics digit... I need to avoid the formula filed be formatted like a number..
but all formatting items are disabled.

Some input?
Thanx

12-10-2004 at 04:37 PM

Goran
Level: Moderator

Registered: 16-05-2002
Posts: 1681

Re: [CR 6.5] Formatting formula field

I gues your version has to have To Text function, so maybe you can use on your final result in formula.

____________________________
If you find the answer helpful, please mark this topic as solved.

12-10-2004 at 08:57 PM

alzir+
Level: Guest

Re: [CR 6.5] Formatting formula field

My Mystake...
in mycode...

dim sSocNumber as string
sSocNumber = GetSocialNumber(CodID)
.formula(1)="text = " & sSocNumber

the last line is the wrong one...

putting
.formula(1)="text = '" & sSocNumber & "'"

it just fine...

13-10-2004 at 09:22 AM

AndreaVB Forum : Reporting tools : [CR 6.5] Formatting formula field


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincani