I have created a dynamic survey with lots of logic. I need to create reports however when I export to Excel, the order of the questions are jumbled up. Can I create a view that will provide all responses in the order of the questions? Can I have another view of the reports versus the bar graphs with percentages? Help, I need creative ways to display thsi information in order

Hi, You can access the SharePoint List data via the use of web services http://<Site>/_vti_bin/Lists.asmx Additionally, you can use SQL Server Reporting Services for your report design needs. hth,Chirag Patel, MCTS techChirag.com @techChirag

> Additionally, you can use SQL Server Reporting Services for your report design needs. Or connect to Access 2007 (create a sync'ed table from the SP List) and use its reporting functions. (Easier than Reporting Services if you have Access available - but less distributable.)SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters

Hi AJenk, You can create an Access View just as Mike said, and create an access report by follow steps: 1. Go to that survey > Settings. 2. Change the URL http://server:port/_layouts/survedit.aspx?List=%7BC79948B7%2D0CBD%2D481D%2DB55E%2DE2DD9731329F%7D to http://server:port/_layouts/ViewType.aspx?List=%7BC79948B7%2D0CBD%2D481D%2DB55E%2DE2DD9731329F%7D 3. Select to create an Access view. 4. You can create a report in Access. Refer to Create a simple report with Access 2007. Best regards, Emir