Help in report for missing fields

[shyamsundar]

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 = &quot;select a,b,(a*b) as value from table&quot;
else
qry = &quot;select c as value from table&quot;
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

 

[bergers]

Start your else line with
qry = &quot;SELECT 0 AS a, 0 AS b, c etc.
Hope this helps!
Kindest regards