how can i pass values from .mdb to crystal report?

how can i pass values from a text box to crystal report.the value is not stored in the database.please help me...Pass it as a parameter.

Create a parameter field in the report.

Then pass the value for the parameter from ur interface to report in the folg. way

Cr1.ParameterFields.GetItemByName("EnterOption").AddCurrentValue(ParamOption)

Here EnterOption is the name of the parameter created in Crystal Reports and ParamOption contains some value which u want to pass (any value)

Hope this may help|||Thanks ,
But its not working.I got an error message like this "Argument not optional". Pls explain the reason and do help me with sample code
Thanks
Hari|||Hope you are using VB code for creating interface
--------

'In the General Declarations , declare

Dim Appl As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report

'Assinging the report name
Set Report = Appl.OpenReport("report1.rpt")
Report.DiscardSavedData
'Passing the value of cmboption.Text value to the first parameter
'instead of passing by the name of the parameter, we can also use this convention
Report.ParameterFields(1).AddCurrentValue cmbOption.Text

'Assigning the report source to CRViewer Control and viewing the report
CRViewer1.ReportSource = Report
CRViewer1.ViewReport

--------

If your code produces error, send the code fragment|||There are 3 ways to deal with this/your problem or setting/passing arguments to a report :

Sample 1
---
g_ole_crx_report.DiscardSavedData()
g_ole_crx_report.ParameterFields.item[1].AddCurrentValue("100200300")

Sample 2
---
g_ole_crx_report.DiscardSavedData()
g_ole_crx_report.ParameterFields[1].AddCurrentValue("100200300")

Sample 3
---
g_ole_crx_report.DiscardSavedData()
g_ole_crx_report.ParameterFields.GetItemByName("@.AccountNumber").AddCurrentValue("100200300")

Sample 4
---
g_ole_crx_report.DiscardSavedData()
g_ole_crx_report.ParameterFields.item[3].AddCurrentValue(date("01/01/1999"))

Look at this sample. It needs conversion. You need to use convert function like date (I dont' know about VB) to convert date to date format.

Maybe this is what causing your problem.

Thanks

How can I import a MDB database into SQL 2005 ?

Hi, could you tell me how can I do the "migration Wizard" for import data
from Access MDB to SQL 2005 ?
Thanks
Javier
I am using the free version of SPAMfighter for private users.
It has removed 9800 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!
Regarding SQL Server 2005, you should probably post to the beta newsgroups.
You will probably receive more help there since that is the place that
questions related to SQL Server 2005 should be asked.
http://communities.microsoft.com/new...r2005&slcid=us
If you want to access the newsgroups via your newsreader just scroll through
the top right hand frame for connection information
Keith
"JAV" <mask@.impsat1.com.ar> wrote in message
news:uGFVOW%23gFHA.3436@.tk2msftngp13.phx.gbl...
> Hi, could you tell me how can I do the "migration Wizard" for import data
> from Access MDB to SQL 2005 ?
> Thanks
> Javier
>
> --
> I am using the free version of SPAMfighter for private users.
> It has removed 9800 spam emails to date.
> Paying users do not have this message in their emails.
> Try www.SPAMfighter.com for free now!
>

How can I import a MDB database into SQL 2005 ?

Hi, could you tell me how can I do the "migration Wizard" for import data
from Access MDB to SQL 2005 ?
Thanks
Javier
I am using the free version of SPAMfighter for private users.
It has removed 9800 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!Regarding SQL Server 2005, you should probably post to the beta newsgroups.
You will probably receive more help there since that is the place that
questions related to SQL Server 2005 should be asked.
http://communities.microsoft.com/ne...lcid=us

If you want to access the newsgroups via your newsreader just scroll through
the top right hand frame for connection information
Keith
"JAV" <mask@.impsat1.com.ar> wrote in message
news:uGFVOW%23gFHA.3436@.tk2msftngp13.phx.gbl...
> Hi, could you tell me how can I do the "migration Wizard" for import data
> from Access MDB to SQL 2005 ?
> Thanks
> Javier
>
> --
> I am using the free version of SPAMfighter for private users.
> It has removed 9800 spam emails to date.
> Paying users do not have this message in their emails.
> Try www.SPAMfighter.com for free now!
>

How can I import a MDB database into SQL 2005 ?

Hi, could you tell me how can I do the "migration Wizard" for import data
from Access MDB to SQL 2005 ?
Thanks
Javier
--
I am using the free version of SPAMfighter for private users.
It has removed 9800 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!Regarding SQL Server 2005, you should probably post to the beta newsgroups.
You will probably receive more help there since that is the place that
questions related to SQL Server 2005 should be asked.
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
If you want to access the newsgroups via your newsreader just scroll through
the top right hand frame for connection information
--
Keith
"JAV" <mask@.impsat1.com.ar> wrote in message
news:uGFVOW%23gFHA.3436@.tk2msftngp13.phx.gbl...
> Hi, could you tell me how can I do the "migration Wizard" for import data
> from Access MDB to SQL 2005 ?
> Thanks
> Javier
>
> --
> I am using the free version of SPAMfighter for private users.
> It has removed 9800 spam emails to date.
> Paying users do not have this message in their emails.
> Try www.SPAMfighter.com for free now!
>