{"id":6345,"date":"2013-10-30T11:30:26","date_gmt":"2013-10-30T00:30:26","guid":{"rendered":"http:\/\/mingersoft.com\/blog\/?p=6345"},"modified":"2013-10-30T20:33:24","modified_gmt":"2013-10-30T09:33:24","slug":"crystal-reports-function-sequence-error","status":"publish","type":"post","link":"https:\/\/mingersoft.com\/blog\/2013\/10\/crystal-reports-function-sequence-error\/","title":{"rendered":"Crystal Reports – Function Sequence Error"},"content":{"rendered":"

Bit of a narrow topic but thought I would share given that I couldn’t find a solution on the web.<\/p>\n

I use Crystal Reports as part of my work in conjunction with databases and Business Objects Enterprise and usually everything works without hiccups. However, I’ve built a couple of reports recently that ended up with a function sequence error<\/strong> which interrupts the flow of data from the database.<\/p>\n

\"Crystal<\/a>

Crystal Reports – Function Sequence Error<\/p><\/div>\n

The error got me thinking that maybe there could be an issue with hitting the view behind the report too hard or too quickly. Maybe a flimsy theory at best but with little else to go on I couldn’t be any worse off but thinking outside the box. So, I thought that this might of had something to do with having the report fetch data asynchronously from the database.<\/p>\n

So, I did the following:<\/p>\n

    \n
  1. Closed and reopened Crystal Reports,<\/li>\n
  2. Opened the offending report,<\/li>\n
  3. Disabled Perform Query Asynchronously <\/strong>in Report Options<\/strong>,<\/li>\n
  4. Click OK<\/strong>,<\/li>\n
  5. Refresh the report,<\/li>\n
  6. Save the report.<\/li>\n<\/ol>\n
    \"Crystal<\/a>

    Crystal Reports – Report Options<\/p><\/div>\n

    This seemed to work for me just fine and, when I re-enabled the offending option the function sequence error reappeared. I don’t know why it worked but thought I would share this as a potential solution for others experiencing the same issue.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Bit of a narrow topic but thought I would share given that I couldn’t find a solution on the web. I use Crystal Reports as part of my work in conjunction with databases and Business Objects Enterprise and usually everything works without hiccups. However, I’ve built a couple of reports recently that ended up with … <\/p>\n

    Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[18],"tags":[2151,783],"class_list":["post-6345","post","type-post","status-publish","format-standard","hentry","category-technology","tag-crystal-reports","tag-database","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts\/6345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/comments?post=6345"}],"version-history":[{"count":0,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/posts\/6345\/revisions"}],"wp:attachment":[{"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/media?parent=6345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/categories?post=6345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mingersoft.com\/blog\/wp-json\/wp\/v2\/tags?post=6345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}