{"id":26653,"date":"2023-05-31T04:16:35","date_gmt":"2023-05-31T04:16:35","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=26653"},"modified":"2024-11-26T10:27:02","modified_gmt":"2024-11-26T10:27:02","slug":"previous-function-in-crystal-reports","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/05\/31\/previous-function-in-crystal-reports\/","title":{"rendered":"PREVIOUS() function in Crystal Reports"},"content":{"rendered":"\n

In the Sage X3<\/a>, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop new customized crystal report as per the client\u2019s need.<\/p>\n\n\n\n

For one of our client we have developed a report that contains all the information related to Work Orders (report is printing in excel format) and there was a requirement from the client that if the Operation Status<\/strong> is closed for the previous line then the Planned Qty<\/strong> of the previous line should be printed in a \u201cPrevious Operation Qty<\/strong>\u201d field of current line.<\/p>\n\n\n\n

For this requirement, we have used the Previous()<\/strong> function in Crystal Report formula.<\/p>\n\n\n\n

To achieve the above requirement follow the below steps:<\/p>\n\n\n\n

Step 1:<\/strong> Create a formula ‘fm_close<\/strong>‘ for previous line’s status (whether it is close or not)<\/p>\n\n\n\n

New Stuff:<\/strong> How to conditionally format fields using the Highlighting Expert in Crystal Report<\/a><\/p>\n\n\n\n

\"Formula<\/a><\/center>\n
Formula fm_close<\/center><\/font>\n\n\n\n

Step 2:<\/strong> Create another formula ‘Pre_Op_Qty<\/strong>‘ to retrieve the last line’s planned qty (if the status is closed for last line else print 0)<\/p>\n\n\n\n

\"Formula<\/a><\/center>\n
Formula Pre_Op_Qty<\/center><\/font>\n\n\n\n

Step 3:<\/strong> Drag and drop this formula ‘Pre_Op_Qty’ wherever you want to add in report.<\/p>\n\n\n\n

\"Output\"<\/a><\/center>\n
Output<\/center><\/font>\n\n\n\n

Refer the above screenshot in which you can check, by using previous function, we have printed planned quantity of previous line in the next line only if the operation status of previous line is \u201cClosed\u201d.<\/p>\n","protected":false},"excerpt":{"rendered":"

In the Sage X3, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop new customized crystal report as per the client\u2019s need. For one of our client we have developed a report that contains all the information related to Work Orders (report is printing in\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[343,3747,461,3748,3749,2157],"class_list":["post-26653","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-closed","tag-comments","tag-crystal-report","tag-previous-function","tag-previous-function-in-crystal-report","tag-status"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=26653"}],"version-history":[{"count":11,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26653\/revisions"}],"predecessor-version":[{"id":30257,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26653\/revisions\/30257"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=26653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=26653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=26653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}