Search results for query: *

Thanks, that seemed to work just great ! [wink]

I have a database field, SAWP030A.TGLMA, which is represented in minutes (let's use 60 minutes for this example). I need to convert that to hours and minutes, so I have used the following formula: ToText(({SAWP030A.TGLMA})\60, 0) + ':' + ToText(({SAWP030A.TGLMA}) Mod 60, 0) The report shows...

So, go from this: BILP350C.BILLC *= BILP352F.BILLF AND BILP350C.BILAUC *= BILP352F.BILAUF AND BILP350C.BILLC *= BILP351C.BILLC AND BILP350C.BILAUC *= BILP351C.BILAUC AND BILP350C.RTUNTC *= BILP305E.RTUNTE AND BILP350C.ITEMC *= INVP100A.ITEMA AND BILP350C.OWNERC =...

I thought these were left outer joins? This is the query that Crystal created. I don't think I can manipulate it, can I? Thanks...

After going through my report field by field, formula by formula, I have finally discovered why I get this error --> a left outer join on BILP351C.TRNTPC *= SAWP652E.TRNTYE. When I take this out of the query, I get records. Here is the query that Crystal generates: SELECT BILP350C.BILLC...

I'm sorry, typo. I meant I suppressed the report footer.

Naith, I cannot delete this section because it is the page footer. I right mouse click and do not have the option to delete it, instead I have suppressed it. Also, the section lines are dragged to the bottom of the fields in that section. Design view looks correct, preview mode puts this gap in...

I am doing a bill of lading report that contains the page header, details section, and page footer. I need the page header and page footer to appear on each and every page. Now, here is my formatting question... The details section and the page footer have a gap/space between them on the report...

Thank you for the help. I just discovered a new way to do it. I have the same value type (Date) and option (Range Value). Then I created a formula and dropped this formula onto my report: ToText(Minimum({?Date Range})) + "-" + Totext(Maximum({?Date Range})) And it displays...

When I place the date range parameter on the report, it shows a blank instead of the dates I entered. I would like to see 5/14/02-5/16/02 that was selected from the drop down calendar. Why did this happen? All the other parameters show fine... Value Type: Date Option: Range Value(s) Thanks...

The two DLL's provided by Azalea are: 1.) u2lbcode.dll 2.) barcode.dll and I placed them in ...\WINNT\SYSTEM32. Don't know if this info helps or not. Just more like an FYI. Thank you for your responses! s-)

You think these two DLL are necessary?

What I do have installed are fonts and DLL's from Azalea. I think this is about the same as that UFL from Crystal.

We are using Code 128 font, I tried the formula that you suggested and it did not work. Do you have any other suggestions for Code 128?

Will do, thanks Jim for your help! Much appreciated! s-)

The same format is being printed.

1.) I used barcode fonts from Azelea and installed them. 2.) I created a formula: BarcodeC128A("(402)"+{ORDP999B.BLADB}). This function comes from the "Additional Functions". 3.) The barcode fonts are universally bad and the same barcode "look" prints everytime...

The thing is that this report is being printed from a software product we are developing. So, it is printing from an application, not directly in Crystal Reports. Within Crystal Reports itself, the barcode looks, prints, and scans fine. When printed from the application, it prints these...

I have a barcode formula and I want the barcode to automatically size itself. I thought maybe the can grow feature would do it. Unfortunately, it only goes vertical. Any other suggestions? Thank you s-)

After checking the "Can Grow" under the format editor, the field grows down instead of growing across. Is there a formula I can use to change this?