Crystal Report Selection Formula Problem 
Author Message
 Crystal Report Selection Formula Problem


My problem is I have a report made in Crystal Reports which I want to be
filtered to only include a specific date range.
I use two MaskedEditBoxes for the user to enter the dates involved, how do I
use the SelectionFormula property ?

This is my current code:

StartDate = Format(MaskEdBox4, "dd/mm/yyyy")
EndDate = Format(MaskEdBox5, "dd/mm/yyyy")

For c = Format(StartDate, "0.00") + 1 To Format(EndDate,"0.00")

Next c
CrystalReport1.SelectionFormula = tx

------END OF CODE------
As you can see, this is rather stupid, and if I choose a long date range
that the code fails since I soon approach the 256 bytes limit of strings.

Can you please help ???

I'm desperate - I've 99% finished my project with only this left.


         Dani Ben-Amar
         Rapid Developments Ltd.

Sun, 25 Mar 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Sending Selection formula to open Crystal Report

2. HELP with selection formula in VB6 for Crystal Reports

3. Crystal Report V4.6 Selection Formula

4. Help with using date variable in Crystal reports selection formula

5. Crystal Reports Selection Formula

6. Help: Crystal Report Selection Formula

7. Help: Crystal Report Selection Formula


9. Crystal Reports Selection Formula

10. Crystal Reports-Selection Formula

11. crystal reports selection formula

12. reg. Crystal report selection formula date paramet


Powered by phpBB® Forum Software