var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem with a query for a report
I want to show fields on a report with the field is not equal to zero e.g.
my query has the following rows
headings: customer amount1 amount2
details: cust1 $200.00 $0.00
cust2 $50.00 $100.00
cust3 $0.00 $0.00
I don't want the fields with the zero amounts to show on my report. Each customer is displayed on a different page of the report.
Select * From tblMyTable Where Amount1 <> 0 And Amount2 <> 0;
Use this query as a datasource for your report.