shyamsundar
Programmer
on click event of a button, I have created a dynamic query, and open a report based on query.
Now the problem is, in query a value is calculated from field a & field b, some times there is no value is given for a and/or b then the value is take directly from field c
for examples
if a <> 0 and b<>0 then
qry = "select a,b,(a*b) as value from table"
else
qry = "select c as value from table"
endif
if it is first case no problem, if it is second case it is prompting for a value and b value, as there are fields for this in the report. how to overcome this.
Please help
Shyam
cwizshyam@yahoo.com
Now the problem is, in query a value is calculated from field a & field b, some times there is no value is given for a and/or b then the value is take directly from field c
for examples
if a <> 0 and b<>0 then
qry = "select a,b,(a*b) as value from table"
else
qry = "select c as value from table"
endif
if it is first case no problem, if it is second case it is prompting for a value and b value, as there are fields for this in the report. how to overcome this.
Please help
Shyam
cwizshyam@yahoo.com