Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




How To Pass Values To Crystal Report From Vb


hai hai hai


I am using crystal report 7.I was just linking the table at desing time and displaying the values.Now what i need is i just have to know how to pass query or records from vb to crystal reports at runtime.I serached for it in this site but i cant find one .So can anybody help me hwo to know abt it


Nanree(Thanks In Our Language)
Ramya




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
How To Pass Format String To Crystal Report From VB And How To Use It In Crystal Report?
Hi,

I am working on VB 6.0 and using crystal report 7 as reporting tool.
In report, some clients are asking 3 decimal places(Eg. 2000.500) while other clients are asking 2 decimal places(Eg. 2000.50) for numeric fields.
I want to pass the amount of decimal places for numeric fields to crystal report from VB.
How should I implement this using VB.
Pls any one can help me?

Thanks in vance,
Soundar

Pass A Value To Crystal Report 8
Hi,
This is a question regarding Crystal Report 8
i) There's a vb form with a textbox. User would input, say "ABC" in the textbox. Then, I want to pass the "ABC" into my Crystal Report details field.

Eg:
User only have to input the "ABC" once while the name would be retrieve from the database.

Report generated:
Name Class
Alex ABC
James ABC
Sandy ABC

Can somebody help ?

Pls advice and thanks in advance

pcPirate

Pass Value To Crystal Report
hi,

i've have a table (Access 97) that contain customer information and i need to display certain customer details.

in VB 6.0 form, a text box that allow me to type a customer code and a command button that use to show the report(crystal report 9)

how i pass the text box value to the report when i click the command button ?????? plz help................

thanks

How To Pass Parameter Value From Vb To Crystal Report?
how to pass parameter value from vb to crystal report?

Pass Formula From VB To Crystal Report
Can anyone explain to me how I can pass a formula from a VB6 application to Crystal Reports?

I want to select specific data from the database based off of a variable in vb.

For example: In the VB app, to create the recordset, I would say
SQL = Select * from tablename where dbField = '" & txtRegion & "';"

I only want to pass the results in the recordset to CR or pass a formula where Crystal Reports would give me the same info.

Thanks,
Sam

Pass Value From Vb Form To Crystal Report 9
Hi folks,
My apology if I have posted this in a wrong forum, which may be appropriately moved.
My post is this, I have a form in VB which allows the user to select a region from the combo. Based on the region selected the crystal report should display records [Acs 2003] for that relevant region. Iam just testing waters in CR so please be kind enough post the code & steps how to perform it or better a sample proj. I know there are somethings like parameterfield, formula field, variables in CR but I donot know how to use them.

Thanks in advance.

How Do I Pass A Crystal Report As Argument?
Im trying to pass a report to a function. If I define the argument as being CRAXDRT.Report none of the objects I have on my form are referenced anymore. Using Variant or Object does not work either. I can't actually use the name of the report either. Here's what I want to do:

VB Code:
Private Sub OneSub (param as Integer) Dim InvM1 as MyCRReport1Dim InvM2 as MyCRReport2Dim InvM3 as MyCRReport3 Select Case paramCase 0Call MyFunction(InvM1)Case 2Call MyFunction(InvM2)Case 3Call MyFunction(InvM3)End SelectEnd Sub Public Function MyFunction(InvMReport As ??) End Function


Any idea?

To Pass Parameter From Vb6 To Crystal Report
Hello Friends,

My problem is I want to accept value from user which I am nt storing in databasse. I am using inputbox to get value from user and then I want to print the same value in the crystal report. I am not using crystal report viewer, but I've used crstyal report's ocx and from there i am opening report by using printreport method of the crystal report's ocx control. plz help me.

below is my code which i m using to print report



VB Code:
With crStudList        .Connect = strConn        .ReportFileName = App.Path & "
eportsStudentList.rpt"        .ReportTitle = "Student List"        .WindowTitle = "Student List"        '.SelectionFormula = "{tblStudent.RegistrationDate}>= DateValue (" & dtpFrom.Value & ") and {tblStudent.RegistrationDate}<= DateValue(" & dtpTo.Value & ")"        .SelectionFormula = "{tblStudent.RegistrationDate}>=#" & Format(dStartDate, "dd/MM/yyyy") & "# and {tblStudent.RegistrationDate}<=#" & dEndDate & "#"                .Destination = crptToPrinter        .PrintReport     End With


