Crosstab problem

[atharindhi]

i want remove the column which is 0 from the report..(Plz refer the attachment)

i gave the following expression using Print When Expression Property

 

new Boolean ($V{TOTAL_SALESMeasure}!='0')

 

Here is the output i want

I have 3 tables in Oracle DB  Employee , Sales , Items

I want to take data to a cross tab with ENO ,Location,Total_Sales

But i want to remove location coloums which containing 0 sales or simply locations where no sales occur....

My idea is to remove colums that has 0 or null values..
How can i do it..

Im new to i-report

Plz help me

 

 

 

 

Code:

[dprogrammer]

You can try filtering it in your query's WHERE clause. Something like

Select ....

Where

TOTAL_SALESMeasure<>0

 

[atharindhi]

Thanx for it..
It gives the output i want..
But how can i make a metrix report using i-reports..
Do u have links for good tutorials ...??

 

Thanx in advance...