Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Easy question from sending parameters from vb6 to crystal report

Hello there fellow coders!!
I got stupid question i've been fighting for too long... :)
I have program where user can choose day from dtpiker and CR would show records.
how can i send this date from vb6 to crystal report so it would only show records which are stamped that date.
like "SELECT * FROM XXX WHERE Stamp =" & dtpicker1.value
i'm having problem to send that dtpicker1.value to crystal report.

Thank you !!!

  • 2
1 Solution
What problem are you having?

What code are you using?

CR does not allow the SELECT part to be changed by an application.

rpt.RecordSelectFormula = "{ViewName.Stamp} = " & dtpiker

Since it is a date you might have to use

rpt.RecordSelectFormula = "{ViewName.Stamp} = '" & dtpiker & "'"

If the problem is that you aren't selecting any records it may be that STAMP is a datetime field and the time values don't match.


Glad I could help


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now