asked on

How do I select a register between dates in crystal Report

I need to find a register or do a report between dates.ei:
from date1 to date2.. all the register among this dates. what formula do i need or put in the SelectionFormula en crystal report in visual basic 5

ASKER CERTIFIED SOLUTION

CraigLazar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sllanes

ASKER

i would like to know also if there is a way to pass variables to a sql statement as:
Select * from prueba where date between #month/day/year# and #month/day/year#
....
where month day and year coul be variables where a user can modefied from the aplications like inputboxes o a textbox..
and change the month and day and year,,, values..is it possible? is it possible, how is it?

CraigLazar

hi
ok here is some sample sql strings that hold date and string values
SQL Strings used to set up record sets

1) Standard select statement bringing back one vale
SQL = "select [Commission] from employee where name = '" & txtEngineer & "' ;"

2) String to select 2 columns from 1 table and bring back values according to criteria
SQL = "select [Commission],[HourlyRate] from employee where name = '" & txtEngineer & "' ;"

3) String used to return set of records according to 2 date values given
SQL = "Select * from capture where DateCap >= #" & StartDate & "# and DateCap<=#" & EndDate & "#;"

hope it helps

Craig

sllanes

ASKER

thanks craig it help a lot.. thanks work good.. but another thing.. have you get an error like this before.. after instaling the aplication...and when you click to get the report.. appears this::::
run time error 20504 report not found... i check the source and the code and all appears good.. what do you think?