Search results for query: *

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...

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 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...

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...

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?

I have a table that I need two fields from. However, I cannot link it to any of the other tables in the Visual Linking Expert. Is there still a way to include this table in my report?

I created my reports using CR Version 8.5 Professional. When these reports are delivered to a customer of ours, I need to manually go into CR on the customers side and change the Database|Set Location with every report in order for them to work. Is there any way of getting around this? Reports...

I only have the standard edition of Crystal Enterprise that came along with my Crystal Reports Professional V8.5. When I look at the reports in the viewer, they look fine, however, when I go to print, it does not fit all the columns on the page. The report does print in landscape mode, just cuts...

1.) I have a report which contains customer order numbers. 2.) These customer order numbers are in a subreport. 3.) If the customer order numbers exceed six lines (they are in a group header), then I want it to print to another subreport that goes onto a second page. This report is a bill of...

I have a date field that is a number in the database stored as 37190 that needs to be converted to Julian. However, there are some dates in the database stored as 99999 and these dates need to be displayed as 99/99/99 on my report. I used this formula to do all this saved as {@Date}: if...

Has anyone ever designed a VICS Bill of Lading? I have a template here that someone sent to me and I was wondering if anyone had some tips for me. Seems so complicated! Any feedback is much appreciated. Thanks! s-)

Does anyone know of some good websites for tutorials? I just got Flash and I am very new to this. Where is a good place to start?

I have this formula to get a date: ToText({PURP110B.EXREMB}, 0) + "/" + ToText({PURP100B.EXREDB}, 0) + "/" + ToText({PURP100B.EXREYB}, 0, '','' ) Th date is displayed on the report as : 1/8/2002 How can I have the date be displayed as : 1/8/02?? Thank you!

Is there any way to print in design mode?

I have two fields that are a number in the database that is to be displayed on my report as: Priority Range: 1 to 9 I tried using this formula: totext({SSSP030A.FROMPRI}) + " to " + totext({SSSP030A.TOPRI}) However on my report it appears as: Pritority Range: 1.00 to 9.00 How can I...

Why is it that Crystal forces me to enter in a parameter when its value is set to number? I have this very simple formula: {?Order Number} = {TABLENAME.FIELD} What do I have to do so Crystal does not ask me, "You must enter a value for this field." Thank you!

I have grouped by three different fields. Crystal will automatically put them in three seperate group header lines. To save space, I right mouse clicked, format section, then clicked underlay following sections. This way my report goes from this: group1 group2 group3 To...

I have a formula that will not go away! I am deleting it from the Field Explorer under Formula Fields by right clicking on it. I even deleted the formula in it and Crystal still gives me an error saying, "The field could not be deleted. To delete this field, you must remove all references...

I need help to have this formula work: ToText(((Sum ({TIME.DTLTMA},{DATE.RSHPJA})\60) Mod 24),0) + 'h, ' + ToText((Sum ({TIME.DTLTMA}, {DATE.RSHPJA}) Mod 60),0) + 'm' When I check it, it gives me "No Errors". However, when I refresh the report, I get this error, "Group specified...

Hi all, I am using this formula to get my time: ToText((({TABLENAME.FIELD}\60) Mod 24),0) + 'h, ' + ToText(({TABLENAME.FIELD} Mod 60),0) + 'm' then I grouped by this time and I want the grand total of these times, however, the sum feature is not available. Anyone know why? Thank you!