Problem with suppressing
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20771
Printed Date: 06 May 2024 at 4:45am
Topic: Problem with suppressing
Posted By: amola
Subject: Problem with suppressing
Date Posted: 28 May 2014 at 12:09pm
Hello All,
I'm having problem suppressing the detail sections (Detail Section A and Detail Section B) on my report.
I would basically like to hide the Detail Section B if {Invoice_Details_Prn.sLineCode} in ["1", "2", "6","7","Q","Q1"] and display Detail Section A.
Similarly, if the {Invoice_Details_Prn.sLineCode} in ["CL", "FR"] then display Detail Section B and hide Detail Section A.
Any help on this will be greatly appreciated. Thanks.
|
Replies:
Posted By: hilfy
Date Posted: 29 May 2014 at 3:05am
1. Right-click in the grey area to the left of Detail Section A and select "Section Expert".
2. Click on the formula button to the right of the "Suppress" checkbox (DO NOT check the checkbox!).
3. Enter the following:
{Invoice_Details_Prn.sLineCode} in ["CL", "FR"]
4. Save.
5. Select Details Section B in the Section expert and follow steps 2-4 above using the following formula:
{Invoice_Details_Prn.sLineCode} in ["1", "2", "6","7","Q","Q1"]
-Dell
------------- Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|