hi,

I have a report in report 6 which has static field where values are shown for previous year and for current year. the output of the report will be like this

sl no department prev year cur year
01 revenue 2000 5000
02 costing 500 1000
03 excise 8000 900
and so on....

I have a created a fomula field for each and every department and get the value from a particular table. What i require is if suppose the department revenue does not have any value then that row should not be visible. for eg if revenue has a null value then the report should be like this

sl no department prev year cur year
01 costing 500 1000
02 excise 8000 900

Is it possible . if so pl suggest me the methods

thanks in advance

Hi Narayan,
What i will do for this query is that rather than creating a formula column i will bring every thing in SQL query.
Example.
select
sl_no, department, prev_year, cur_year from revenue_history
where prev_year is not null and cur_year is not null;


This will only bring rows that have revenue for both the years.

What do you think?

thank you.

i will try it out and let you know

Ok, Cool

Also you can create view with same code it may look like
Create view RESULT as
select
sl_no, department, prev_year, cur_year from revenue_history
where prev_year is not null and cur_year is not null;
Select * from RESULT: