hello, I have a crystal report (version 8.5) which has about 10 on-demand sub-reports embedded in it. But when the report opens, the hyperlinks for them do not work, as in, they appear as plain-text, not clikable. The same report works just fine when viewed in crystal software. I am using visual c++ 6.0. Is there any addtional coding to be done to enable it.? Also, how do I determine which subreport the user has clicked on, in order to open the appropriate sub-report. Right now, all i am able to do is to scroll through each of these subreports. But i dont know how to stop and display the one that the user has clicked on. Kindly help

Hello, I have a dialog with edit fields. and i store the data entered into them into MS SQL. Now, for data validation for CString fields, I use simple tes like If(str=="") { Messagebox(something); } but for integer fields, VC++ 6.o automatically gives a message "please enter an integer" ,if the integer field is left blank . I get a first chance exception "0xE06D7363: Microsoft C++ Exception." and a messageBox "Please enter an integer." I guess that is because when I call UpdateData(true), there is no value for DoDataExchange. But Is there any way of disabling this message and allow me to display my own message as my application starts behaving unexpectedly after it encounters this exception. Also Could you tell me how to catch this exception thrown because of UpdateData. I could not catch it with normal CExeption * e. Please help.

hello, I am building an application in VC 6wherein when the user clicks ona particular button, a query is fired to SQL SErver 2000 database and a report (crystal reports 8.5) is generated based on the data retrieved. I am having multiple clients which connect to the SQL server remotely. so while retrieving, i will need to specify the IP of the machine where the DB is stored. I have heard of a function callled SetLogonInfo which allows a user to change the databse name on the fly. But when I add an Active X control to my app, the version of SetLogonInfo takes only 2 parameters...."void SetLogonInfo(short index, LPCTSTR lpszNewValue); ...instead of 4 which i have seen in most standard implementations. Could you please give me more details regarding this function and how do I connect remotely for crystal reports? What is the code that i need to include in this function? Awating Your Reply Thank You

Thank you so much for your reply.

Anders Gustafsson wrote:

Downside is that documentation is sorely lacking especially for C++.

In what way is it lacking for visual c++. Is it farily straightforward to use....Because i am really hard pressed for time on this project. Are ther some tutorials for that? Also, I have heard about a software called Visual reports from sparrow-technologies. How does this compare in terms of ease of usage and display properties. Also, this maybe wandering away from the topic a bit, but could you please recommmend some good tutorials for VC++ 6. I am building a Gui for a database application. Thank you again.

Hello, I am new to VC++. I am supposed to build an application which includes generating reports dynamically using data in a database based on what the user selects. i have heard of something called as Crystal Report. But I am not sure whether that is the right tool to use because I dont know much about that software. Is this the simplest solution to generating reports. Is it possible to do the same without using additional software? Which are the other options, if any?I am using Visual C++ 6.0. Crystal reports is not bundled into it. Kindly help

ACtually, the exact same Open call worked in another small aplication. The only difference was that the object invoking the Open() method was of type REcordSEt...and in my case it is of a type MySEt ( derived from recordSEt)

Hello, I have a query regarding recordset retrieval. This is what I have so far. 1.An SDI application(name:Database) without database support and CDatabaseView derived from CFormView 2.A second dialog(name:Dialog1) and its class Cdialog1. 3.A new MFC class CMySet derived fron Crecordset. 4.CDialog1 has a foreign variable m_pSet of type CMySet The DB connection opens properly using CDatabse.OpenEx() then i have the following code to open a recordset. "user" is one of the tables I have selected. CDialog1 dlg; dlg.m_pSet = new CMySet(m_pDB); str = "SELECT * FROM User;"; dlg.m_pSet->Open(AFX_DB_USE_DEFAULT_TYPE,str,CRecordset::none) I get an error at this point, while executing,saying "error retrieving record".Actually on clickin a button on the first main form(which just has a pic) I wanted to have a screen for username and password whiich has to be verified from the DB. Am i wrong in my approach somewhere. the application builds and compiles jus fine. Kindly help.

Thank you for the suggestion. But, in the SDI, only the first main form has database access, as in, if I use Edit fields and look to assign variables to each, I automatically get a drop-down list of the table column names in the add-member variable dialog. Subsequent dialogs do not have this facility. How do I go about that? And what should be the base type of subsequent dialogs? Just CDialog? Thank you again, Sir

I am really sorry, I am not too familiar with these concepts that you mentioned. Could you please clarify ? I want the user of the application to be able to enter data/view data/query data through a series of dialogs. On clicking "SAVE" for a particular dialog/form the next appropiriate dialog should be displayed. How do I go about this? Thank you

I am a novice in Visual C++ programming. I have to create an application which acts as the front end for accessing records in a database. Should I go in for an SDI application or a dialog based one? There should also be the facility that new pages/dialogs should open on clicking of command buttons like "save", "Login", etc and every such new page should have database acces for entering and deleting records. Is this possible using SDI application? What should be the base classes of the subsequent dialog boxes that I create? I tried inserting a new dialog by selecting IDD_FORMVIEW in the drop down list for insering new dialogs and having the base class as Crecordset. But i am not able to open this second page on clicking a command button in the first page. Can someone please give me a step by step procedure on how to accomplish this? Or should i go in for a dialog-based application? Again, what should the base classes be of subsequent dialogs? Thanks