I would have to see your set up to really help but here are some things to think about.
You can conditionally suppress fields or you can conditionally suppress sections (rows, headers, footers, etc). Sometimes you can do both by setting the section expert to suppress "blank sections" so when you suppress the fields if they all get suppressed that section also gets suppressed.
Also you may be running into issues about when to suppress the Gheader because it may contain rows that are changing based on the rest of the suppression. You can deal with this by using a formula field to "flag" a row a 1 or a 0 and then sum that on the group and conditionally suppres if the sum=0 (or >0).
For example you have 3 rows that may or may not be suppressed.
Create a formula to flag it based on your suppression critieria.
If fielda="this" and fieldb="that then 1 else 0 (generally a 1 inidcates not suppressed 0 indicates suppressed)
now the 3 rows have a 1 or a 0 on them. from there create a sum of that formula at your group level that you need to maybe suppress. Now your group header has 0 to 3.
You can conditionally suppress the header on that sum=0 (or >0 depending on your need). Sorry this is so abstract but I hope it helps give you some direction.
If you need help with it I would need to see some sample data in row format (I really have a hard time with XML codes) with the conditions that you want each part (row or headers) to be seen or not and I might be able to come up with a process for you.
Edited by DBlank - 22 May 2009 at 1:08pm
. Sound a little backwards? You would be right
.
The problem is we are really only creating templates for the information to be pulled into and cannot create Parameter fields as all the parameters are handled through the DataBase that we also create (My company that is). I have asked another Crystal developer that I work with who has been doing this longer and he seems a little stumped as well. I do appreciate your attempts though.
IP Logged
And while I will never get back the hours I spent trying to do some unnecessary task, I am extremely happy that my report runs properly and that I am finished with it.
