showing specific records using vb6 datareport

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. ...

VB6, DataReport error : Invalid dataSource ...

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 ...

VB6 DataReport

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 ...

VB6 Datareport

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 ...

How to create VB6 Datareport

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 ...

Adjusting the height of a textbox in a VB6 DataReport at runtime

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 ...

VB6 - datareport

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 ...

VB6 DataReport recordset duplicate?

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 ( ...

customizing paper size in vb6 Datareport

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. ...

Problem in Sorting - VB6 DataReport Using Ms Data Shape

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!'**************************** ...

DataReport designer + Stored Procedures

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 ...

VB6 Data Report

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 ...

VB6 Data Report Problem--Need Help Fast

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 ...

CR XI and VB6 prints some blank rows

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 ...

Login failed for user '(null)'

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 ...

invalid data source error in my thesis project

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 ...

printing address book with pictures

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! ...

Data Report

What is the counterpart of Crystal reports 1. Selection formula2. Formulas(x)in VB6 DataReportcda ...

DataReport in vb6

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 ...

Urgent : Text Mode in DataReport(VB6)

With Datareport objects in VB6 : Is it possible to print the report in text format to the dotmatrix printer? ...

Urgent : Text Mode in DataReport(VB6)

With Datareport objects in VB6 : Is it possible to print the report in text format to the dotmatrix printer? ...

DataReport in VB6

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 ...

Datareport + VB6 +SP4

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 ...

How to use datareport with out using Printer settings in VB6.0

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 ...

DataReport Section Format in VB6

any one help me to format datareport's page footer section start from fix perticular line and endig with pag break ...

creating report using datareport vb6

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 * ...

Displaying datareport in Landscape and vb6 compatibility with winxp

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 ...

VB6.0 datareport RPTImage dynamic update picture

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? ...

DataReport VB6

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 ...

how to requery datareport when you need to pass parameters also

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 ...

Problem ODBC-5.1.1 with VB6 DataEnvironment Parametrized qeury (Please Help Required)

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 ...

Problem ODBC-5.1.1 with VB6 DataEnvironment Parametrized qeury (Please Help Required)

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 ...

Problem with Hierarchical recordset in Datareport

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 ...

Related TO DATAREPORT

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 ...

Vb6 Data Report Error

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. ...

Connection strings for DataReport

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 ...

Print listview items as a receipt in VB6 project

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 ...

datareport delayed?

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 ...

Print Images from recordset on DataReport

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 ...

Calling DataReport

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 ...

datareport or crstylreport

how i am doing report datareport or crstylreport by width in vb6 ? ...

VB6 Data Report Adding Value of FunctionControls?

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 ...

DataEnvironmentDesigner in VB6.0

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 ...

datareport without datasource

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 ...

VB6 / Report writer

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 ...

subreport in datareport ??

HiI need create subreport in DataReport (VB6). Where can I find this component ->subreport control for this report? ...

Data Report in VB6

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! ...

Data Report in VB6

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? ...

group by with datareport??

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 ...

Datareport page numbering?

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. ...