{"id":229,"date":"2010-05-31T03:17:00","date_gmt":"2010-05-31T03:17:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=229"},"modified":"2010-05-31T03:17:00","modified_gmt":"2010-05-31T03:17:00","slug":"standard-sage-crm-reports-with-custom-styling","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/","title":{"rendered":"Standard Sage CRM reports with custom styling"},"content":{"rendered":"

When we go for creating a new report in CRM, we can see the below screen to enter the report details. Here we need to specify the styling that we are going to use for this particular report.<\/p>\n

<\/p>\n

\"\"<\/a><\/p>\n

By default there are two styles provided over here as mentioned below.
1. Standard with Grids<\/strong>
2. Standard without grids<\/strong><\/p>\n

The styling options selected above are saved to custom_reports<\/strong> in repo_reportstyle<\/strong> field.<\/p>\n

Now what if you need to have the same structure as that of the standard styling, but need to quickly change colors and other styling elements in report? How to go about quickly designing the custom styles for the new report you are developing? Read below to know more.<\/p>\n

Suppose you want to quickly create a new style sheet named My Custom Style Sheet for the report you are developing.<\/p>\n

1. Create an entry in Translations<\/strong>: How do we see the above two options in the Report Styles field? Very simple, as per the standard lists functionality in CRM, an entry has to be made in translations to do the same with following details.<\/p>\n

Caption Family = \u201cReportStyles<\/strong> \u201c
Caption Code = \u201cMyCustomStyleSheet<\/strong> \u201c
Translation = \u201cMy Custom Style Sheet”<\/strong><\/p>\n

Now the code value used above i.e. MyCustomStyleSheet<\/strong> is the key thing we need to remember.<\/p>\n

2. Create report styling prerequisites<\/strong>: Now suppose you want to use the Standard with Grids option with the colors and styles of your choice.<\/p>\n

– Go to C:Program FilesSageCRM WWWRootReports folder<\/p>\n

– Copy and paste the below files at the same path to create the copies of the same.
StdGrids.css
StdGridsCE.xsl
StdGridsPC.xsl<\/strong>
These are the files being used for styling in Standard with grids option.<\/p>\n

– Rename the copied files as below respectively (Use the code value as key thing as mentioned above).
MyCustomStyleSheet.css
MyCustomStyleSheet CE.xsl
MyCustomStyleSheet PC.xsl<\/strong><\/p>\n

– Here the CSS file is the cascaded style sheet file responsible for attaching styling with various elements in report like colors, size etc.<\/p>\n

– XSL files are the extended style sheet files that are responsible for generating the overall structure for the report.<\/p>\n

These XSL files include the link to cascaded style sheet. You need to open both the XSL files and find the tag Link<\/strong>. You need to change the link of style sheet here to that of the one you are using i.e. MyCustomStyleSheet.css<\/p>\n

– Now you can edit the XSL and Cascaded style sheet files mentioned above to achieve the styling of your choice.<\/p>\n

3. Attach custom styling with new report<\/strong>: After following the steps given above you can see a new option in Report Style field while creating new report named My Custom Style Sheet. You can select this option and create your report to see the output as per the changes you did in style sheets as mentioned above.<\/p>\n

If you find this content useful, Please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

When we go for creating a new report in CRM, we can see the below screen to enter the report details. Here we need to specify the styling that we are going to use for this particular report. By default there are two styles provided over here as mentioned below.1. Standard with Grids2. Standard without\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":[1],"tags":[842,843,1920,2366],"class_list":["post-229","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-crystal-report","tag-css","tag-report","tag-summary-report"],"yoast_head":"\nStandard Sage CRM reports with custom styling - 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\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Standard Sage CRM reports with custom styling - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"When we go for creating a new report in CRM, we can see the below screen to enter the report details. Here we need to specify the styling that we are going to use for this particular report. By default there are two styles provided over here as mentioned below.1. Standard with Grids2. Standard without\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-31T03:17:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.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\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/\",\"name\":\"Standard Sage CRM reports with custom styling - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.JPG\",\"datePublished\":\"2010-05-31T03:17:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#primaryimage\",\"url\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.JPG\",\"contentUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Standard Sage CRM reports with custom styling\"}]},{\"@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":"Standard Sage CRM reports with custom styling - 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\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/","og_locale":"en_US","og_type":"article","og_title":"Standard Sage CRM reports with custom styling - Sage CRM \u2013 Tips, Tricks and Components","og_description":"When we go for creating a new report in CRM, we can see the below screen to enter the report details. Here we need to specify the styling that we are going to use for this particular report. By default there are two styles provided over here as mentioned below.1. Standard with Grids2. Standard without\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-05-31T03:17:00+00:00","og_image":[{"url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.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\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/","name":"Standard Sage CRM reports with custom styling - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#primaryimage"},"thumbnailUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.JPG","datePublished":"2010-05-31T03:17:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#primaryimage","url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.JPG","contentUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TAMs-B8-BSI\/AAAAAAAABD4\/f4YoXabsrE0\/s320\/123test.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/31\/standard-sage-crm-reports-with-custom-styling\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Standard Sage CRM reports with custom styling"}]},{"@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\/229","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=229"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/229\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}