Rendered Worksheet Only Displays First Row

Aspose.Cells Product Family
1

Hello,

When Reporting Server renders a report designed in Aspose Cells only the top row of the query is returned, on this particular report 100 rows should be returned. Any suggestions?

Thanks,

Joe

Here is the report code:

<?xml version="1.0" encoding="utf-8"?>
http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">


14cfd92c-0958-4934-a963-68d1bbeeaa88
PRODDB01


11in
true
8.5in
true
1in
1in
1in
3d406afb-bc74-4169-933f-93a52e96c38a




Contact_ID
System.Int32


Created_By
System.Int32


Date_Created
System.DateTime


Updated_By
System.Int32


Date_Updated
System.DateTime


Origin_ID
System.Int32


UUID
System.String



PRODDB01
SELECT TOP (100) Contact_ID, Created_By, Date_Created, Updated_By, Date_Updated, Origin_ID, UUID
FROM SRI_Contact.dbo.Contact



Aspose
9.5in



64pt
6
20pt
=First(Fields!Contact_ID.Value,"contacts")


64pt
5
64pt
20pt
=First(Fields!Created_By.Value,"contacts")


64pt
4
128pt
20pt
=First(Fields!Date_Created.Value,"contacts")


64pt
3
192pt
20pt
=First(Fields!Updated_By.Value,"contacts")


64pt
2
256pt
20pt
=First(Fields!Date_Updated.Value,"contacts")


64pt
1
320pt
20pt
=First(Fields!Origin_ID.Value,"contacts")


64pt
384pt
20pt
=First(Fields!UUID.Value,"contacts")


60pt



