Dec 08, 2004 This is what I do using Crystal Reports 9 with VB6 When creating an ActiveX Designer Report (DSR), the Crystal Reports Gallery dialog appears. Choose From an Existing Report and browse to. We have a VB6 application using CR 7. We want to move the VB application to another box where CR 9 is available. VB application with Crystal report 9. Welcome to the p2p.wrox.com Forums. You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free. This is what I do using Crystal Reports 9 with VB6 When creating an ActiveX Designer Report (DSR), the Crystal Reports Gallery dialog appears. Choose From an Existing Report and browse to the report file. The Report file will be converted to a DSR for use with the RDC in Visual Basic. The wizard does the rest. Then enter your code as normal. Hello, I need to know how can I add my report created in crystal report 9 from my visual basic (v 6) form. Some info about my report: ** my report is created on crystal report 9. ** it is using OLE DB connection to connect with my database. ** my database is in ms-access and password protected. So, I need to know-- =how to set the location of the database from vb6 for the report =how to refresh data each time the form is run =how to provide password for the database Code example will help me lot. Thanks in advance belal. Thanks Paplewska for your code. But as I have mentiones that I am using OLE DB Connection Type. How Can I use this for OLE DB connection. I have tried by changing your code following way: For i = 1 To Report.Database.Tables.Count Report.Database.Tables(i).SetLogOnInfo 'Microsoft.Jet.OLE DB.4.0', 'mdacrs.mdb', ', 'siristhebest' Next i and it gives me following error: Logon failed Details: ADO Error Code: 0x80040e21 Source: Microsoft OLE DB Service Components Description: Multiple-step OLD DB operation generated errors.Check each OLE DB status value, if available.No work was done. Schneider sla 5610 manually backup. Please help me more specifically, Thanks in advance. DanInManchester, will you please explain me the difference betn using ttx file and RDC system. I am new to this topic. Your little explanation may help me to be friendly with these. And, Can anyone help me explaining how to use connection property if I like to use it instead of setLofOnInfo, as in many discussion I learened I should use this system though I don't know how to use it. Here I am giving the syntax I have learened from net. ![]() But don't know what to do next. Dim CPProperty As CRAXDRT.ConnectionProperty Dim crxTable As CRAXDRT.DatabaseTable ' craxdrt.DatabaseTables 'create a CRAXDRT database table object and connect. For Each crxTable In Report.Database.Tables Set CPProperty = crxTable.ConnectionProperties('Provider') CPProperty.Value = 'Microsoft.Jet.4.0' Set CPProperty = crxTable.ConnectionProperties('Data Source') CPProperty.Value = App.Path & 'mm.mdb' Set CPProperty = crxTable.ConnectionProperties('User ID') CPProperty.Value = ' Set CPProperty = crxTable.ConnectionProperties('Password') CPProperty.Value = 'seeyou' crxTable.Location = App.Path & 'mm.mdb' Next Note: This section couses an error that dismiss my vb application when it is said to run Sorry, for my long message. Hope get your help. The only difference is to do with the database connection. A ttx file simply contains a list of fields and sample data. (Field definitions only datasource) Crystal will create this for you or you can do it yourself. When you are designing your report rather than use a 'real' database you connect to the ttx file. This gives you enough information to design your report. You can then bind your report to any datasource at runtime as long as it matches the specification in the ttx file. The adantage of this approach is that you can let your ADO handle all your queries and parameters and simply pass the report the required data. You reports are a lot easier to redistribute as your data location and login etc is handled within your application. It's essentially like using a standard VB datareport. Thanks DanInManchester for your quick response. And I am glad to learn from you. It would be a great help for me, if you really show me the way I should proceed to solve my problem. Still I am with the difficulty. I really need some guideline and real code help. Again I like to mention that my only concern is (now) cr9, ole db, access database password protected..so, please someone do me some fevor. Looking for helpful solution from you (all). You can give me reference of good book on crystal report 9 to work with vb6. Thank you all, again.
0 Комментарии
Оставить ответ. |
АвторНапишите что-нибудь о себе. Не надо ничего особенного, просто общие данные. Архивы
Март 2019
Категории |