where crStudList the name of ocx control of crystal report

thanks

How To Pass Discrete Value From VB6 To Crystal Report ?
I am using VB 6 and Crystal Reports 9. How can I pass a discrete value to
Crystal report ? What references should I include ? Thanks.

Pass Two Recordsets To Crystal Report
I have my code working fine for one ADO recordset, but I added
another query to the report and now I need to pass a second
recordset to the report before it gets created in vb. Here is my
code for one recordset. I thought if I changed the parameters I
could pass the second one but it didn't work.

VB Code:
oReport.Database.SetDataSource oRs1, 3, 1oReport.Database.SetDataSource oRs2, 3, 2
The second parameter of 3 is the datatag and the third is the tablenumber.
Any ideas on what I am doing wrong?



Thanks in advance for any assistance.

How I Can Pass ADO RecordSet To Crystal Report?
How I Can Pass ADO RecordSet to Crystal report?
IHave Crystal Report. Now I Want To Set Recordset as datasource, so I can put the records in crystal report which is in my record set? Please Give Me Brief example

How VB Pass Parameter To Crystal Report
how to pass Parameter to Seagate Crystal report by VB?

I want to pass One or More parameter to Crystal report to meet a certain critera

like i want to select some record by my application given date so report should be contains only those record sort by given date.

Fwd: How To Pass ADO Recordset To Crystal Report 7.2
---------Forwarded message---------
Date : Mon 04 Aug 10:40:24 2003
From : syed
Subject : How to Pass ADO Recordset to Crystal Report 7.2



Dear Friends
i am having problem with Hindi data. in the hindi data contains single qoutes in the string. so i was replace the string to "---" and when i am retriving this into vb again i convert into single quoutes through replace command in vb. but there is no facility in crystal report 7.2 for find andreplace the string through formula. so please suggest me its very urjent.

otherwise if i can pass ADO recordset to crystal report is there is possible then please tell me how it could be possible please
syed

How To Pass ADO Recordset To Crystal Report 7.2
Dear Friends
i am having problem with Hindi data. in the hindi data contains single qoutes in the string. so i was replace the string to "---" and when i am retriving this into vb again i convert into single quoutes through replace command in vb. but there is no facility in crystal report 7.2 for find andreplace the string through formula. so please suggest me its very urjent.

otherwise if i can pass ADO recordset to crystal report is there is possible then please tell me how it could be possible please
syed
........



S.M. Syed Sherfudeen
Scientific/Technical Assistant-'B' ,
NIC, Madhya Pradesh State Unit,
Computer Centre 'C' Wing Basement
Vindhyachal Bhavan,
Bhopal - 460 004,
Madhya Pradesh.
Ph. 0755-551265 ext.112

How To Pass A Parameter In Vb Using Crystal Report 9.0
hi,

      i'm using vb 6.0 , access 98 & cr 9.0. plz help me how to pass a parameter using vb 6.0 .
in run time.

regards
chitkrish


vikramjb : post moved to the reporting section. Please post in the approriate forums.




Edited by - vikramjb on 12/22/2005 2:08:48 AM

How To Pass Recordset To Crystal Report From Vb
Hi Guys,

I am trying to pass recordset to Crystal Report 8.5 from VB 6.0.

I have created an Crystal Report file by using the Create New Connection option. This is done in my system.

When I install my project at the client machine, I want the report to take the new connection, i.e the System name and Database will change.

I am giving the code which I am currently using.

        
        Set oReport = oApplication.OpenReport(App.Path & "ReportProjectSheet.rpt")
        Me.Caption = mvarReportName
        
        Set rstReport = oProject.GetProjectDetail(me.txtProjectNo.Text)
        oReport.Database.Tables(1).SetDataSource rstReport, 3

The problem i am facing is that either the connection is not changing or report is not displaying.


Please it is very urgent....

Can I Pass Querry To Crystal Report?
Hi friends,

I am using Crystal Reports 4.6.1.0 and am new to it....
I want to generate a report using data from two tables!

Can Anybody explain me how should I pass a querry to Crystal report through VB 6!

Thanx in advance!

Save Log In In Crystal Report/ Pass From VB
I have made a report program using VB6 and crystal report 9.
When I run the program, it got an error saying that the log on to the database fail. However, I cannot use trust connection as the database has created a user login for access it. How can I pass this login (user name + password) from VB to crystal report to log on to the server?

