tag:blogger.com,1999:blog-2437651727370625818.post2071612842284033624..comments2023-11-25T00:44:31.814-08:00Comments on Ram's Blog: SSRS 2012BI_Buffhttp://www.blogger.com/profile/06254495164438608712noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2437651727370625818.post-57746158059451767902013-03-06T12:51:42.182-08:002013-03-06T12:51:42.182-08:00Hi Reeba,
Try exporting the data to a csv file for...Hi Reeba,<br />Try exporting the data to a csv file format and see if you can export the data.<br />Second option is try exporting a limited number of rows say 5000 to excel and see if that works. If not try reinstalling excel 2007 or excel 2010.BI_Buffhttps://www.blogger.com/profile/06254495164438608712noreply@blogger.comtag:blogger.com,1999:blog-2437651727370625818.post-33452179457637598322013-03-06T06:51:03.868-08:002013-03-06T06:51:03.868-08:00Hi Ram,
I am using SSRS 2008R2. My issue is I hav...Hi Ram,<br /><br />I am using SSRS 2008R2. My issue is I have a large report that I am trying to export to excel. But I keep getting the "Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 68563, Max Rows: 65536 (rrRenderingError) ---> ".Is there something I need to do to get around this problem. The excel I am trying to export it to is excel 2007.<br /><br />Thanks<br />ReebaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2437651727370625818.post-75182791751537650382012-07-09T07:06:41.884-07:002012-07-09T07:06:41.884-07:00Hi sivaram,
Are you using a stored procedure in yo...Hi sivaram,<br />Are you using a stored procedure in your dataset or is it a sql statement. In case of a sql statement in the Where clause you need use a IN clause for example:<br />It would be WHERE productype IN [@producttype], @producttype would be the report parameter. Let me know, my personal email id is ramdas.jaya@gmail.comBI_Buffhttps://www.blogger.com/profile/06254495164438608712noreply@blogger.comtag:blogger.com,1999:blog-2437651727370625818.post-62331581123319294032012-07-09T00:01:15.387-07:002012-07-09T00:01:15.387-07:00Hi ram
i want to know how to pass multi val...Hi ram<br /> i want to know how to pass multi value parameters to ssrs 2005 using mysql ODBC<br /><br />Single value is working,iam used this function in dataset<br /><br />=JOIN(Parameters!course_code.value,",")<br /><br />How can i pass multi value parameters <br />please tell me<br /><br />Thanks in advance<br />SrujitharamAnonymoushttps://www.blogger.com/profile/11366512689747938743noreply@blogger.com