I'm having a problem with conditional suppressing.
I'm creating an insurance invoice. Originally, I created it so that each line of data was a separate section. Therefore if a client doesn't have the item in that line, the line is suppressed. For example
Disability Type 1
Disability Type 2
Disablitity Type 3
Subtotal Disability
Overhead 1
Overhead 2
Subtotal Overhead
Accident 1
Accident 2
Subtotal Accident
Unfortunately, this format allowed they types of insurances to be split into two pages if the invoice runs on that long. The page break must be after a Subtotal, not in the middle of an insurance type.
I tried to merge each type of insurance into one section. I conditionally suppressed each line if there was no data. The data itself does suppress, but a blank line is still there - so it looks like this.
Disability 1
Disability 3
Subtotal Disability
Overhead 1
Overhead 2
Subototal Overhead
Accident 2
Subtotal Accident
How can I write the conditional suppression formula to remove the line, as well as the data, so that it's all compressed together. Or, alternatively, is there any way that I can tell Crystal to ensure that multiple sections are "kept together", and not
just the data in one section.
ot supress one section in Crystal Reports 11, right click any blank space in the report field and take "section expert" under 'Report".
You will get a new window and select the particular section from 'sections' that you want to supress and in right side you can see "suppress (no drilldown" along with a formula button.
click on that butto write your condition and save the formula...
:)
hope this will help you ....
I'm using ASP.Net 2.0 and CR coming along with this.
You can't conditionally suppress one line in a multi-line section so that the space actually disappears. My workaround was to create multiple sections with the different combinations of data, and suppress each section if it was zero. For example
Section 1 - Single Coverage
Section 2 - Family Coverage
Section 3 - Single and Family Coverage
Wrote up the formulas for each section based on types of coverage. Suppressed each section if zero, so each person will only get one section showing up. It took awhile, and was a pain to write, but it did work.
It's pretty easy to suppress if zero within for any formula within a section. However, it doesn't actually get rid of the line/space where there data would be, it just leaves it blank. This was the issue for me, I needed it to disappear. As a result,
I had to write a separate section for each possibility, and suppress the entire section if it's blank. I've used a pretty basic if/then/else combination for just the one type of insurance - AD&D. There are six possible combinations that a member might have:
Single Coverage
Single Coverage with Tax
Family Coverage
Family coverage with Tax
Single and Family Coverage
Single and Family Coverage with Tax
I needed to keep each possibility within one section to ensure that the data wasn't split to two pages. Each section would have multiple data cells for premium amounts etc. . Therefore, each cell would be written with the formula
if {single coverage}>0 and {family coverage} =0 and {sales tax} = 0 then {premium}. This is what I'd use for every data cell for members who had single coverage with no tax. The formula would change, depending on the type of coverage.
Each cell is then suppressed if it's zero, and the entire section is suppressed if it's blank. The report now has 6 sections for this type of insurance, but only one will show up, depending on the combination of coverage the member has.
This worked well for me, because there was a limited amount of variables (only 6 possibilities). Because of the length of the invoice, this is only possible section that would possibly be split into two pages, so I didn't need to do this for the other types.
I think that if it got into more than 10 or so possibilities, it would be pretty overwhelming to essentially rewrite the report for every single possibility. This is really just a work-around.
apauls
Member
41 Points
44 Posts
How to conditionally suppress a line of data in a section
Nov 05, 2009 02:43 PM|LINK
Hi there -
I'm having a problem with conditional suppressing.
I'm creating an insurance invoice. Originally, I created it so that each line of data was a separate section. Therefore if a client doesn't have the item in that line, the line is suppressed. For example
Disability Type 1
Disability Type 2
Disablitity Type 3
Subtotal Disability
Overhead 1
Overhead 2
Subtotal Overhead
Accident 1
Accident 2
Subtotal Accident
Unfortunately, this format allowed they types of insurances to be split into two pages if the invoice runs on that long. The page break must be after a Subtotal, not in the middle of an insurance type.
I tried to merge each type of insurance into one section. I conditionally suppressed each line if there was no data. The data itself does suppress, but a blank line is still there - so it looks like this.
Disability 1
Disability 3
Subtotal Disability
Overhead 1
Overhead 2
Subototal Overhead
Accident 2
Subtotal Accident
How can I write the conditional suppression formula to remove the line, as well as the data, so that it's all compressed together. Or, alternatively, is there any way that I can tell Crystal to ensure that multiple sections are "kept together", and not just the data in one section.
Hope this is clear - any help is appreciated.
Thanks
joseabie
Participant
1165 Points
324 Posts
Re: How to conditionally suppress a line of data in a section
Nov 08, 2009 10:14 AM|LINK
ot supress one section in Crystal Reports 11, right click any blank space in the report field and take "section expert" under 'Report".
You will get a new window and select the particular section from 'sections' that you want to supress and in right side you can see "suppress (no drilldown" along with a formula button.
click on that butto write your condition and save the formula...
:)
hope this will help you ....
I'm using ASP.Net 2.0 and CR coming along with this.
apauls
Member
41 Points
44 Posts
Re: How to conditionally suppress a line of data in a section
Nov 12, 2009 04:41 PM|LINK
I figured this out if anyone's interested.
You can't conditionally suppress one line in a multi-line section so that the space actually disappears. My workaround was to create multiple sections with the different combinations of data, and suppress each section if it was zero. For example
Section 1 - Single Coverage
Section 2 - Family Coverage
Section 3 - Single and Family Coverage
Wrote up the formulas for each section based on types of coverage. Suppressed each section if zero, so each person will only get one section showing up. It took awhile, and was a pain to write, but it did work.
akashbutterf...
Member
2 Points
1 Post
Re: How to conditionally suppress a line of data in a section
Dec 21, 2009 01:35 AM|LINK
Hi,
Could you paste some sample about how to solve / make the formula to supress lines in Multi-line Sections
regards
Prakash
Post some samples to supress lines in Multi Line Sections
apauls
Member
41 Points
44 Posts
Re: How to conditionally suppress a line of data in a section
Dec 21, 2009 05:09 PM|LINK
It's pretty easy to suppress if zero within for any formula within a section. However, it doesn't actually get rid of the line/space where there data would be, it just leaves it blank. This was the issue for me, I needed it to disappear. As a result, I had to write a separate section for each possibility, and suppress the entire section if it's blank. I've used a pretty basic if/then/else combination for just the one type of insurance - AD&D. There are six possible combinations that a member might have:
Single Coverage
Single Coverage with Tax
Family Coverage
Family coverage with Tax
Single and Family Coverage
Single and Family Coverage with Tax
I needed to keep each possibility within one section to ensure that the data wasn't split to two pages. Each section would have multiple data cells for premium amounts etc. . Therefore, each cell would be written with the formula
if {single coverage}>0 and {family coverage} =0 and {sales tax} = 0 then {premium}. This is what I'd use for every data cell for members who had single coverage with no tax. The formula would change, depending on the type of coverage.
Each cell is then suppressed if it's zero, and the entire section is suppressed if it's blank. The report now has 6 sections for this type of insurance, but only one will show up, depending on the combination of coverage the member has.
This worked well for me, because there was a limited amount of variables (only 6 possibilities). Because of the length of the invoice, this is only possible section that would possibly be split into two pages, so I didn't need to do this for the other types. I think that if it got into more than 10 or so possibilities, it would be pretty overwhelming to essentially rewrite the report for every single possibility. This is really just a work-around.