Dear Friends
I am using crystal reports 8.5 with MS Access database. I need to generate customer listing while accepting 6 paramerts from user (From/To Country, From/To Province, From/To City). Currently using following formula for selection:
if {?ContFr} = "ALL" then
if {?ProvFr} = "ALL"...
and yes here is the record selection now:
If {?ProdFr} = "ALL" Then
{QryOrder.OdetStatus} <> "S"
else
{QryOrder.OdetStatus} <> "S" and
{QryOrder.ProdDesc} in {?ProdFr} to {?ProdTo}
Hi ..
Oh mannn it was just sooo simple but as I said I was just stuck with it ... Thanx a million my dear friend you have just solved my issue :D ... I have passed "ALL" in both parameters and checked them in record selection and it is working perfect :))
By the way i am simply checking...
OK let me explain it a further ...
The report is designed to display product wise sale records
In VB Form I am accepting a range FROM PRODUCT and TO PRODUCT thru comboboxes as follows:
cmbProdFrDesc
cmbProdToDesc
In Crystal Report I have defined two String parameters to accept above mentioned...
Hey Guys
Good Day!
I just need to ask a very simple question but stuck with it ..
I am using VB6 with crystal reports 8.5 ... I have created a report which lists product wise sales details .. defined 2 parameters, FROM PRODUCT and TO PRODUCT ... In VB form prompting via combobox with all...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.