BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Report generation          BorlandTalk.com Forum Index -> C++ Builder (Non-Technical) View previous topic :: View next topic   Author Message Simon Elliott Guest Posted: Thu Apr 22, 2004 2:31 pm    Post subject: Report generation Not sure what the correct group is for this set of topics, so apologies in advance for dumping it into non-technical. I have a data logging application which takes data from custom hardware and writes it to an MS Access database via ADO. Because it uses ADO, there doesn't need to be a copy of MS Access on the target PC. Users with MS Access can generate reports on the database. Now I want to generate a few reports from the data logging application, mostly to give the users confidence that real data is being added to the database. The reports will only be generated while data logging is paused, so there won't be any locking or consistency issues. My copy of BCB6 has the qreport components, but I'm sure someone here said that they were, um, not very good. What do people currently use for database reporting? Do developers think that qreport is good enough for a very basic set of reports? -- Simon Elliott http://www.ctsn.co.uk/ Back to top Benjamin Pratt Guest Posted: Thu Apr 22, 2004 4:49 pm    Post subject: Re: Report generation I recently needed to create reports from Access/ADO in a BCB app. Reporting tools like QReport were new to me, so I looked into a few. QReport has a few advantages, A) it's cheap, B) it's VCL. Other reporting software appeared to be more feature rich and well supported, however, I wasn't looking for anything fancy and decided to just stick with QReport. I found that creating the reports was straightforward. The help is a little outdated, but gets you going pretty quickly. And the reports look nice. There were problems of course. The biggest problem was that if you want to do anything even slightly out of the ordinary, be prepared to spend some time figuring out how. For example, I wanted the reports to be displayed in a page control, where each report was contained in a seperate page. You could view each report by selecting the appropriate tab. Well QReport only has direct support for viewing reports in a 'Preview' dialog. Doing anything else is undoumented and requires much experimentation. Overall, I am happy with QReport for the simple reporting that I needed to do. If you don't expect too much, you won't be disappointed ;) Back to top Frank Gruber Guest Posted: Thu Apr 22, 2004 6:16 pm    Post subject: Re: Report generation After fighting with QP I switched to FastReport and I'm still convinced of it's quality. Additionally it is quite cheap. Regard's Frank. Back to top Simon Elliott Guest Posted: Fri Apr 23, 2004 10:02 am    Post subject: Re: Report generation Benjamin Pratt <benjamin.pratt.getridofthis (AT) verizon (DOT) net> writes Quote: There were problems of course. The biggest problem was that if you want to do anything even slightly out of the ordinary, be prepared to spend some time figuring out how. I may have hit my first snag already. I made a test application, dropped a TADOConnection and a TADOQuery, and made a report. The report preview at design time shows only a single record from my query. Is this a feature of the design time preview, or am I going wrong somewhere? -- Simon Elliott http://www.ctsn.co.uk/ Back to top Vladimir Stefanovic Guest Posted: Fri Apr 23, 2004 2:21 pm    Post subject: Re: Report generation Quote: After fighting with QP I switched to FastReport and I'm still convinced of it's quality. Additionally it is quite cheap. I agree. In the QR you cannot add a simple picture on the form and be sure that it will be printed correctly (with the version shipped with BCB) Reporting is the final and mainly the most important phase in my apps. And if it fails to print - why I made my app at all. Vladimir. Back to top Benjamin Pratt Guest Posted: Fri Apr 23, 2004 6:03 pm    Post subject: Re: Report generation Quote: I may have hit my first snag already. I made a test application, dropped a TADOConnection and a TADOQuery, and made a report. The report preview at design time shows only a single record from my query. Is this a feature of the design time preview, or am I going wrong somewhere? at design time, only one detail band will display, even though several may appear during run time. You can right-click the report and choose preview to see what it will really look like, provided the data connection is active and populated. Back to top Simon Elliott Guest Posted: Wed May 19, 2004 9:18 am    Post subject: Re: Report generation On 23/04/2004, Vladimir Stefanovic wrote: Quote: I agree. In the QR you cannot add a simple picture on the form and be sure that it will be printed correctly (with the version shipped with BCB) Reporting is the final and mainly the most important phase in my apps. And if it fails to print - why I made my app at all. Is there any wizard in QR for generating the basic report layout from the database fields? I can't believe that I'll have to take the time to lay everything out by hand... -- Simon Elliott http://www.ctsn.co.uk Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> C++ Builder (Non-Technical) 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.