How To Pass Parameters From VB6 To Crystal Report 8?
Good day everybody!

just like to find out whether is it possible for me to pass a parameter from Visual Basic 6 to Crystal Report 8 Professional version??

is it true that only the developer version of CR8 can do passing of parameters??

thanks for all your time!!

Pass Parameter To Crystal Report
i need to pass a parameter to crystal report from a listview in vb6. i wan the report to populate only 1 record. possible?

How To Pass The Parameter To Crystal Report?
Hi
How to pass the parameter to crystal report ?
how to pass the parameter to data report?

thanks

How To Pass Argument To Crystal Report Pro
Hi
I wanna know if Crystal Report Pro (came with VB 6) can receive Argument/Variable passed from VB ? I use the Crystal Report ActiveX Control to invoke the Preview Window of Report when the user press a command button. Seemingly we can't pass any Argument/variable to Crystal Report. I intend to preserve 2 fields (Not from database) in the report for the display of user keyin value at run-time. Besides, I wanna display the name of the Database from which the report retrived in the crystal report. How to do it, please ? Tnanx.

Pass Parameters In VB6 To Crystal Report 8.5
Hi Babu,
I hava a problem about pass a parameter in VB6 to Crystal Report 8.5 that need your helping. When I add Crystal Report 8.5 control in VB6 then I got a CrystalReport1 and Form1 . I want to design a form in VB incluses 2 textbox that allow user type StartDay and EndDay. User can click Preview button to view report. Can I type code in VB form or Form1? How do I pass parameter?Please give me a detail code.Thank you for your helping.

How To Pass Data To Crystal Report
Hi:
Here I have a simple question. In a crystal, how can I pass data to it , but not from Database. In the form I can create a text field then pass to it. In Datareport, I can create a label then pass to it.
But How can I do it in Crystal report. Should I create a formula first ??
In anybody know about it or have good tutorial about how to use Crystal report. It will be very helpful. Millions of thanks in Advance!!
Yeung

wky086

How To Pass SQL Command To Crystal Report
Hi;
here have a simpe question of crystal report.
IN adodc , I can pass SQL command by the follow command:
Adodc1.Datasource = "select * from Emp where SN = '+EmployNumber +'"
But how can i pass it to Crystal report.
I use CrystalReport1.Datasource = "select * from Emp where SN = '+EmployNumber +'" It comes with error message " need object"
If anybody know how to do it. Please help me.
millions of thanks in advance!!


wky086

How Do I Pass A Parameter Range To A Crystal Report (v8.5)?
Hi

