exporting error

attached is the error msg that display everytime i export the informations generated by CR v8.5 to excel file. i thought the reason for the error msg is the consumption of the 65T rows allowed in excel because when i export the report having much fewer informations (retrieve the same report in the short period of time), the exportation was successul.

On the other hand, when i tried the previous report version, any exportation was successful even when the retrieval arguments in date range is 3 months.

Please help mei have known the cause of this error, this is due to the subreport i inserted so i just editted the report and delete the sub report. on the other hand, can anyone help me why does the error occur? is it a bug of the CR 8.5? F.Y.I the CR report is directly retrieve in a server... H.E.L.Psql

export to cvs/excel with comments attached

i'm building a web page to help our support staff run and export their sql queries faster and more easily than going through the sql server manager. i found an article at codeproject [1] that i was able to customize to be more flexible, but i'm not sure how to get it to export the results of a query along with the comments that preceed the query.

for example, i have the following sql file:

-- this query does a certain thing, and the comment can be pretty long at times, depending on how complicated the query isselect *from table where columnid > 100

would anyone be able to tell me how to edit Kolluri's export function to allow for a comment section? alternatively if his way of doing an export is out of date, i'd be interested in a newer way. most importantly, though, i need to be able to export the comments along with query results.

my ultimate goal is to have a drop down list of databases on the server, a list of query files (from a certain consolodated folder) for them to run on the chosen database, a "test query" function, and an export function that exports the comments and results.

[1] http://www.codeproject.com/aspnet/ExportClassLibrary.asp

if i'm going about this all wrong, i don't mind changing directions. :)

what i'm really trying to do is allow our support staff to speed up their query running. currently they have a folder of txt and sql files that they need to run on a certain database (which is different for different support staff). right now they open one of these txt/sql files, open sql studio, copy the query from the txt/sql, paste it into sql studio, run the query, export the results, open the results, and paste the query into the exported results file. rinse and repeat for every txt/sql file in the folder, which is time consuming and ridiculous.

this seems very repetitive and i was hoping to help them out by allowing them to go to a web page, select one or more queries from a list, pick which database they need to connect to, and i'd loop through all those queries and run them with the support staff having to only click one button to start that process. i've got almost every part of this plan working except being able to put the query in comments at the top of the exported file, but if i need to change my entire game plan to allow that, i'm willing. having the query at the top of the exported results is very important, and if i can't get this working, my whole web page is a bust.