BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Replacing Excel or similar as component?          BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (General) View previous topic :: View next topic   Author Message Roland Bengtsson Guest Posted: Wed Dec 28, 2005 6:12 pm    Post subject: Replacing Excel or similar as component? Background: I work for a transport company in a team as Delphi programmer. We developing a server/client software (Attracs). It has many features like planning/optimize routes, booking, reports etc. The reporting part can do reports in many different ways. The office asks us quite often for new reports, maybe some new data to include in a report or change the presentation of data. This creates a lot of work for us besides the usual job. Today all reports is exported to csv and then imported to Excel. The advantage with Excel is that it is easy to use and have pivot tables that is heavily used. Now Excel more and more is used like a database. Business grows and now if they want a detailed reports of all parcels in a year this creates more than 65536 rows and that can't Excel manage. Question: We searching some kind of Delphi component that could integrate reporting in Attracs. The user should be able to edit, add and delete columns of data in the report. It's an advantage if the feeling is similar to Excel as this is what they (the office) use now. Otherwise we may not convince them why they should leave Excel:) The costs is not a problem as long as it is normal prices. We have found "Business Objects" http://www.businessobjects.com that sounds promising but there is none that manage to find the time to try it out and evaluate it yet... What other options exists to integrate reports in an application? Back to top Eddie Shipman Guest Posted: Wed Dec 28, 2005 7:46 pm    Post subject: Re: Replacing Excel or similar as component? In article <op.s2h96gfhpnvs71 (AT) roland (DOT) adsl.multi.fi>, [email]roland.bengtssonsf (AT) home (DOT) se[/email] says... Quote: Background: I work for a transport company in a team as Delphi programmer. We developing a server/client software (Attracs). It has many features like planning/optimize routes, booking, reports etc. The reporting part can do reports in many different ways. The office asks us quite often for new reports, maybe some new data to include in a report or change the presentation of data. This creates a lot of work for us besides the usual job. Today all reports is exported to csv and then imported to Excel. The advantage with Excel is that it is easy to use and have pivot tables that is heavily used. Now Excel more and more is used like a database. Business grows and now if they want a detailed reports of all parcels in a year this creates more than 65536 rows and that can't Excel manage. Question: We searching some kind of Delphi component that could integrate reporting in Attracs. The user should be able to edit, add and delete columns of data in the report. It's an advantage if the feeling is similar to Excel as this is what they (the office) use now. Otherwise we may not convince them why they should leave Excel:) The costs is not a problem as long as it is normal prices. We have found "Business Objects" http://www.businessobjects.com that sounds promising but there is none that manage to find the time to try it out and evaluate it yet... Try the SheetView: http://www.bergsoftware.net/index.php?section=components&page=sheetview Back to top Herbert Sitz Guest Posted: Wed Dec 28, 2005 10:51 pm    Post subject: Re: Replacing Excel or similar as component? "Roland Bengtsson" <roland.bengtssonsf (AT) home (DOT) se> wrote Quote: Background: I work for a transport company in a team as Delphi programmer. We developing a server/client software (Attracs). It has many features like planning/optimize routes, booking, reports etc. The reporting part can do reports in many different ways. The office asks us quite often for new reports, maybe some new data to include in a report or change the presentation of data. This creates a lot of work for us besides the usual job. Today all reports is exported to csv and then imported to Excel. The advantage with Excel is that it is easy to use and have pivot tables that is heavily used. Now Excel more and more is used like a database. Business grows and now if they want a detailed reports of all parcels in a year this creates more than 65536 rows and that can't Excel manage. Question: We searching some kind of Delphi component that could integrate reporting in Attracs. The user should be able to edit, add and delete columns of data in the report. It's an advantage if the feeling is similar to Excel as this is what they (the office) use now. Otherwise we may not convince them why they should leave Excel:) The costs is not a problem as long as it is normal prices. We have found "Business Objects" http://www.businessobjects.com that sounds promising but there is none that manage to find the time to try it out and evaluate it yet... What other options exists to integrate reports in an application? If primary use is for reporting and use of Excel's Pivot Table functionality to let users modify things, then a VCL olap tool like PivotCube might be a good solution: http://www.pivotcube.com . The component is excellent and support is very good. other possibilities are (I think) contourcube and hiercube. I use Pivotcube and am very happy with it. Developer Express' Express Spreadsheet provides a lot of spreadsheet functionality, but doesn't provide the reporting capabilities that you can get with pivots of data in an olap tool. -- Herbert Sitz Back to top Olivier Beltrami Guest Posted: Thu Dec 29, 2005 3:24 pm    Post subject: Re: Replacing Excel or similar as component? Quote: Today all reports is exported to csv and then imported to Excel. The advantage with Excel is that it is easy to use and have pivot tables that is heavily used. Now Excel more and more is used like a database. Business grows and now if they want a detailed reports of all parcels in a year this creates more than 65536 rows and that can't Excel manage. In the upcoming version of Excel, that limitation is gone (according to PC Magazine, FWIW). Olivier Back to top Adrian Gallero Guest Posted: Thu Dec 29, 2005 6:38 pm    Post subject: Re: Replacing Excel or similar as component? Business grows and now if they want a detailed reports of Quote: all parcels in a year this creates more than 65536 rows and that can't Excel manage. In the upcoming version of Excel, that limitation is gone (according to PC Magazine, FWIW). http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx :) Back to top Mike Shkolnik Guest Posted: Fri Dec 30, 2005 2:07 pm    Post subject: Re: Replacing Excel or similar as component? Quote: What puzzles is why do they use 2.5 bytes (20 bits) for addressing instead of 3 (or even 4) bytes. Why not have 2M or 4M rows? Maybe another bits reserved for another information. Or maybe to release the new MS Excel v99 in 2099 and to announce 4M rows:-) -- With best regards, Mike Shkolnik EMail: [email]mshkolnik (AT) scalabium (DOT) com[/email] http://www.scalabium.com Back to top Zoran Guest Posted: Fri Dec 30, 2005 2:51 pm    Post subject: Re: Replacing Excel or similar as component? Quote: In the upcoming version of Excel, that limitation is gone (according to PC Magazine, FWIW). Olivier From msdn: The total number of available rows in Excel Old Limit: 64k (2^16) New Limit: 1M (2^20) What puzzles is why do they use 2.5 bytes (20 bits) for addressing instead of 3 (or even 4) bytes. Why not have 2M or 4M rows? Another puzzle (maybe just for me -- I am not an 'excel guy'): The maximum length of formulas (in characters) Old Limit: 1k characters New Limit: 8k characters If you cannot fit your formula within 1024 bytes, I think you need to redesign the spreadsheet and the logic. --- posted by geoForum on http://delphi.newswhat.com Back to top Zoran Guest Posted: Fri Dec 30, 2005 3:17 pm    Post subject: Re: Replacing Excel or similar as component? Quote: Maybe another bits reserved for another information. It would be like having a passanger seat built inside the engine of the racing car. Doesn't belong together... Quote: Or maybe to release the new MS Excel v99 in 2099 and to announce 4M rows:-) More likely. Then they can claim another victory in software development and raise the price by 200%. :) --- posted by geoForum on http://delphi.newswhat.com Back to top Mike Shkolnik Guest Posted: Fri Dec 30, 2005 9:50 pm    Post subject: Re: Replacing Excel or similar as component? Quote: Maybe another bits reserved for another information. It would be like having a passanger seat built inside the engine of the racing car. Doesn't belong together... The MS Excel and MS Word formats have a lot of such fields/tags where every bit have another meaning. -- With best regards, Mike Shkolnik E-mail: [email]mshkolnik (AT) scalabium (DOT) com[/email] WEB: http://www.scalabium.com Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (General) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.