I am using VB6 and Crystal 8.5 (the database is only compatible with this version of Crystal.

I need to pass a parameter range to my VB code, the parameter works fine in Crystal, but I cannot work out how to pass the parameter range in code.

All help very welcome!

Thanks

Blinking Nora

How To Pass Parameter Using Crystal Report Viewer
hi!
I have a report to which i am passing a parameter value custid
i was earlier using just the rdc control and showing the report and passing the parameter by

CrystalReport1.ParameterFields(0) = "custid;" & Combo2.Text & ";true"

now when i use crystal viewer using the foll. code

Dim app1 As CRAXDRT.Application
Dim rep As CRAXDRT.Report

Private Sub Form_Load()

Set app1 = New CRAXDRT.Application
Set rep = app1.OpenReport("c:sales1.rpt", 1)

With Form1
.Show
.CRViewer1.ReportSource = rep
.CRViewer1.ViewReport
End With
End Sub

the report prompts for a parameter

How can i pass the parameter to the report within this code so that the viewer does not prompt for any input
thanks in advance
Mukul

Form To Pass Parameters To Crystal Report
I have a form that works just fine passing parameters to the Crystal Report. However I have one parameter than needs to be 1/1/2002 (the 2002 needs to change based on current year ie in 2003 it should be 1/1/2003 without any user input. I use this for the start date in a year to date part of the report. Any suggestions how I can achieve this ?

Thanks for any and all help

Pass BLOB Parameter To Crystal Report
I would like to display the image from the local file system where I can pass the path or the whole image (in BLOB fieldType). But I found that I cannot set the parameter field type into BLOB (only can set String, Date, Time, etc). What can I do? I found that it works when the photo is stored in database only. Is there anybody can solve this problem?

How To Pass SQL Query To Crystal Report : Pl Help It Is Very Urgent
Following is the code I am passing to Crystal Report. I am using CR Ver
4.6

I have created Report with Tmp_Data table and table is empty .
Now I want data from OP_BAL table
for Ast_Code = '10060010001' .



Csql = "Select * from OP_BAL where Ast_Code = '10060010001'"
CrystalReport1.Connect = Gc.cnn &&
Connection to Access 97.
CrystalReport1.ReportFileName = "C:VBAssetSystemR_master.rpt"
CrystalReport1.WindowLeft = 0
CrystalReport1.WindowState = crptMaximized
CrystalReport1.SQLQuery = (Csql)
CrystalReport1.Action = 1

With advance Thanks

DVK

Pass In Crystal Report Parameters To Export
Hello,
I am having trouble passing in parameters to a crystal report in a vb6 app.
I have gotten this far but I am unsure of the syntax for inserting the parameter

Dim appl As New CRAXDRT.Application
Dim rep As CRAXDRT.report
Dim report As String

report = "t:invreportsMaruyoshiInvoice.rpt"
Set rep = appl.OpenReport(report, 1)
rep.EnableParameterPrompting = False

rep.ExportOptions.DiskFileName = "c: emppdf_report.pdf"
rep.ExportOptions.DestinationType = crEDTDiskFile
rep.ExportOptions.FormatType = crEFTPortableDocFormat
rep.Export False

But I need to pass in a parameter to the report. The report parameter is @invno
and the value will come from a textbox.
Any help will be greatly appreciated

How To Pass Image Path To Crystal Report 8 Through VB6
I am working on large-scale project entitled as MIS (Marketing information System). As I told you that I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool.

1) In the project it is required to save dealer’s photo, and it should be shown in individual dealer’s detail report, which will include his/her image. I had taken Common dialog box control to select image and display it in image control.

2) The size of database is very large then, which will be useful from the following?

i.    to store image to database?
(But it makes database larger in size which leads to slower access)

ii.    Saving path of image in database

To keep database safe I want to try the second option first. Instead coding directly into project, I want test the logic into small program first. As we know that by use of common dialog control we can select image and show it in image control. Also same path can be stored in database. Also we can retrieve the path from database and show it image control.

Until here all things are ok. Now problem is that how to show the image in crystal report. Usually we pass the fields directly to crystal report by sending sql-query to it.




Edited by - Skiran on 11/3/2006 11:03:32 PM

How To Pass Runtime Image To Crystal Report
Hi all,


I have came across a problem in my project.
I want to pass runtime image to Crystal Report through VB.I have saved the path of the image in Access .
I have searched related web through google,but I didn't get the help.
If you know something abt it plz if possible mail me.

Thanks

Amit.

Pass Table Name At Runtime To Crystal Report
Hi All,

I am using vb6 with crystal report 7. In my porject I am creating a temporary table at runtime to organise my report data, could any one tell me how to pass this temporary table to crystal report...is there any property or method of crystal report control using which i can pass on this tablename.....

Just to give a background I have created the desing of crystal report using the similar table so the field name and all the setting will remain same only the table name will be different..so i would like to know is there any way by which i can pass on this new table name to crystal report.

Thanks in advance.

Jignesh

How To Pass 2 Recordset To The Same Crystal Report From VB At Runtime?
I am using vb 6 & crystal report version 7. I had tried to pass 2 recordest to crystal report from vb at runtime by using data definition(TTX) files but it doest work. Is there any method or others way can complete this task?
i am new user for crystal report, hope someone can give me a help. Pls attached the coding sample as well. Thanks!

How To Pass Image Path To Crystal Report 8 Through VB6
I am working on large-scale project entitled as MIS (Marketing information System). As I told you that I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool.

1) In the project it is required to save dealerís photo, and it should be shown in individual dealerís detail report, which will include his/her image. I had taken Common dialog box control to select image and display it in image control.

2) The size of database is very large then, which will be useful from the following?

i.to store image to database?
(But it makes database larger in size which leads to slower access)

ii.Saving path of image in database

To keep database safe I want to try the second option first. Instead coding directly into project, I want test the logic into small program first. As we know that by use of common dialog control we can select image and show it in image control. Also same path can be stored in database. Also we can retrieve the path from database and show it image control.

