http://www.programmersheaven.com/ Contains the latest posts from the thread 'Realize remote design with web-based reporting tool' posted on the 'WEB Servers' forum at Programmer's Heaven. en Copyright 2009 Programmers Heaven Fri, 20 Nov 2009 20:30:40 -0700 Fri, 20 Nov 2009 20:30:40 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/other-web-servers/393714/393714/realize-remote-design-with-web-based-reporting-tool/ <strong><span style="font-size: large;">Background</span></strong><br /> <strong>With the popularity of B/S application, users want to do report design at browser side with web-based reporting tool.</strong> They would like to link database and design report template at browser. Moreover, they wish to deploy template to server and browse their designed report on line too.<br /> <br /> <strong><span style="font-size: large;">Difficulty</span></strong><br /> <strong>1. Link database.</strong> For the consideration of security, browser side can’t link database directly with jdbc or odbc. As a result, there must be a long distance data server. This server is used to receive data access request from long distance user, send the request to database, and transmit processing result back to user.<br /> <br /> <strong>2. Set the access authority of report template on server.</strong> Users should be able to access, modify and save the report template on server. However, some other files on server aren’t allowed to be modified. Therefore, there must be a file server, which is used to determine which files are accessible, and which users are allowed to access them.<br /> <br /> <strong>3. Remote design is provided for business personnel, so the interface must be user-friendly.</strong> Users should be able to do remote design by just drag and drop. Therefore, the semantic layer must support complex functions like generate parameters, expressions, display formats automatically.<br /> <br /> <strong><span style="font-size: large;">Solution</span></strong><br /> As a professional web-based reporting tool, RAQ Report spends a lot of time and money on this problem. At last, a wonderful solution is worked out by the prominent developers of RAQ Report. With it, users can realize remote design with ease/<br /> <br /> <strong><span style="font-size: large;">Operation</span></strong><br /> 1. Delpoy remote design server.<br /> 2. Download client-side and start remote designer.<br /> 3. Log in long distance server.<br /> 4. Link long distance data server and file server.<br /> 5. Design, preview and save report.<br /> <br /> <strong><span style="font-size: large;">Graphic Illustration</span></strong><br /> <img src="http://www.raqsoft.com/know-how/wp-content/uploads/2009/04/126.jpg" /><br /> <br /> This post is from <a href="http://freezea.blogspot.com/">freezea's blog</a>. You are welcomed cc it anywhere, and please indicate the source.<br /> <br /> If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.<br /> http://www.programmersheaven.com/mb/other-web-servers/393714/393714/realize-remote-design-with-web-based-reporting-tool/ Wed, 15 Jul 2009 10:04:14 -0700 WEB Servers