Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: mrcool on 28 Oct 2005 06:30:46 AM

Title: [Solved]How do you hide an empty List on a report
Post by: mrcool on 28 Oct 2005 06:30:46 AM
HI frnds can anyone tell how to hide empty list on a report.....



Thnx,
S
Title: Re: How do you hide an empty List on a report
Post by: sir_jeroen on 28 Oct 2005 06:36:04 AM
Read the board rules: Search first then ask
Title: Re: How do you hide an empty List on a report
Post by: mrcool on 28 Oct 2005 08:26:49 AM
i searched and i didnt find any....
Title: Re: How do you hide an empty List on a report
Post by: sir_jeroen on 28 Oct 2005 10:48:37 AM
search for empty list
Title: Re: How do you hide an empty List on a report
Post by: mrcool on 29 Oct 2005 06:18:22 AM
Ya i searched for empty list but it dsnt suit my requirement.I want to hide complete list in teh absence of data or when we pass wrong parameters.I took new query and applied count on parent query.If the count is zero the list will hide.but iam unable to hide the headers in the process.Only columns are getting hidden.



Thanks,
S
Title: Re: How do you hide an empty List on a report
Post by: Near on 09 Nov 2005 02:33:51 PM
Hey,

Try changing the List "Box Type" attribute to "None"
Title: Re: How do you hide an empty List on a report
Post by: bdybldr on 07 Dec 2005 11:29:48 AM
I would suggest you use a conditional block.Ã,  Define your variable (count = 0) as boolean.Ã,  Add a conditional block to the report.Ã,  Under properties, select the conditional block line and select your variable.Ã,  On the current block line, select the value "No" and CUT and paste the list into the conditional block.Ã,  Then change the current block value to "Yes" and leave the conditional block empty.Ã, 

Hope this helps
Title: Re: How do you hide an empty List on a report
Post by: mrcool on 08 Dec 2005 12:49:20 AM
Thanks frnds for ur postings.
Text only | Text with Images