Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 13 Jan 2009 at 6:38am
I don't know about the error, but there is a part of me that says 180 sections is too many and that there has to be a better way of organizing your data.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 13 Jan 2009 at 6:41am
as a follow up, how is that broken up?
Could you reduce sections if you made the data displayed in a group/section conditional on a formula? then you could have the same layout and just change the value in the cell based on a formula.
Is that 180 section 180 group headers or 180 detail lines? Do they all display at the same time?
Sorry, I am just stunned that any report would need that many sections.
Joined: 22 Dec 2008
Location: India
Online Status: Offline
Posts: 5
Posted: 13 Jan 2009 at 6:52am
Hi,
Actually accourding to requirement we may have to show the all 180 fields on report but we also need to hide the field and it's value if it doesn't have valid value.
So to avoid the blank space created after suppress, we have created separate section for each field and it's value. We are suppressing the section on the basis of field value.
If you have any other solution for this situation, do write your solution.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum