how to pass text box value to report

[sajankk]

hi all,

i want to pass the text box value from the VB6 form to crystal report. am using cystal report 8.0. please help me it is urgent.....


saj

[VBFnewcomer]

I am not sure about CR8. In CR9 you can simply pass sql to the queryString method.

Dim appln As New CRAXDDRT.Application
Dim Report As New CRAXDDRT.Report
Private Sub Form_Load()
    Set Report = appln.OpenReport(Location of your reportfile & "\reportname.rpt")
    Report.Database.Tables(1).Location = Location of your database & "\databasename.mdb"
 
  Report.SQLQueryString = SQL
    CRViewer91.ReportSource = Report
    CRViewer91.ViewReport
End Sub

Include the reference to CRviewer Control 9

[nUflAvOrS]

You can try add a formula fields to Crystal Report

if you are using crystal report control component

try this

With crystalreportCtrl
    .reset
    .Datafiles(0) = -- your database path --
    .ReportFileName = -- your crystalreport path --
   .Formulas(0) = "YourFormulaName = '" & textbox1.text & "'"
   .Action = 1
 
end with

[sajankk]

it is not working with CR8.

[zeezee]

Use a parameter field

Reports.ParameterFields(0) = "paramName;" & text1.text & ";true"

Note: This is using the ReportViewer Component. But I think the concept is same.
Parameters are accessed by thier index
.ParameterFields(0)
And the order has to be the EXACT order in the report.

[Hack]

Moved to reporting

[sajankk]

hi guys,

still i didnot get the result. any suggestions. i try all the way u people suggested. but still the value is not coming to the report. please help in this regards


saj

[zeezee]

Could you post your code please. And if possible, the report also.
The parameter field works well with reports. If you use a parameter field, if thats not passed, the report viewer it self would prompt to that.
What are you using, Report Viewer control or Crystal Report component?

[sajankk]

Could you post your code please. And if possible, the report also.
The parameter field works well with reports. If you use a parameter field, if thats not passed, the report viewer it self would prompt to that.
What are you using, Report Viewer control or Crystal Report component?

am using crystal report component. tomorrrow only i can post u my code.

[zeezee]

am using crystal report component. tomorrrow only i can post u my code.

in CR Component it shoud be like this.

Assume your report source name is m_Report

m_Report.ParameterFields(1).AddCurrentValue "testValue"

[bhamres]

Hi ,

i want to pass two values that is Date from form to Datareport as parameter to command where the command is.
SELECT * FROM DD where date_col_1 <= DD_DATE and date_col_2 >= DD_DATE

[nick2k3]

Hi ,

i want to pass two values that is Date from form to Datareport as parameter to command where the command is.
SELECT * FROM DD where date_col_1 <= DD_DATE and date_col_2 >= DD_DATE

try parameters....i think it has a parameter class info back in vb 6. ofcourse you will have to have thesame name and order of parameters in both your code and report....

[bhamres]

want to create an application for database like add delete update options.
plz can u send me the sample application or code.Actually i did for add option but i wont able to create for update and delete.How to modify particular record and delete particular record

[zeezee]

What you ask is something you wont get easily in here. Here you would get answers to your problems, but I dont think any body would code for you. (I may be wrong.)
BTW, you have to open a new thread for your problems since the OP asks about crystal reports , neither Data Base question Nor Data Reoport question.

[mabbas110]

I would prefer that you create sp and pass two parameters in parameters. That parameter will aslo come in report with the same name added "@" , after that u just need to pass report parameters from code and you can get the desired result. Let me know if my point is clear or not.

[zeezee]

I would prefer that you create sp and pass two parameters in parameters. That parameter will aslo come in report with the same name added "@" , after that u just need to pass report parameters from code and you can get the desired result. Let me know if my point is clear or not.

You mean a SP in the DB? or CR?

BTW, I wonder whether the OP has got his answer or not