Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Show only blank subreport? Post Reply Post New Topic
Author Message
althomas
Newbie
Newbie


Joined: 09 Nov 2010
Online Status: Offline
Posts: 36
Quote althomas Replybullet Topic: Show only blank subreport?
    Posted: 12 Aug 2013 at 6:07am
Hello,
is it possible show only blank subreports? i know there is a option to supress blank subreports, but i want to do the opposite by showing only blank subreports. I have created a report with manufacturing part numbers in the main report. Then i created a subreport with the Bill of materials for the mfg parts. I want to know what parts in the main report does not have a Bill of Material. So, i want to see only the blank subreport under the main report parts. I could then advise our engineering team to create a bill of materials for those parts missing the details.

Thanks for your help in advance.
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 12 Aug 2013 at 6:42am

Hi,

Try the below process, it may help you.

In each Subreport count the "Bill of Materials" and store in a Shared Variable.
Based on the Shared Variables we need to suppress the Sub reports.
For example if a subreport contains Bill of Material values then the recordnumber will capture the count of that field.
then we need to write the suppress condition in the main report sections as

if sharedVariable >=1 then true

HTH.

--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.015 seconds.