User-982972619 posted
Hi tbraga, I think I have the answer for your problem dude. You said you want to pass a date parameter I can give you some solution I suppose:
--First, If you want your report by default showing the date that you want, you can use "Record Selection Formula Editor" you can find it in right click in the blank space of your report then choose Report>>Edit Selection Formula>>Records...
After that you can put this formula:
{Table1.DateShipments} = #27/12/2007# or if your field database isn't a datetime type you can use: Date({Table1.DateShipments}) = #27/12/2007#
Or if you want to give a date range write this down {Table1.DateShipments} >= #27/12/2007# and {Table1.DateShipments} <= #1/1/2008#
--Secondly, if you want to pass the parameter from the webform, well let say you have a datetime picker and when you choose the date you pass the date to a textbox and click the submit button, you can use this:
1 private void Button1_Click(object sender, System.EventArgs e)
2 {
3 if(TxtDate1.Text !="" && TxtDate2.Text!="")
4 {
5 CrystalReportViewer1.Visible = true;
6 CrystalReportViewer1.SelectionFormula = " Date({Table1.DateShipments})>= #" + TxtDate1.Text+ "# And Date({able1.DateShipments})<= #" + TxtDate2.Text + "#";
7 CrystalReportViewer1.RefreshReport();
8 }
9 }
That code above if you want to give a range on your date parameter, if you don't you just simply put only one text box.
Good luck dude hope it helps, let me know if it's work out for you.
Regards.
--Please put Mark as Answer, if my post helps you Thanks. Good Luck.
