Recent content by GeneN24

What causes the join options to be unavailable (grayed)?

I figured this out. Thanks for your help.

I believe this information worked. However, can someone tell me how to place leading zeros in front of the julian date (to always display 3 bytes) in cases the date is < 100 ? For example January 1 should display &quot;001&quot; instead of &quot;1&quot; . Thanks for all of your help so far.

Can someone help me format a date/time field (TRANS_DATE) into Julian Date format(2003204). Thank you

Ido, your suggestion worked like a charm. Hopefully with more experience I will become as innovative as those on this board that give the excellent solutions to our problems. Thanks, Gene

Is there a way to format an amount field to round down? Thanks

Synapse, I believe your solution worked. Thank you very much. Gene

How can I create a group summary of a detail amount field without exceeding a specified amount? I have done a formula for the group total, but cannot produce a grand total of that formula field since it is not directly based upon the detail. This is my actual objective. Thank you

I am using version 8.5. It appears to be mostly formula fields that are cut off and the &quot;Can Grow&quot; option is grayed out and not available for these fields. Further information would be appreciated.

Does anyone have any secrets for exporting a report into text format. I always seem to have data fields cutoff after exporting. Thank you,

At times when a number in Crystal has no decimal (105123), when exported to Excel it is made a decimal and cannot be reformatted (105123.00). Does anyone know a way around this? Thanks

Thanks for the explanation.

The stop button works for me but only when records are being actively retrieved. It in the period before the records are being counted (at bottom of screen) that I was needing to be able to break out of the query. Thank you anyway!

To clarify, like the last post said, I am wanting to stop the query before records are retrieved.

Is there a way to stop a report from running once it has started running? I know once records are being pulled you can press the stop icon, but can anything be done before this point. Thank you