EXCEL_TEMPLATE
UEsDBBQABgAIAAAAIQBxDjkrcAEAAKAFAAATANsBW0NvbnRlbnRfVHlwZXNdLnhtbCCi1wEooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADMlE1OwzAQhfdI3CHyFiVui4QQatoFP0uoBBzA2JPGqmNbHre0t2eS0ApQiFTSBZtEUTTvvflm7Ol8W5lkAwG1szkbZyOWgJVOabvM2evLQ3rNEozCKmGchZztANl8dn42fdl5wISqLeasjNHfcI6yhEpg5jxY+lO4UIlIn2HJvZArsQQ+GY2uuHQ2go1prDXYbPpEAYJWkCxEiI+iIh++NTySGrTPcUZ6LLltC2vvnAnvjZYiUnK+seqHa+qKQktQTq4r8soasYtahf9qiHFnAAdboQ8gFJYAsTJZK7p3voNCrE1M7rdEoIUewOBxrX3CzKiyaR9L7bHHoZ9dP5N3F1Zvzq1OTaWmk1VC233uriWg6S2C88hp1oMDQI1cgUo9SUKIGg7MurxpAevemzEib16TwRm+r8ZBv49BR47Lf5Jj+Kn8Gw8sRQD1HAPdUic/rl+1++Zy2E3pAhw/kP0Zrqs7NpI39+vsAwAA//8DAFBLAwQUAAYACAAAACEAtVUwI/UAAABMAgAACwDOAV9yZWxzLy5yZWxzIKLKASigAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAjJLPTsMwDMbvSLxD5PvqbkgIoaW7TEi7IVQewCTuH7WNoyRA9/aEA4JKY9vR9ufPP1ve7uZpVB8cYi9Ow7ooQbEzYnvXanitn1YPoGIiZ2kUxxqOHGFX3d5sX3iklJti1/uosouLGrqU/CNiNB1PFAvx7HKlkTBRymFo0ZMZqGXclOU9hr8eUC081cFqCAd7B6o++jz5src0TW94L+Z9YpdOjECeEzvLduVDZgupz9uomkLLSYMV85zTEcn7ImMDnibaXE/0/7Y4cSJLidBI4PM834pzQOvrgS6faKn4vc484qeE4U1k+GHBxQ9UXwAAAP//AwBQSwMEFAAGAAgAAAAhAN4J/SgCAQAA1AMAABoACAF4bC9fcmVscy93b3JrYm9vay54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAALyTz2rDMAzG74O9g9F9cZJuZZQ6vYxBr1v3ACZR4tDENpb2J28/k0O6QMkuoReDJPx9P9Cn/eGn78QXBmqdVZAlKQi0pata2yj4OL0+PIMg1rbSnbOoYECCQ3F/t3/DTnP8RKb1JKKKJQWG2e+kpNJgrylxHm2c1C70mmMZGul1edYNyjxNtzL81YBipimOlYJwrDYgToOPzv9ru7puS3xx5WePlq9YyG8XzmQQOYrq0CArmFokx8kmicQgr8PkN4bJl2CyG8NkSzDbNWHI6IDVO4eYQrqsatZegnlaFYaHLoZ+CgyN9ZL945r2HE8JL+5jKcd32oec3WLxCwAA//8DAFBLAwQUAAYACAAAACEA9h5CKF4BAABxAgAADwAAAHhsL3dvcmtib29rLnhtbIxS0U7CMBR9N/Efmr7LtsKAEDYSo0ZejIkIz3W9Yw1du7Sdg7/3dguI0Qef7r29Z6fnnG65OtaKfIJ10uiMJqOYEtCFEVLvM/q+ebqbU+I814IroyGjJ3B0ld/eLDtjDx/GHAgSaJfRyvtmEUWuqKDmbmQa0Lgpja25x9HuI9dY4MJVAL5WEYvjaVRzqenAsLD/4TBlKQt4MEVbg/YDiQXFPcp3lWwczZelVLAdHBHeNC+8Rt1HRYnizj8K6UFkdIKj6eDHgW2b+1aqsE3jlEb5xeSrJQJK3iq/QXtndsyLTRibBmSIYiuhc98fhZEcd1IL02WUTTDa03lKUkq6frOTwldhPWMIGM6eQe4rH+jnaa8juqLvA8Rr+kp07+4thJrgS4W6RgPY24XExq5FEvT9QrMrNPYXNPsTPb5CY39BjwM66slRUsFVgVGF0otg6YwN+s9/S/4FAAD//wMAUEsDBBQABgAIAAAAIQDppiW4ggYAAFMbAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbOxZT2/bNhS/D9h3IHRvbSe2Gwd1itixm61NG8Ruhx5pmZZYU6JA0kl9G9rjgAHDumGXAbvtMGwr0AK7dJ8mW4etA/oV9khKshjLS9IGG9bVh0Qif3z/3+MjdfXag4ihQyIk5XHbq12ueojEPh/TOGh7d4b9SxsekgrHY8x4TNrenEjv2tb7713FmyokEUGwPpabuO2FSiWblYr0YRjLyzwhMcxNuIiwglcRVMYCHwHdiFXWqtVmJcI09lCMIyB7ezKhPkFDTdLbyoj3GLzGSuoBn4mBJk2cFQY7ntY0Qs5llwl0iFnbAz5jfjQkD5SHGJYKJtpe1fy8ytbVCt5MFzG1Ym1hXd/80nXpgvF0zfAUwShnWuvXW1d2cvoGwNQyrtfrdXu1nJ4BYN8HTa0sRZr1/katk9EsgOzjMu1utVGtu/gC/fUlmVudTqfRSmWxRA3IPtaX8BvVZn17zcEbkMU3lvD1zna323TwBmTxzSV8/0qrWXfxBhQyGk+X0Nqh/X5KPYdMONsthW8AfKOawhcoiIY8ujSLCY/VqliL8H0u+gDQQIYVjZGaJ2SCfYjiLo5GgmLNAG8SXJixQ75cGtK8kPQFTVTb+zDBkBELeq+ef//q+VP06vmT44fPjh/+dPzo0fHDHy0tZ+EujoPiwpfffvbn1x+jP55+8/LxF+V4WcT/+sMnv/z8eTkQMmgh0Ysvn/z27MmLrz79/bvHJfBtgUdF+JBGRKJb5Agd8Ah0M4ZxJScjcb4VwxBTZwUOgXYJ6Z4KHeCtOWZluA5xjXdXQPEoA16f3XdkHYRipmgJ5xth5AD3OGcdLkoNcEPzKlh4OIuDcuZiVsQdYHxYxruLY8e1vVkCVTMLSsf23ZA4Yu4zHCsckJgopOf4lJAS7e5R6th1j/qCSz5R6B5FHUxLTTKkIyeQFot2aQR+mZfpDK52bLN3F3U4K9N6hxy6SEgIzEqEHxLmmPE6nikclZEc4ogVDX4Tq7BMyMFc+EVcTyrwdEAYR70xkbJszW0B+hacfgNDvSp1+x6bRy5SKDoto3kTc15E7vBpN8RRUoYd0DgsYj+QUwhRjPa5KoPvcTdD9Dv4Accr3X2XEsfdpxeCOzRwRFoEiJ6ZCe1LKNRO/Y1o/HfFmFGoxjYG3hXjtrcNW1NZSuyeKMGrcP/BwruDZ/E+gVhf3nje1d13ddd76+vuqlw+a7VdFFiovbp5sH2x6ZKjlU3yhDI2UHNGbkrTJ0vYLMZ9GNTrzAGR5IemJITHtLg7uEBgswYJrj6iKhyEOIEeu+ZpIoFMSQcSJVzC2c4Ml9LWeOjTlT0ZNvSZwdYDidUeH9vhdT2cHQ1yMmbLCcz5M2O0rgmcldn6lZQoqP06zGpaqDNzqxnRTKlzuOUqgw+XVYPB3JrQhSDoXcDKTTiia9ZwNsGMjLXd7QacucV44SJdJEM8JqmPtN7LPqoZJ2WxYi4DIHZKfKTPeadYrcCtpcm+AbezOKnIrr6CXea9N/FSFsELL+m8PZGOLC4mJ4vRUdtrNdYaHvJx0vYmcKyFxygBr0vd+GEWwN2Qr4QN+1OT2WT5wputTDE3CWpwU2HtvqSwUwcSIdUOlqENDTOVhgCLNScr/1oDzHpRCthIfw0p1jcgGP41KcCOrmvJZEJ8VXR2YUTbzr6mpZTPFBGDcHyERmwmDjC4X4cq6DOmEm4nTEXQL3CVpq1tptzinCZd8QLL4Ow4ZkmI03KrUzTLZAs3eZzLYN4K4oFupbIb5c6vikn5C1KlGMb/M1X0fgLXBetj7QEfbnIFRjpf2x4XKuRQhZKQ+n0BjYOpHRAtcB0L0xBUcJ9s/gtyqP/bnLM0TFrDqU8d0AAJCvuRCgUh+1CWTPSdQqyW7l2WJEsJmYgqiCsTK/aIHBI21DWwqfd2D4UQ6qaapGXA4E7Gn/ueZtAo0E1OMd+cGpLvvTYH/unOxyYzKOXWYdPQZPbPRSzZVe16szzbe4uK6IlFm1XPsgKYFbaCVpr2rynCObdaW7GWNF5rZMKBF5c1hsG8IUrg0gfpP7D/UeEz+3FCb6hDfgC1FcG3Bk0Mwgai+pJtPJAukHZwBI2THbTBpElZ06atk7ZatllfcKeb8z1hbC3ZWfx9TmPnzZnLzsnFizR2amHH1nZspanBsydTFIYm2UHGOMZ81Sp+eOKj++DoHbjinzElTTDBZyWBofUcmDyA5LcczdKtvwAAAP//AwBQSwMEFAAGAAgAAAAhALhKSy0TAQAAtwEAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWyMUMFKxDAQvQv+Q5i7TVdZlaXtIiyLHgQR9Z5tJ23YJBOSWVf/3rRlF8GLt3l5b17mvWr95az4xJgM+RoWRQkCfUud8X0N72/bq3sQiZXvlCWPNXxjgnVzeVEdKe7TgMgiO/hUw8AcVlKmdkCnUkEBfWY0Rac4w9jLFCKqblpyVl6X5a10yniYHVbxPx6ktWlxQ+3BoefZJKJVnO9PgwkJmqozmRsDiYi6hocFyKaavv0weEy/ZjGm2BHtR+Kpq6EcpfKPdjuleImiQ60Oll/p+IimHzhXtjy7bxSrvB5Uj88q9sYnYVFnTVncgYizfpqZwvS6BLEjZnInNOSCMBdRFjcgNBGfwHjWufLmBwAA//8DAFBLAwQUAAYACAAAACEAuEpLLRMBAAC3AQAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQzLnhtbIxQwUrEMBC9C/5DmLtNV1mVpe0iLIseBBH1nm0nbdgkE5JZV//etGUXwYu3eXlvXua9av3lrPjEmAz5GhZFCQJ9S53xfQ3vb9urexCJle+UJY81fGOCdXN5UR0p7tOAyCI7+FTDwBxWUqZ2QKdSQQF9ZjRFpzjD2MsUIqpuWnJWXpflrXTKeJgdVvE/HqS1aXFD7cGh59kkolWc70+DCQmaqjOZGwOJiLqGhwXIppq+/TB4TL9mMabYEe1H4qmroRyl8o92O6V4iaJDrQ6WX+n4iKYfOFe2PLtvFKu8HlSPzyr2xidhUWdNWdyBiLN+mpnC9LoEsSNmcic05IIwF1EWNyA0EZ/AeNa58uYHAAD//wMAUEsDBBQABgAIAAAAIQBd7Qs12QAAALwBAAAUAAAAeGwvc2hhcmVkU3RyaW5ncy54bWyUkEFLxDAQhe+C/yHk4M1N14OKm2RhuwievNhzCc3YBppJzEzF/fdGVsGDULzNY755w3t6/xFn8Q6FQkIjt5tGCsAh+YCjkd3L4/W9FMQOvZsTgpEnILm3lxeaiEW9RTJyYs4PStEwQXS0SRmwbl5TiY6rLKOiXMB5mgA4zuqmaW5VdAGlGNKCbOSdFAuGtwXaH201BavZXrmYd2ZIyG6oZu156J+OWrHV6gv6G6wPGXx/OK2Ax4r17ZleQbvs/+H5Ta94PpcwBlzP03W/I6vavv0EAAD//wMAUEsDBBQABgAIAAAAIQCgg8SuowEAAGQDAAANAAAAeGwvc3R5bGVzLnhtbKRTwWrcMBC9F/IPQvdGuwsNbbGdQ2EhkJRAttCrbMlewWhkpPGy7tdnZDve3VMOvVhPTzNvnmbk4vHsQZxsTC5gKbf3GyksNsE47Er557D/+l2KRBqNhoC2lKNN8rG6+1IkGsG+Ha0lwRKYSnkk6n8qlZqj9Trdh94in7Qhek28jZ1KfbTapJzkQe02mwfltUNZFW1ASqIJAxK7WIiqSP/ESQMzW6mqogkQoiCWZyMTg9rbOeKXBldHl8Na7R2MM73LxORoifMOQ8ykyiWXJXGSA1gN7LIBJqqi10Q24p43YsGHsefyyN2YZaa4T6K7qMft7ttVgpoKVkUdouHuX199pqoCbEtsNLrumFcKPX/rQBQ8A+N0F1ADQ/WRsQC+TmMB3vKE/rY32udW4OD3np5MKXnWuQkfkC+ywFlv3mT9a7VZ+79lxbm91WfFK9s3ptfyIs+7lL/zkwK5Soh6cEAObwWn67OmOV9asMkTIF3zy83NWatwJ4xt9QB0WA9LecEv1rjB/1ijXt0p0CRRygt+zpPaPkxTTuvvUb0DAAD//wMAUEsDBBQABgAIAAAAIQDtUd8shAEAAOgCAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sjJJNT8MwDIbvSPyHKHeWFthAU1sEjAEHJMTXPWvdNiKNS2I2+Pe4HRvtjZvtJ/Frv0ly8dVYsQYfDLpUxpNICnA5FsZVqXx9WR6dSxFIu0JbdJDKbwjyIjs8SDbo30MNQII7uJDKmqidKxXyGhodJtiCY1KibzRx6isVWg+66C81Vh1H0Uw12ji57TD3/+mBZWlyWGD+2YCjbRMPVhPPH2rTBpklhWHWLSQ8lKm8jOe3sVRZ0iu/GdiEQSxIr57BQk5QsAFSdIutEN+7g/dcirhj6A90HXVOZg3XYG0qb2bszUevwSELqL3CMN6pLXsrHr0ooNSflp5wcwemqollp/v5Fpp0lnjcCPaDxwmt7tyN52c8R94VL7nKd7pN11mUqDWL5b/sasjiMbsesuMxWwzZyZjdDNnpmC2HbDpmbPrfnLM9U7zbzp7tsq2u4EH7yrggLJS8WzQ5k8JvveljwravTqVYIRE2u6zmHwVsSjQ5kaJEpF3SPcf+j2Y/AAAA//8DAFBLAwQUAAYACAAAACEAQyme1EABAABjAgAAEQAIAWRvY1Byb3BzL2NvcmUueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlJJdS8MwGIXvBf9DyX2bZvVjhrYDlV2IA8GJ4l1I3m3F5oMk2vXfm7ZbrcwbL/OekyfnvCRf7GUdfYF1lVYFIkmKIlBci0ptC/SyXsZzFDnPlGC1VlCgFhxalOdnOTeUawtPVhuwvgIXBZJylJsC7bw3FGPHdyCZS4JDBXGjrWQ+HO0WG8Y/2BbwLE2vsATPBPMMd8DYjER0QAo+Is2nrXuA4BhqkKC8wyQh+MfrwUr354VemThl5VsTOh3iTtmCD+Lo3rtqNDZNkzRZHyPkJ/ht9fjcV40r1e2KAypzwSm3wLy25YOG6AmsbXM8mXYbrJnzq7DsTQXitp0aT8VA7AsMWBBRiESHAkflNbu7Xy9RGVLN4/Qynl2vyQ0lGZ2R9+7tX/e7iMNAHhL8h5hdTIhHQJnjk29RfgMAAP//AwBQSwMEFAAGAAgAAAAhALb9vgWjAQAAWgMAABAACAFkb2NQcm9wcy9hcHAueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAnJPfa9swEMffB/0fhJ7XyEnLGEFWGWlHBx0LOO2eVfkci9qSkK4m2V+/s40bZz9eqqfTfY8vH92d5M2hbVgHMVnvcr5cZJyBM760bp/zx93Xy8+cJdSu1I13kPMjJH6jLj7IbfQBIlpIjCxcynmNGNZCJFNDq9OCZEdK5WOrka5xL3xVWQO33ry24FCssuyTgAOCK6G8DG+GfHRcd/he09Kbni897Y6BgJX8EkJjjUZ6pfpuTfTJV8juDgYaKeaiJLoCzGu0eFSZFPOrLIxuYEPGqtJNAilOCXkPum/aVtuYlOxw3YFBH1myv6htK86edYIeJ+edjlY7JKy+bLwMcRMSRvXTx5dUA2CSggrG5BDOa+exvVZXQwEF54W9wQhCwjnizmID6Ue11RH/QXw1Jx4YRt4Rp+j5lnO+N9JBWv1fGknnrxoaRXx/EG18G7Q7qgI6cGzjo6M1/ci+ObOQYhLlg3Uv6THs/K1GmOZynpRFrSOUNMpJPyXkPY0kNr3JptZuD+VU87fQb9HT+FXUcrXI6AzLM+WkOH0K9RsAAP//AwBQSwECLQAUAAYACAAAACEAcQ45K3ABAACgBQAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQC1VTAj9QAAAEwCAAALAAAAAAAAAAAAAAAAAHwDAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQDeCf0oAgEAANQDAAAaAAAAAAAAAAAAAAAAAGgGAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc1BLAQItABQABgAIAAAAIQD2HkIoXgEAAHECAAAPAAAAAAAAAAAAAAAAAKoIAAB4bC93b3JrYm9vay54bWxQSwECLQAUAAYACAAAACEA6aYluIIGAABTGwAAEwAAAAAAAAAAAAAAAAA1CgAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQItABQABgAIAAAAIQC4SkstEwEAALcBAAAYAAAAAAAAAAAAAAAAAOgQAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWxQSwECLQAUAAYACAAAACEAuEpLLRMBAAC3AQAAGAAAAAAAAAAAAAAAAAAxEgAAeGwvd29ya3NoZWV0cy9zaGVldDMueG1sUEsBAi0AFAAGAAgAAAAhAF3tCzXZAAAAvAEAABQAAAAAAAAAAAAAAAAAehMAAHhsL3NoYXJlZFN0cmluZ3MueG1sUEsBAi0AFAAGAAgAAAAhAKCDxK6jAQAAZAMAAA0AAAAAAAAAAAAAAAAAhRQAAHhsL3N0eWxlcy54bWxQSwECLQAUAAYACAAAACEA7VHfLIQBAADoAgAAGAAAAAAAAAAAAAAAAABTFgAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAi0AFAAGAAgAAAAhAEMpntRAAQAAYwIAABEAAAAAAAAAAAAAAAAADRgAAGRvY1Byb3BzL2NvcmUueG1sUEsBAi0AFAAGAAgAAAAhALb9vgWjAQAAWgMAABAAAAAAAAAAAAAAAAAAhBoAAGRvY1Byb3BzL2FwcC54bWxQSwUGAAAAAAwADAAMAwAAXR0AAAAA


REPORT_CONFIG
PD94bWwgdmVyc2lvbj0iMS4wIj8+CjxDb25maWc+CjwvQ29uZmlnPg==


1in

2

hi joe,

I checked your rdl file.

I found you did not complete report design. If you need to return multitudinous rows of data , you should design the table item.

Please try check attachment

Based on your report form ,you should do following operations

1. Click Set Attribute.

Set report name ,report range and so on.

2. Set Group or Set Footer.

If you only need a summary , you may set footer and not to set group .

3. Save report and publish report.

Reference to:
http://www.aspose.com/documentation/ssrs-rendering-extensions/aspose.cells-for-reporting-services/creating-tabular-report.html

3

I am trying this as well - my last cell contains a simple formula - and whenever I set the attribute, it fails - saying type mismatch and I have to shut down Excel - and the file cannot be saved in that session?

4

OK - I found an example of using a formula as such: &=&=D{r}*E{r}

However - for a tabular report - do I have to always reserve the first column, to the left of the table for a grouper or a footer?

5

Hi Travis,

We have checked the issues. Aspose.Cells for Reporting Services can support the feature that the left of the table for a grouper or a footer. Please see the attached file.

Thanks,