How do you get the data to show in fractional format? (rounded to the nearest 1/32")  i can't seem to figure it out. 

I'm using 6.7 build 16.  Thanks.

Hello,

Click your Microvellum Configuration button. Under COMPANY NAME is another table area titled NUMERIC UNITS AND DISPLAY. Underneath there, to the right of ACCURACY are two radial buttons, one for DECIMAL, the other for FRACTION.

As far as i can tell, this setting only applies to numbers generated in master cut reports, and most other reports. It does NOT apply to the SHOW PARTS LIST ON DRAWING command.

Have a good day,

Eloy. 

are you using crystal reports or the MV generated reports?

MV Generated.

I've poked around in crystal reports, but have not fully started using it yet. 

hmmm.....what version of 6.7 are you on?   Mine's not working!

6.7.704

hmmm. thats the only way i know how to get the decimals to fractions in reports.

i suggest calling techsupport and utilizing the GoToAssist program they offer help with. Amazing support from MV.

PKUPMAN:

If you have Crystal Reports, you can open it up and modify the way values are displayed anywhere within your reports. You could even download the trial version (30 days) and make a bunch of changes to your reports within that time frame if you don't already have the software. That's how I started out, then we decided to just go ahead and keep it.

if you are editing crystal heres a formula for fractions:

NumberVar raw :={CombinedParts.Length};
NumberVar wholeNumber := int(raw);
NumberVar decInput := round (raw - Wholenumber , 5);
NumberVar numerator :=1;
NumberVar denominator :=1;
NumberVar decimalFraction := numerator / denominator ;
Do ((If decimalFraction < decInput
Then numerator := numerator + 1
Else ( denominator := denominator + 1 ;
numerator := truncate(decInput * denominator)))
;decimalFraction := numerator / denominator )
While decimalFraction <> decInput;

(if wholenumber > 0
then totext(wholeNumber,0,"") + " "
else "")
&
(if numerator > 0
then totext(numerator,0 , "") & "/" & totext(denominator,0 , "")
else "")

and just replace the first line field combinedparts field to what ever field you need to be in fractions

and in the third line where the 5 is type the number of places to round to.

Hello All,

If you are using the Crystal Report, please make sure you download the lastest CR9+ package, and there is a function to covert the number into whatever format you set in the Microvellum Options screen. Either is faction or decimal.

The formula can be found in the "Job Summary Report", under the formula called: "MultiFormatCutLength".

"MVCobjLinOptMVFormatNumber" is the name of the function. Below is a sample:

Dim TheNumber As Double
Dim DecimalPlaces As Number
Dim RoundingAccuracy As Number
If {Jobs.UnitOfMeasure} = 0 Then
    DecimalPlaces = 1 Else
    DecimalPlaces = 3
End If
If {Jobs.ConvertUnits} = 0 Then
    RoundingAccuracy = {Jobs.Accuracy} Else
    RoundingAccuracy = .5
End If
TheNumber = {Last_Batch.Cut Length}
Formula = MVCobjLinOptMVFormatNumber (TheNumber, RoundingAccuracy, {Jobs.NumberFormat}, DecimalPlaces)

The function will look at the setting in the MV options screen. Hope this helps.

Thanks.

Feng

 Hi,

I've already asked this question here but this might be a better route to continue this thread.

I've seen those functions in almost every Report that MV comes with.  The problem I'm having is when I need to edit those reports to suit my company's needs, it won't let me preview what the report is going to look like because Crystal Reports XI doesn't recognize those functions.  Is there a patch or update that will allow CR to be able to use those MV functions?

Thanks!

-tscull

Hello Tscull,

Rather than just open the report in the Crystal Report, I would suggest you create a sample job, process it, and open the report template inside of that sample job (in the release folder). This way, the data has been porpulated into the database, and you should the preview.

It is way easier to edit/modify the report template this way.

Hope this helps.

Thanks.

Feng

 Ok thanks Feng!

So is there not a way to preiew the data in 11.5 since the functions are not being recognized?  I realize I can view it in OverDrive, but it is faster to modify if we can stay in Crystal and view the report also.

You should open the report template in Crystal Report. What I try to say is: you should open the template in the sample job which already has the propulated data. If you just open the template from the Microvellum Template folder, you won't be able to see any data, just the layout.

Hope that helps. Thanks.

Feng