index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP DataGrid

search this forum:

:: Downloading DataGrid to Xls with Blanks :: (7) Post a New Message | Post a Reply
Oct 25 2006, 8:32 AM	Downloading DataGrid to Xls with Blanks Post a Reply
hhme since: Oct 25, 2006 from: Grand Rapids, MI	I have just downloaded the new version of ASP Report wizard and now when I download my datagrid to an Excel file the blank fields in my database are not recognized and all the data in those rows are moved over. I have been using a earlier version for about 6 months with no problems. Any help would be greatly appreciated. Thanks Heather
Oct 25 2006, 2:23 PM	Re: Downloading DataGrid to Xls with Blanks Post a Reply
ghost from: Washington, DC	Download the latest version of the report wizard (v2.6.26) and add this property for the grid: objWiz.UseFastExport = True For more information check out the link below: http://aspwebsolution.com/forums/?tid=2137 ------------------------- Ghost
Oct 30 2006, 6:53 AM	Re: Downloading DataGrid to Xls with Blanks Post a Reply
hhme since: Oct 25, 2006 from: Grand Rapids, MI	I loaded the newest version and added the new line of code and I didn't add the new line of code and I get this error. Any ideas? Thanks for the help Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /schedule/Reports/rptEngrBodyProjectRW.asp, line 42 The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
Oct 30 2006, 9:51 AM	Re: Downloading DataGrid to Xls with Blanks Post a Reply
ghost from: Washington, DC	Make sure that the Everyone or your computer account (e.g. IUSR_computer name/IUSR_computer name) has permissions to access the AWSReportWizard.dll file. ------------------------- Ghost
Oct 30 2006, 10:25 AM	Re: Downloading DataGrid to Xls with Blanks Post a Reply
hhme since: Oct 25, 2006 from: Grand Rapids, MI	Thanks for the help on the security, but I am still having the original problem. If I have a blank or NULL field in the DB, when I export to Excel the blank field is left out and the next field will replace that column. Resulting in data from different fields in one column. Let me know if you need more explanation Thanks
Oct 30 2006, 12:17 PM	Re: Downloading DataGrid to Xls with Blanks Post a Reply
ghost from: Washington, DC	Make sure you declare the property before you create your db connection. e.g. objGrid.UseFastExport = True objGrid.CreateConnection(Your connection string) ------------------------- Ghost
Oct 31 2006, 6:55 AM	Re: Downloading DataGrid to Xls with Blanks Post a Reply
hhme since: Oct 25, 2006 from: Grand Rapids, MI	Great!! That works thanks so much for your help. Happy Halloween!!
Pages: (1)   [1]

search this forum: