'Dear all, I am using vb6 with ms-access database. Currently I am adding CR-Report-XI in the form by: Project->Add Crystal Report 11.5->Select Existing Report.->Ok By doing this a new form with CRViewer is automatically added to the project. How add Crystal Report Version 11 in VB6. At present I have been using Crystal Ver 8. I need to upgrade to Crystal Ver 8.5 or above to implement exporting rpt's to pdf. Now, I have installed CRystal report 11 Developer edition in my system and from VB i am not able to add Crystal Report control of. Hi friends, Im using VB6.0 with Crystal Report 10 DB: MSACCESS Please provide some sample coding that connects the report(CR 10) to view. Sample Program Using Crystal Report In Vb6• → *new* Get practical advice and learn best practices for moving your applications from RDBMS to the Couchbase Engagement Database. (sponsored) • → Learn to shorten database dev cycles, integrate code quality reviews into Continuous Integration workflow, and deliver code 40% faster. Half life opposing force cheats. (sponsored) • → See a demo showing how you can build a globally distributed, planet-scale apps in minutes with Azure Cosmos DB. (sponsored webinar) • → A complete overview of Cloud Computing focused on what you need to know, from selecting a platform to choosing a cloud vendor. • → Better understand the signs that your business has outgrown its current database. (sponsored webinar). Click Here to Expand Forum to Full Width. Ok first off, I'm a newbie to programming so please bear with me. My company has asked me to design a time tracking application for all of their technicians. Ok, that's fine I can do that. ADO is easy, but the problem is creating a dynamic reportusing Crystal Reports 8.0. We want to be able to select a specific technician from a list and a date range. I've been using SQL statements to generate the query from a Combo Box and 2 Text field boxes. The code that I use in the SQL statement is as follows: sSql = 'SELECT tblLabor.Technician, tblLabor.Date, tblLabor.[Billable Hours], tblLabor.[Non Billable Hours], tblLabor.Vacation, tblLabor.[Sick Time], tblLabor.[Project Time], tblLabor.[Total Time], tblLabor.TicketNumber, tblLabor.TimeTaken ' sSql = sSql & 'FROM tblLabor ' sSql = sSql & 'WHERE tblLabor.Technician = ' & cmbTechname.Text & ' AND tblLabor.Date >= ' & txtDateStart.Text & ' AND tblLabor.Date. In Crystal Reports, which should be installed together with your VB, open your database, and open your table or tables. Drag and drop the fields to where you'd like them, and how you'd like them organised. It's roughly the same as creating a report in Access. The same goes for 'grouping', as in using your technician as a 'header', and then giving all the details for that technician, and (for example) thus creating a report with one page per technician. Save your report(s). In VB, put the Crystal Reports object on your form. It's an invisible one, and you can have several on one form if you like. You can choose whether to put all the parameters in the object, via its properties, or from within the code 'behind' a button or a menu option. You can choose for example the report name you wish to use (don't forget to distribute them, or store them somewhere centrally!), the filters, how it looks (print preview/print immediately/., and so on. The easiest way to get all the parameters is F1 when toe object is selected. There are some samples there too. Forgot to mention: You need to either create a blank form in order to show the report on and set Crpt1.WindowParentHandle = Form1.hwnd so that CR knows where to show it's window and then call the report by setting: Crpt1.Destination = crptToWindow (or crptToPrinter) Crpt1.PrintReport or use the Crystal Reports Smart Viewer. As I mentioned above. By the way, if you want to pass a recordset object straight to CR then you can do this by making a definition file (CR has prg to simplify it) and then the report uses the definition file as fields, which then can be place on the rpt as you would with real database fields. Avrin sonicstage ultimate edition. Once this is done you only need to pass the recordset. This will keep you from having to build temporary tables, filling and emptying them, (bloating an MDB as well). Then open the report as described above. For this, check out 'Using the Active Data Driver' in the same help file or go on-line to the Crystal Care Technical Support Knowledge Base Articles: c2002281,c2002848,c2003548,c2002748. Also,check out the CR 'Help for developer's' help file (installed with the CR program) under 'Using the Crystal Data Object', and 'When to use the Crystal Data Source Type Library'! Hi Paul, First you have to write the report and make sure that it is working. Now, in VB you will have to create a work table. If you are using Access, this makes everything easier. Just write an Access select query and have it make a work table for the select data to go into. If you are using SQL then you will have to go thru VB to make a table to hold the info from your select statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |