HiI have a problem,i have designed a database program with vb6 and ms access. and the program is suppose to display specific records using datareport. eg ,display records of student whose fees are> 10000. But i dont know my way out. hope to get help from anybody. ...
My application work great on MY computer (XP) but when installing on other PC (XP), I have the "Invalid Data Source" error message.This error is only when I try to do Report (DataReport with DataEnvironnement)The other options of my app works (entering data in the Access BD)Can U help PLEA ...
I am new to using DataReports, though not new to VB. I want to build the SQL statement (displayed by the DataReport) PROGRAMATICALLY - what is the proper code to do that ? I HAVE created a DataEnvironment, Connection and Command, but my report says it can't get recordsets from datasource.My code is ...
I created a datareport accessing dataenvironment, I used 2 groupswhen i run the report it came back with error record source mismatchif i delete the 2nd group it works find.this is my initial datareport that uses two grouping.any ideas ?thnkscyrus ...
Guys can you help me I dont know how to make a datareport, can you show me the step by step procedure on how to make a datareport. I have a form that has a search box(txtSearch), a listbox(lstResult), two OptionButtons(optApplicant and optOffender) and a search button, if I type the last name inside ...
I am busy with a VB6 Data Report. There are several textboxes in the detail section. One of the text boxes is set with the property of "can grow" to true. I want to draw a frame around the total report. I use four lines, one in the report header, one in the report footer and two in the det ...
I am trying to run a datareport that should only pull data for a specific value.The user selects this value from a combo box on a form and then the report isloaded. However, the report is pulling in all info. and not just info. for thatspecific value. How do I specify the info. for the report to pul ...
My DataReport is based on an ADO recordset only, not on a Data Environment. When the recordset that the report is to be created from contains only one record, is there any way to get the datareport to "duplicate" the record, and thus create a two page report showing the same record twice ( ...
Greetings!I creating report in visual basic data report. I want to costumize the paper size that i want to use. I try to make a printing report in a small paper size like bank check size of paper. Anybody have idea how can i do this. is there any other option to print in a small size of paper. ...
I would like to group the records in a table and sort the 'servtype' field in DESC order. Based on the code below, the records are grouped as I wanted it to be but why does it not sorted in DESC order? I guess I'm missing something. Please help me out, thanks in advance!'**************************** ...
I have a question about Microsoft VB6 DataReport Designer and creating reports from mySQL stored procedures. I have a complicated query in a stored procedure and want to get all records within a date range. The dates are stored in the caption property of 2 labels from a form within the current proje ...
I posted the question about Crystal Reports below. Sorry for posting twice, but I just read elsewhere in this list that it is possible to use an existing ADO recordset as the data source for a VB6 DataReport, and then bind the report controls to the recordset fields. I tried Set DataReport1.DataSour ...
I posted the question about Crystal Reports below. Sorry for posting twice, but I just read elsewhere in this list that it is possible to use an existing ADO recordset as the data source for a VB6 DataReport, and then bind the report controls to the recordset fields. I tried Set DataReport1.DataSour ...
I've been trying to move some more complex reports from VB DataReports to CR.I have a CR report that is linked at runtime to a ADO recordset. Although the recordset has some NULL data, entire rows of information will come up blank. If I put in a null substitution in the fields, the substitution show ...
Need help for this error ---- [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.while accessing vb6 datareport through citrix client which is accessing sql2000 I got the above error msg.vb6 datareport use the ol ...
HiI am COMPUTER SCIENCE STUDENT.I created thesis project with a report using VB6 datareport and Access2000. The report works fine on my machine, but when i presented this to my instructor an error "Invalid Data Source" occurs when I installed the application on other machines without visua ...
i have a database of contact numbers of friends and relatives. i wish to print each contact on a page, with their respective pictures. i have not been able to print the pictures using VB6 datareport.please help me. i don't know what else to try. tnx in advance! ...
What is the counterpart of Crystal reports 1. Selection formula2. Formulas(x)in VB6 DataReportcda ...
I am using DataReport in vb6.0 and i made connection using DataEnvironment add added one Command(for sql query).. but when my DataReport shows(DataReport.Show) it gives error "Invalid DataSource"I have checked connection n other things but still i m getting this error...plz tell me why i m ...
With Datareport objects in VB6 : Is it possible to print the report in text format to the dotmatrix printer? ...
With Datareport objects in VB6 : Is it possible to print the report in text format to the dotmatrix printer? ...
Hi, I have made a DataProject in VB6 with Access as back-end. Using Jet OLEDB 4 as provider. Programme is running well on my Computer. When I Installed the project on another Computer where VB6 is no installed on Hard disc, Error comes. When I try to show Report in runtime on another computer where ...
I have a problem with landscape and datareport.Everywhere I read that the only thing to do is to install SP4. I already installed that, but still the following does not workDatareport1.Orientation = rptOrientLandscapeDatareport1.showIs there a component or anything else that I have to activate to ge ...
HiI`ll Set Printer preferences orientation is Portrait and Paper Size is A4, But i use data report is lager then this settings. I run my package "Report width is larger then the paper width" This error can be displayed. but i`ll change this settings for Paper size is legal and Orientation ...
any one help me to format datareport's page footer section start from fix perticular line and endig with pag break ...
I am working with VB6 and access and I am facing theis problem.Can somebody tell me the reason of such kind of error- Runtime Error- 8577 Failed getting Rowsets from current data source. i am getting this error while I am trying to display reports from the database by parsing parameter like select * ...
Is there anyone who have found out ways to display the datareport in the landscape format. One method that i've seen ppl posted is the using of the orientation properties before showing the report. But this require the SP4 and above but the thing is that when i install sp5, the program that i've bui ...
I work in VB 6.0 Datareport control. I hope to print mang of different pictures report which only a picture. How can I dynamic to work it? ...
In all the documentation I've seen on the DataReport, the datasource is always set to the DataEnvironment. Can't this datasource reference a Recordset object created in code whithout the use of the DataEnvironment? If so, can you tell me how? Please email response to lee_hayes@dg.com ...
i had a problem in retrieving new records into vb6's datareport from a foxpro database when i didn't use requery. so, i tested requery with a simple command which didn't need any parameters. the code was Set DataReport1.DataSource = DataEnvironment1DataEnvironment1.rsCommand1.RequeryDataReport1.Show ...
i m developing a software by using VB6 with mysql database. my system information is XP with Service pack 2, vb6 DataEnvironment and Datareport. the problem is with parametrized query. When I use this query ( select * from ports where portid = ? ) the parameters tab of the DataEnvironment still rema ...
i m developing a software by using VB6 with mysql database. my system information is XP with Service pack 2, vb6 DataEnvironment and Datareport. the problem is with parametrized query. When I use this query ( select * from ports where portid = ? ) the parameters tab of the DataEnvironment still rema ...
I am creating a DataReport using the Data Report Designer (VB6) and using the following SHAPE command to create a hierarchical recordset.Dim cmd As New ADODB.CommandDim rz As New ADODB.RecordsetWith cmd.ActiveConnection = CN.CommandType = adCmdText.CommandText = " SHAPE {SELECT * from Relation ...
i m using vb6.0, i have used datareport in that,theere are 4 taxes like education,h.edu.,those all are printing in report but now i want that if user including education tax or other taxes than only those fields must be show in report otherwise the field of that must be hide in reportplease tell me ...
I got an error message "Invalid data source" for vb6 software for report generation that is created using DataReport feture of vb in the mechine where vb6 is not loaded.plese advise me with an example. ...
I am working through the book Beginning Visual Basic 6 Database Programming by John Connell. I have finished the section on Building a Data Control Class Module and have created a nice Book List program for my wife. I am using the DAO database control as shown in the book. In one of my other books I ...
Hye therePlz help me to print the Column of ListView as a receipt.I have no idea how to print ,i have to use datareport of VB6. or what? this is an VB6 project.waiting for replyzeb noon ...
I am using vb6 and datareport. I am updating the tables whle the program running. But the datareport doesnot show the updated information. Its always shows the previous value. But when i restart the package i can see which i updated previously. Can I see updated information while i am running my pac ...
Can anyone help me with the following please?I want to print images from a recordset using an Access Database on the datareport. I can load and display the images on the form and also navigate through the records by using the path of the location of the images. But what I can't do is print the image ...
Could anyone tell me how can i call my DataReport from a a scope? I am using VB6.0 and i build report by standard VB.Public Sub Src_Param()Dim Date_From As StringDim Date_To As StringDim Counter As IntegerDim SQL As StringDate_From = Me.Src_Date_From.TextDate_To = Me.Src_Date_To.TextSQL = "Sele ...
how i am doing report datareport or crstylreport by width in vb6 ? ...
I'm using the Data Report Designer of VB6.How can I add the value of multiple functionControls on a datareport?for example:I have 3 function control on my report group footer, and I want to add the values of this 3 function controls and displayit in a label or a textbox in the same group footer alon ...
I'm ChittaRanjan, new to VB programming. I create a DataEnvironment Designer in VB6.0 & when connecting to a database (say Access) then set its path in the Data Link Property Pop up, where I need to give the entire path detail. Latter when packaging is over and I run the .exe file then it fails ...
can i display a datareport designed in VB6.0 without giving a datasource to it? if possible how can i do that? plz give me source code ...
In the past I have always used the datareport/dataenvironment to create all my reports in VB6. However I just found out that VB6 shipped with a version of crystal reports. So I have now created a crystal report. However, I am unsure of how to call the report from inside VB6. Can anyone help me out?A ...
HiI need create subreport in DataReport (VB6). Where can I find this component ->subreport control for this report? ...
I have a problem in DataReport of VB6.I used the RptLine control on the ToolBox of DataReport in VB6 to draw the line as table in report. But when I print my report, that lines is not printed.Help me! ...
I use DataReport in VB6 to design report. I use Line tool to draw lines as a table. But when I print report , that lines is not printed.How do I have to do? ...
I'm writing a program for a garage. And now I want to make datareports. I already have reports showing all the cars and all cars by type etc... But know I want to make a detailed datareport for each car. SO you have all the data of the car and below it you have the data of the maintenance. But my pr ...
Can anyone tell me how to add page numbering to a Microsoft Datareport in VB6? I cannot seem to find a way to achieve this. ...