How to Remove decimal from string in Crystal Report

ToText({#any_number},0,"")

How to Page N of M in formula in crystal report

 numbervar n := PageNumber - 1;

numbervar m := TotalPageCount -1;

stringvar page := "Page " + toText(int(n)) + " of " + toText(int(m));

page

How to Page wise Records Break in crystal report

 Section Expart> Go Details > Pagin> X-2  Paste Code 

if pagenumber=1 and recordNumber=3 then true
else if pagenumber=2 and RecordNumber=36 then true
else if pagenumber=3 and RecordNumber=36 then true
else if pagenumber=4 and RecordNumber=36 then true

//
////this also working
//if pagenumber=6 and Remainder(recordnumber,4)=0 then true
//
//else if pagenumber=7 and Remainder(recordnumber,20)=0 then true
//
//else  false

//IF Remainder (RecordNumber, 4) = 0 THEN
//    TRUE
//ELSE
//    FALSE

Caps Lock Detected in Oracle apex

/* Create Region & Add Item like (P10_BOOK_NAME) in Region Name

---Function and Global Variable Declaration

*/

 /* check for CAPS LOCK on all password fields */
$(P10_BOOK_NAME).keypress(function(e) {
    var kc = e.which; // get keycode
    var isUpperCase = ((kc >= 65 && kc <= 90) || (kc >= 33 && kc <= 34) || (kc >= 36 && kc <= 39) || (kc >= 40 && kc <= 42) || kc == 47 || (kc >= 58 && kc <= 59) || kc == 61 || kc == 63 || kc == 167 || kc == 196 || kc == 214 || kc == 220) ? true : false; // uppercase A-Z or 'Ä', 'Ö', 'Ü', '!', '"', '§', '$', '%', '&', '/', '(', ')', '=', ':', ';'
    var isLowerCase = ((kc >= 97 && kc <= 122) || (kc >= 48 && kc <= 57) || kc == 35 || (kc >= 43 && kc <= 44) || kc == 46 || kc == 228 || kc == 223 || kc == 246 || kc == 252) ? true : false; // lowercase a-Z or 0-9 or 'ä', 'ö', 'ü', '.', ','
    // event.shiftKey does not seem to be normalized by jQuery(?) for IE8-
    var isShift = (e.shiftKey) ? e.shiftKey : ((kc == 16) ? true : false); // shift is pressed
    // uppercase w/out shift or lowercase with shift == caps lock
    if ((isUpperCase && !isShift) || (isLowerCase && isShift)) {
        $(this).next('.form-control-feedback').show().parent().addClass('has-warning has-feedback').next(".capsWarn").show();
    } else {
        $(this).next('.form-control-feedback').hide().parent().removeClass('has-warning has-feedback').next(".capsWarn").hide();
    }
}).after('<span class="glyphicon glyphicon-warning-sign form-control-feedback" style="display:none;"></span>').parent().after("<span class='capsWarn text-danger' style='display:none; color:red;'>Is your CAPSLOCK on?</span>");

Export to PDF line spacing changed

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Export\Pdf

Preamble: i set ForceLargerFonts=1, TruncationAdjustment=2, UsePrecisePositioningForText=1 on registry.

C:\Windows\ServiceProfiles\LocalService

%systemroot%\ServiceProfiles\LocalService

Networking Commands

//reboot registry in cmd mode - Micrrosoft Windows 10

sfc /scannow

ORA-04098: trigger 'IPIHR.NAVIGATION MENU UPD' is invalid and failed re-validation

 ALTER TRIGGER NAVIGATION_MENU_UPD DISABLE;

ALTER TRIGGER NAVIGATION_MENU_UPD ENABLE;