Until here all things are ok. Now problem is that how to show the image in crystal report. Usually we pass the fields directly to crystal report by sending sql-query to it.

How To Pass Query String To Crystal Report Viewer ?
I have a VB application with 2 forms: Form 1 has a combo box Dept List and ViewReport button, and form 2 has Crystal Report Viewer only. When user choose item from Dept list, I will select in SQL database based on what user enters and pass that query to crystal report viewer but I got error at last line of from 2, say "Subscript out of range". Here is my code. Please help me to figure out this error or you have better way to display report. Thanks for any help.
Form1:
Private Sub ViewReport_Click()
Dim cn As New ADODB.Connection
Dim StrSQL As String
Dim sDeptNameList As String
Dim f As New Form2

cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=Employees;Data Source=Test"
cn.Open
sDeptNameList = Trim(cboDeptList.Text)
StrSQL = "SELECT * FROM Dept WHERE Dept = '" & sDeptNameList & "'"
'''View report
f.sql = StrSQL
f.sFormDeptPhoneList = """" & sDeptNameList & """"
'''End View report
cn.Close
Set cn = Nothing
End Sub

Form2:
Public sql As String
Public sFormDeptPhoneList As String
Private Sub Form_Load()
Dim crysapp As New CRAXDRT.Application
Dim rep As New CRAXDRT.Report
sFile = App.Path & "DeptPhoneList.rpt"
Set rep = crysapp.OpenReport(sFile)
crysapp.LogOnServer "p2ssql.dll", "Test", "Employees", "sa", "sa"
rep.SQLQueryString = sql
rep.FormulaFields(0).Text = sFormDeptPhoneList
End Sub

How To Pass Sub Query From Form Design To Crystal Report
How can i pass string query from form design to crystal report?
this is my source code
" {EMP.DEPTNO} IN (SELECT {DEPT.DEPTNO} " & _
" From DEPT " & _
" WHERE {DEPT.LOC} = 'CHICAGO' "
it have Runtime error"20515"
'...............'
the remaining text does not appear to be part of the formular.
How can i do?.

it success in form..

thank you for advice.
makoks

Very URGENT PLS PLSi Want To Pass Query To Crystal Report From Vb 6.0
hai
      i want to pass query to crystal report from vb 6.0 ? that is
     i made one vb 6.0 with MS Access inventory Project ,in my project i need reports for sales between two dates which is selected from the vb from and these reports fields taking from different tables .



THIS MY QUERY

Code:[code=vb][code=vb][code=vb][code=vb][code=vb]SELECT Items.ItemCode, Items.Description, SalesOrderDetails.ItemBarcode, SalesOrderDetails.Quantity, SalesOrderDetails.UnitPrice, SalesOrderDetails.LineAmt, SalesOrders.OrderID, SalesOrders.OrderDate, SalesOrders.TotAmt, SalesOrders.Discount, SalesOrders.NetAmt, Customers.CustomerName FROM Customers INNER JOIN (SalesOrders INNER JOIN (Items INNER JOIN SalesOrderDetails ON Items.ItemBarcode = SalesOrderDetails.ItemBarcode) ON SalesOrders.OrderID = SalesOrderDetails.OrderID) ON Customers.CustomerID = SalesOrders.CustomerID WHERE OrderDate BETWEEN '" & Me.txtFromDate & "' AND '" & Me.txtTodate & "'"[/code][/code][/code][/code][/code]


 please give me example of it.

BY
SIJO

How To Pass Sql Stored Procedure Parameter To Crystal Report? - Thanks
How to pass sql stored procedure parameter to crystal report? - thanks

How Can I Pass A Parameter To Crystal Report 5 From Visual Basic Screen?
I am using Crystal Report 5 with Visual Basic 6. I like a use select a data from Visual Basic Screen and list value in the VB report, based on the selection. How can I pass a parameter to Crystal Report 5 from Visual Basic Screen?

Urgency - Pass Value From Visual Basic Ver 6 Form To Crystal Report Ver 8
urgency - pass value from visual basic ver 6 form to crystal report ver 8 ...?

How To Pass Parameter Field On Crystal Report 8.5 Form Textbox VB 6.0
how to pass parameter field on crystal report 8.5 form textbox VB 6.0

