Record Selection in Crystal Reports 9 using VB.net

[freedom]

How to use the record selection formula in CR9 programatically using vb.net? I have a combo box that displays the date. If I select date, I can generate a report based on the selected date. Thanks in advance

[QVeen72]

Hi,

Pass this RecordSelection Formula to the Report:

m_Report.RecordSelectionFormula ="{MyTable.MyDateField} =Date(" & Format(Combo1.Text,"yyyy,mm,dd") & ")"
 

Regards
Veena

[freedom]

Ah, I see, that's what Im missing, I acutally used that ".recordselecti onformula = Date & " combbox.text... .and it says a date-time is required here... I guess this is what Im missing. Thanks for your response. I check it out.

[freedom]

Hi Veena,
I tried to used this in my record selection, however, I received an error, "The ) is missing" when I checked it, any part here that I missed? thnks.

VB code:
CrystalReportVi ewer1.Selection Formula = "{vTITO_Rpt.Wor kDate} In Date (" & Format(cmbxDate From.Text, "YYYY,MM,DD ") & ") To Date (" & Format(cmbxDate To.Text, "YYYY,MM,DD ") & ")"

Regards

[QVeen72]

Hi,

For CR9, it .RecordSelectio nFormula.
Looks like, you have not declared the Report Object..
What code are you using to display the report...?
Check this :

m_Report.Select ionFormula = "{vTITO_Rpt.Wor kDate} In Date (" & Format(cmbxDate From.Text, "YYYY,MM,DD ") & ") To Date (" & Format(cmbxDate To.Text, "YYYY,MM,DD ") & ")"


Regards
Veena

[freedom]

The "m_report" here you use is the Crystal Report viewer, right? I'm using CR9, tried to use the .RecordSelectio nFormula, but it's not working. I tried to use the previous post you have here but still to no avail. What do I miss here? Thanks

[QVeen72]

Hi,

Post your complete code here..
It will be easy for me to Identify..

Regards
Veena

[freedom]

Hi Veena,

Here is my code I used, I can't find what's seems to the error here, but everytime I used it, I encountered the error "The ) missing" . Thanks in advance

CrystalReportVi ewer1.ReportSou rce = New ReportName CrystalReportVi ewer1.ReportSou rce = ReportDocument
CrystalReportVi ewer1.Selection Formula = "{vTITO_Rpt.Wor kDate} In Date (" & Format(cmbxDate From.Text, "YYYY,MM,DD ") & ") To Date (" & Format(cmbxDate To.Text, "YYYY,MM,DD ") & ")"
CrystalReportVi ewer1.Show()

Regards

[QVeen72]

Hi,

Syntax of SelectionFormul a seems OK,
Did you check both the combo-boxes, have data..?
You may get error, if either one of them is Blank...

and FromDate < ToDate..?

Regards
Veena

[freedom]

Hi,

Yes, both combo boxes has data, I even tried to change the combo box to text box, inputting the date manuallu, but to no avail. Can we say that the code is ok?

Thanks