This content has been marked as final. Show 4 replies
say IND is the column you are checking for null and you dont want the rows where IND IS null
you can have the code like below
G_1 is the loop and IND is the checking column
Thanks for the quick reply.
I am actually confused with the code you have sent .In the code i see there are 2 columns AMOUNT and emp_id apart from Ind.I want to know that are you trying to give me an example with two columns or only one as i have only one column .My column is customers_added for which i want to hide the rows which are null or blank.
Thanks in Advance!!!
Edited by: user12263415 on Feb 4, 2013 7:52 AM
Edited by: user12263415 on Feb 4, 2013 7:55 AM
my intention in showing that sample like that is to just show how you can form code you can keep what ever the column needed between the for loop.
<?for-each:G_1[IND!='']?> you can keep any thing here <?end for-each?>
you can edit your for each loop code like above by keeping condition as i shown above . if you want to add multiple conditions for ind you can try like below
<?for-each:G_1[IND!='' or IND='0']?>
if you still have confusion you can try like this also
<?for-each:G_1?><?if:IND!=''?>YOUR COLUMNS <?end if?><?end for-each?>
Thanks Avinash for the reply
I will check with my code in the report and let you know whether it worked or not.
The code worked for me thanks once again for the help!!!
Edited by: user12263415 on Feb 4, 2013 12:59 PM