How Do You Pass Database Logon Information To A Crystal Report 10 At Runtime In VB6?
hi, i have project in VB6 and use Crystal Report 10 as my report. my backend database has password, so when i open my project and view the report, the report cannot loaded bec. of my password in database, so How can i pass database logon information to a Crystal Report 10 at runtime in VB6? i use crystal viewer of Crystal Report 10... waiting to your reply....

What's The Property To Display Date In Pageheader In Crystal Report Which I Pass From VB
Hai friends,

      I want to display the date in the Page header of Crystal Report which I pass from VB. I am passing the date as below in Record selection formula.
 in the command button iam calling the function according to the Option button the user clicks. the report shows as the code in the function. How I will pass the From Date and To Date to display in the top of the report which I am sending from VB, and it should be displayed in the page header because I need to print the date in all the pages which print .

Thank you very much,
Chock.
itchocks@rediffmail.com

<HTML>
<B><font color="#008000">HAVE A NICE DAY !</font></B>
<HTML>

Edited by - chs on 2/25/2003 1:09:29 AM

How To Pass Query From VB Form To Crystal Report Designer Component
I am a beginner programmer in VB. I have a form from which the user can query the database in Access. I am using DAO. I also want to print a report but I don't know how to pass the query from VB form to Crystal Report Designer Component or Microsoft Data Report.

If anybody has sample code or knows site where I can get help , please let me know.
My email address is
adan_10@yahoo.com

Thanks in advance.

How To Hide GrandTotal In Crystal Report While One Prodcut Selected In VB Combo &amp; Pass
Hi friends,

            In my form I am having a combo box which lists the ProductNames and command button to display the report, in that combo I am adding all the product name from database during the Form_activate, If I choose One Product, the report shows the detail for that product while showing this it also shows the grand total, I want to disable the Grand Total, when I choose only a particular product, at the same time if the user chooses "All" in the Combo box" then at that time the grand Total should be displayed. Kindly if anyone knows how to hide the Grand Total while choosing a only one product, reply me. I am adding the records in combo box as below


while Not rs.EOF
combo1.AddItem rs!Product
rs.MoveNext
wend
combo1.AddItem "All" ' This is to diplay all the records when the user choose all
                                           from combo


Also suggest me if there is any way to reduce the window zoom percentage of Crystal Report through coding VB. If possible, kindly reply how to !

Thank you very much,
Chock.

<HTML>
<B><font color="#008000">HAVE A NICE DAY !</font></B>
<HTML>

Edited by - chs on 1/11/2003 5:59:01 AM

How Sum Values On Crystal Report?
--------------------------------------------------------------------------------

hi,
i want sum same values on my report for example
for display like this

page 1
hi1 = 100
hi2 = 150
hi3 = 300
hi1 = 100
hi2 = 150
hi3 = 300
hi1 = 100
total of page=1200

page2 & final page
hi2 = 150
hi3 = 300
hi1 = 100
hi2 = 150
hi3 = 300
total of all = 2200

i have tryed this:
sum({total.count})

but i have the total of values in first page the solution is using this line
if PageNumber<>TotalPageCount then
but even using this i get the total of values on first page
how can i do that?
anyone?
thanks a lot for your help

Crystal Report XI - Adding Values
I am using Crystal Report XI - Enterprise Edition

I have 2 MS Access Tables in the same db.
AlternateTable
dbOriginalPartNumber text 30
dbAlternatePartNumber text 30

StockQtyTable
dbPartNumber text 30
dbOnHand double
dbOnOrder double

dbOriginalPartNumber and dbAlternatePartNumber of the AlternateTable are linked to dbPartNumber of the StockQtyTable.

I pass a parameter and get the correct dbOriginalPartNumber and dbAlternatePartNumber of the AlternateTable. That code is working good(but not being shown).

What I need to do is to: add together the dbOnHand (StockQtyTable) for the OriginalPartNumber and the AlternatePartNumber. The same with the dbOnOrder field. Something Like this:

Code:
TotalOnHand = dbOriginalPartNumber dbOnHand plus dbAlternatePartNumber dbOnHand.
TotalOnOrder = dbOriginalPartNumber dbOnOrder plus dbAlternatePartNumber dbOnOrder
TotalOnHand and TotalOnOrder (assuming they are formulas) will then be placed on the form and there values will be printed.

Can you show me how to do this?

Copyright © 2005-08 www.BigResource.com, All rights reserved