{"id":203,"date":"2009-05-11T07:10:00","date_gmt":"2009-05-11T01:40:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=203"},"modified":"2009-05-11T07:10:00","modified_gmt":"2009-05-11T01:40:00","slug":"error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/","title":{"rendered":"Error &#8220;Sub reports within table\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel"},"content":{"rendered":"<div align=\"justify\">If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel.<\/div>\n<p><img decoding=\"async\" src=\"http:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg\" alt=\"\" border=\"0\" \/><\/p>\n<div align=\"justify\">Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report will be replaced with a single line error &#8220;Sub reports within table\/matrix cells are ignored&#8221;.<\/div>\n<div align=\"justify\">To be able to export SRS reports using Sub-reports to Excel, it is advisable to use List controls instead of Data Table. Once you have made this little change, the export to excel is just perfect. Infact it will automatically even freeze the rows in the page header so that when you scroll through the data that was included in the report header stays static.<\/div>\n<p>Hope this helps!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/\">Read More: Error &#8220;Sub reports within table\/matrix cells are ignored&#8221; when exporting\u2026 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,58],"tags":[752,763],"class_list":["post-203","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-ssrs-reports","tag-excel","tag-export"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Tushar\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Error \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta property=\"og:description\" content=\"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-05-11T01:40:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2009-05-11T01:40:00+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inogicindia\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Error \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks\" \/>\n\t\t<meta name=\"twitter:description\" content=\"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@inogic\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Tushar\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#blogposting\",\"name\":\"Error \\u201cSub reports within table\\\/matrix cells are ignored\\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks\",\"headline\":\"Error &#8220;Sub reports within table\\\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel\",\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/4.bp.blogspot.com\\\/_pMlyDuF-ngc\\\/SgfQXqnM4sI\\\/AAAAAAAAAD8\\\/REcv3VNdP4c\\\/s400\\\/rep.jpg\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#articleImage\"},\"datePublished\":\"2009-05-11T07:10:00+05:30\",\"dateModified\":\"2009-05-11T07:10:00+05:30\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#webpage\"},\"articleSection\":\"Dynamics CRM, SSRS Reports, Excel, Export\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/#listItem\",\"name\":\"Dynamics CRM\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/#listItem\",\"position\":2,\"name\":\"Dynamics CRM\",\"item\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#listItem\",\"name\":\"Error &#8220;Sub reports within table\\\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#listItem\",\"position\":3,\"name\":\"Error &#8220;Sub reports within table\\\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/category\\\/dynamics-crm\\\/#listItem\",\"name\":\"Dynamics CRM\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"By Inogic\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/inogic-logo.png\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#organizationLogo\",\"width\":1000,\"height\":325,\"caption\":\"inogic logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/inogicindia\",\"https:\\\/\\\/twitter.com\\\/inogic\",\"https:\\\/\\\/www.instagram.com\\\/inogicindia\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCM4V7ousgLSu1hbOEv4DUuQ\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/inogicindia\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/\",\"name\":\"Tushar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Tushar\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#webpage\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/\",\"name\":\"Error \\u201cSub reports within table\\\/matrix cells are ignored\\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks\",\"description\":\"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/2009\\\/05\\\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/author\\\/inogic-2\\\/#author\"},\"datePublished\":\"2009-05-11T07:10:00+05:30\",\"dateModified\":\"2009-05-11T07:10:00+05:30\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/\",\"name\":\"Microsoft Dynamics 365 CRM Tips and Tricks\",\"alternateName\":\"Inogic\",\"description\":\"By Inogic\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.inogic.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Error \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks","description":"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report","canonical_url":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#blogposting","name":"Error \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks","headline":"Error &#8220;Sub reports within table\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel","author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"http:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#articleImage"},"datePublished":"2009-05-11T07:10:00+05:30","dateModified":"2009-05-11T07:10:00+05:30","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#webpage"},"isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#webpage"},"articleSection":"Dynamics CRM, SSRS Reports, Excel, Export"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.inogic.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/#listItem","name":"Dynamics CRM"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/#listItem","position":2,"name":"Dynamics CRM","item":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#listItem","name":"Error &#8220;Sub reports within table\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#listItem","position":3,"name":"Error &#8220;Sub reports within table\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel","previousItem":{"@type":"ListItem","@id":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/#listItem","name":"Dynamics CRM"}}]},{"@type":"Organization","@id":"https:\/\/www.inogic.com\/blog\/#organization","name":"Microsoft Dynamics 365 CRM Tips and Tricks","description":"By Inogic","url":"https:\/\/www.inogic.com\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/02\/inogic-logo.png","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#organizationLogo","width":1000,"height":325,"caption":"inogic logo"},"image":{"@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/inogicindia","https:\/\/twitter.com\/inogic","https:\/\/www.instagram.com\/inogicindia\/","https:\/\/www.youtube.com\/channel\/UCM4V7ousgLSu1hbOEv4DUuQ","https:\/\/www.linkedin.com\/company\/inogicindia"]},{"@type":"Person","@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author","url":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/","name":"Tushar","image":{"@type":"ImageObject","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/839d9ae7d2b941d2d09e91df322267a429821f2ce5494302b53bd5ca3679f1a0?s=96&d=mm&r=g","width":96,"height":96,"caption":"Tushar"}},{"@type":"WebPage","@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#webpage","url":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/","name":"Error \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks","description":"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.inogic.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/#breadcrumblist"},"author":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"creator":{"@id":"https:\/\/www.inogic.com\/blog\/author\/inogic-2\/#author"},"datePublished":"2009-05-11T07:10:00+05:30","dateModified":"2009-05-11T07:10:00+05:30"},{"@type":"WebSite","@id":"https:\/\/www.inogic.com\/blog\/#website","url":"https:\/\/www.inogic.com\/blog\/","name":"Microsoft Dynamics 365 CRM Tips and Tricks","alternateName":"Inogic","description":"By Inogic","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.inogic.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Microsoft Dynamics 365 CRM Tips and Tricks - By Inogic","og:type":"article","og:title":"Error \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks","og:description":"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report","og:url":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/","og:image":"https:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg","og:image:secure_url":"https:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg","article:published_time":"2009-05-11T01:40:00+00:00","article:modified_time":"2009-05-11T01:40:00+00:00","article:publisher":"https:\/\/www.facebook.com\/inogicindia","twitter:card":"summary_large_image","twitter:site":"@inogic","twitter:title":"Error \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel - Microsoft Dynamics 365 CRM Tips and Tricks","twitter:description":"If you make an SRS report that uses Data table and has sub-reports included, you will see the below error when the report is exported to Excel. Export to PDF format works just fine but when you export to Excel the excel file will not show the details included in the sub-report. Instead the sub-report","twitter:creator":"@inogic","twitter:image":"http:\/\/4.bp.blogspot.com\/_pMlyDuF-ngc\/SgfQXqnM4sI\/AAAAAAAAAD8\/REcv3VNdP4c\/s400\/rep.jpg","twitter:label1":"Written by","twitter:data1":"Tushar","twitter:label2":"Est. reading time","twitter:data2":"1 minute"},"aioseo_meta_data":{"post_id":"203","title":"","description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-02-02 05:51:55","updated":"2025-07-03 21:06:44","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/\" title=\"Dynamics CRM\">Dynamics CRM<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tError \u201cSub reports within table\/matrix cells are ignored\u201d when exporting SRS Reports to Excel\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.inogic.com\/blog"},{"label":"Dynamics CRM","link":"https:\/\/www.inogic.com\/blog\/category\/dynamics-crm\/"},{"label":"Error &#8220;Sub reports within table\/matrix cells are ignored&#8221; when exporting SRS Reports to Excel","link":"https:\/\/www.inogic.com\/blog\/2009\/05\/error-sub-reports-within-tablematrix-cells-are-ignored-when-exporting-srs-reports-to-excel\/"}],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=203"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/203\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}