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 RecordSelectionFormula 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 ".recordselectionformula = 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:
CrystalReportViewer1.SelectionFormula = "{vTITO_Rpt.WorkDate} In Date (" & Format(cmbxDateFrom.Text, "YYYY,MM,DD") & ") To Date (" & Format(cmbxDateTo.Text, "YYYY,MM,DD") & ")"

Regards

[QVeen72]

Hi,

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

m_Report.SelectionFormula = "{vTITO_Rpt.WorkDate} In Date (" & Format(cmbxDateFrom.Text, "YYYY,MM,DD") & ") To Date (" & Format(cmbxDateTo.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 .RecordSelectionFormula, 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

CrystalReportViewer1.ReportSource = New ReportName CrystalReportViewer1.ReportSource = ReportDocument
CrystalReportViewer1.SelectionFormula = "{vTITO_Rpt.WorkDate} In Date (" & Format(cmbxDateFrom.Text, "YYYY,MM,DD") & ") To Date (" & Format(cmbxDateTo.Text, "YYYY,MM,DD") & ")"
CrystalReportViewer1.Show()

Regards

[QVeen72]

Hi,

Syntax of SelectionFormula 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

[QVeen72]

Hi,

Selection formula syntax is OK.
But, Without Selection Formula, does your Code Work perfectly...?

Regards
Veena

[freedom]

HI Veena,

I tried to see check it on the crystal report "show formula" then I tried to used this in my code using the below syntax, it worked well. However, as you can see it was not based on the input on the combo box. It was manually inputted on the selection expert. Thanks

mySelectFormula = "{vTITO_Rpt.EmpNo} In Date (2007, 10, 08) to DateTime (2007, 10, 09)"

[QVeen72]

Hi,

I'am not sure, if this is correct..
In your selection formula you are saying "vTITO_Rpt.EmpNo"
Is EmpNo the Date field in table vTITO...?


Regards
Veena

[freedom]

Hi Veena,

Im sorry I posted a wrong one. Here is the code. Does it has something to do with the setting up of date format?Thanks.

mySelectFormula = "{vTITO_Rpt.WorkDate} In Date (2007, 10, 08) to DateTime (2007, 10, 09)"

[QVeen72]

Hi,

OK, How are the Values in ComboBox populated.
Post some sample data from Combobox.
also check the regional setting for Dates..


Regards
Veena

[freedom]

Hi Veena,

I forgot to tell you that my source here is a view and not a table. Also here is the sample data of the combo box

10/8/2007 12:00:00 AM
10/9/2007 12:00:00 AM
10/10/2007 12:00:00 AM

and so on.....

Thanks in advance

[freedom]

Hi Veena,

I got it working!! Thanks for your help. I declarde a variable and set it as date then pass the value of the combo box to it. Got it working now. Thanks for your help

Cheers!!