how can i suppress the field if the type is blob/memo

i.e., if the data is not present then i want to suppress the space the field takes in the report
how can i achive this? plz need some help

or

how can i assign a formulafield thrg VB6 coding

i tried

Report.FormulaFields(1).Text = "{msr_ra_disc_temp.pt_id}"

but not working -- ajay_gs ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------

I have never tried your first option. I will tell what i do with ur second
question.
I the report, create a formula field and keep it empty and place in the area
where u require, and now u can pass the data from vb thro this code.

CrystalReport1.Formulas(0) = "address = '" & str_Address & "'"

here, address is the name of the formula created in the report and
str_address is the string variable where the value is stored.

CrystalReport1.Connect = "dsn="
CrystalReport1.ReportFileName = App.Path & "\reports\deliverynote.rpt"
CrystalReport1.Formulas(0) = "address = '" & str_Address & "'"
CrystalReport1.SelectionFormula = "{tbl_deliverymaster.lng_dn_recordno} = "
& lng_DN_RecNo & ""
CrystalReport1.WindowState = crptMaximized
CrystalReport1.Action = 0

Hope it will work for u.
wishes.


Show quoteHide quote

VB.NET is the "New Coke" of the computing world.
Fuzzy Logic
Is VB6 still alive and well?
Impact of file numbers
Weird...