{"id":5177,"date":"2013-10-29T15:31:33","date_gmt":"2013-10-29T15:31:33","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=5177"},"modified":"2013-10-29T15:31:33","modified_gmt":"2013-10-29T15:31:33","slug":"steps-to-generate-complex-reports-in-sage-crm-using-advanced-find","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/","title":{"rendered":"Steps to generate complex reports in Sage CRM using Advanced Find"},"content":{"rendered":"

In our previous post, we discussed about <\/span>Generating simple reports in Sage CRM<\/a>. In this post we will be how you can quickly generate complex reports in Sage CRM using Advanced Find functionality.<\/span><\/p>\n

——————————————————————————————————————————————
\nNeed to send a Survey from Sage CRM as soon as order is Shipped?<\/span>
\nCreate your own customized Surveys\u2019 for Sage CRM \u2013<\/span>\u00a0Greytrix Survey Module<\/a>
\n——————————————————————————————————————————————<\/p>\n

If there are complex queries which require parameters to be sent on the fly, then user needs to create CRM reports using Advanced Find option. Here are the steps to do the same.
\n1) Login to Sage CRM.
\n2) Navigate to Main Menu | Reports | Report Category\u00a0(For Example, General, Marketing, Lead Reports etc.)
\n3) List of all reports will get displayed along with New button on Right hand side.
\n4) Click the New button for creating the new report.
\n5) Report Options screen will get opened. Fill Reports Details fields and select Advanced Find checkbox from the Select Column block. Refer below screenshot.
\n\"AdvanceFind\"<\/a>
\n6) Select other necessary columns for Report Contents, Search Criteria blocks and click on continue button.
\n7) Advanced Find screen will get displayed to add search criteria as per requirement. Refer below screen shot.\"AdvanceFindSearch\"<\/a>
\n8) Add the search conditions as you need and click on continue button.
\n9) Enter Title settings, Header setting, Summary Setting, Footer Settings, Column Formatting and Chart Options.
\n11) Finally click on Save button.
\n12) Report will get listed under Selected Report Category.
\n\"DefaultSearch\"<\/a>
\n13) User can run the report using an arrow button available in front of report. Search criteria will get saved with name as Default. Refer below screen shot.
\nUser can create different search conditions to create and run complex reports as mentioned above.
\nAlso Read:
\n<\/b>1) Showing images in Sage CRM Reports
\n<\/a>2) Hyperlink on Report columns
\n<\/a>3) Report Cloning in Sage CRM 7.2
\n<\/a>4) Secure report output from export
\n<\/a>5) Report Columns are now loaded in Alphabetical Order \u2013 Sage CRM 7.2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous post, we discussed about Generating simple reports in Sage CRM. In this post we will be how you can quickly generate complex reports in Sage CRM using Advanced Find functionality. —————————————————————————————————————————————— Need to send a Survey from Sage CRM as soon as order is Shipped? Create your own customized Surveys\u2019 for Sage\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[331],"tags":[],"class_list":["post-5177","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"\nSteps to generate complex reports in Sage CRM using Advanced Find - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Steps to generate complex reports in Sage CRM using Advanced Find - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our previous post, we discussed about Generating simple reports in Sage CRM. In this post we will be how you can quickly generate complex reports in Sage CRM using Advanced Find functionality. —————————————————————————————————————————————— Need to send a Survey from Sage CRM as soon as order is Shipped? Create your own customized Surveys\u2019 for Sage\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-29T15:31:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/\",\"name\":\"Steps to generate complex reports in Sage CRM using Advanced Find - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg\",\"datePublished\":\"2013-10-29T15:31:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Steps to generate complex reports in Sage CRM using Advanced Find\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Steps to generate complex reports in Sage CRM using Advanced Find - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/","og_locale":"en_US","og_type":"article","og_title":"Steps to generate complex reports in Sage CRM using Advanced Find - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In our previous post, we discussed about Generating simple reports in Sage CRM. In this post we will be how you can quickly generate complex reports in Sage CRM using Advanced Find functionality. —————————————————————————————————————————————— Need to send a Survey from Sage CRM as soon as order is Shipped? Create your own customized Surveys\u2019 for Sage\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-10-29T15:31:33+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/","name":"Steps to generate complex reports in Sage CRM using Advanced Find - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg","datePublished":"2013-10-29T15:31:33+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/10\/AdvanceFind1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/10\/29\/steps-to-generate-complex-reports-in-sage-crm-using-advanced-find\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Steps to generate complex reports in Sage CRM using Advanced Find"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=5177"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/5177\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=5177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=5177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=5177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}